0

I am currently working on a Power BI report, which uses Google Sheets as the data source. As there are no official connectors available, there are two ways to fetch data from sheets to Power BI: 1. Publish to web 2. Link sharing

In both methods, we need to provide a link to Power BI which consists of the ID of the particular spreadsheet. In 'publish to web', any individual with the link can view my data.

So my main concern is, how secure the link sits in power BI? Are there any chances of breach?

Improve this question

1 Answer 1

Reset to default
1

Your concern should not be how the link is secured in Power BI Service, but the existence of this link itself. Lets say the probability of leaking it from your IM/e-mail/correspondence is much higher than leaking from Power BI. You are sharing sensitive data for anonymous access. Don't do that! Find another way for reporting. Either use charting, etc. from Google Sheets, or if you need/must use Power BI, store the data in more convenient place. For example a database in the cloud (Azure SQL Database is a good one). Then build an ETL process to read your data from Google Sheets and push it to the database. This process will be fully authenticated and you will not expose your data.

Improve this answer
Sign up to request clarification or add additional context in comments.

6 Comments

Thanks a lot for sharing your views on this. In fact, I myself was thinking on the same lines. Can you please suggest the best ETL tool to get this done? I was thinking of Microsoft Flow to pull data from Google Sheets & then push in Azure SQL. Please guide further.
Unfortunately, I can't advise you which tool is "the best". This is quite subjective. I feel comfortable writing my own ETL for this, while others will prefer pre-made solution. Just use that one, which you feel comfortable with and you know best. If it works for you, it may be "the best" for you too :)
@AndreyNikolov, did you find a solution to this? I also have a similat requirement of securely storing the data in Azure SQL and using the ETL process.
@Gangula I know its too late. However, I just noticed your comment and wondering how google sheets publish to web is involved in your requirement since you are working with Azure SQL?
@PratikBhavsar, I actually am not yet working with Azure SQL but I'm planning to. So I was wondering how if it possible to do this.
|

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.