Forum Discussion
Exploring integrating Google sheets with Power BI without compromising data
Hi. It used to be a public way that was insecure, but with the current Google Sheet connector I think it's pretty secure. Be sure that your link is not public from google sheets. You can try opening the URL in a browser private tab and it shouldn't open without login. Use that one in Power Bi Google Sheet connector. It will ask you to login in google to get the file.
https://powerquery.microsoft.com/en-us/blog/introducing-the-new-power-query-google-sheets-connector/
I hope that helps,
Hi. It used to be a public way that was insecure, but with the current Google Sheet connector I think it's pretty secure. Be sure that your link is not public from google sheets. You can try opening the URL in a browser private tab and it shouldn't open without login. Use that one in Power Bi Google Sheet connector. It will ask you to login in google to get the file.
https://powerquery.microsoft.com/en-us/blog/introducing-the-new-power-query-google-sheets-connector/
I hope that helps,
Thank you. It helped. Currently, there is Beta version available.
