Forum Discussion
Helper I**Google Drive to PowerBi**
HI Cromero3000 ,
I'd like to suggest you take a look at following link about use power bi to get data from google drive files:
need help with Google docs data
Regards,
Xiaoxin Sheng
Super UserHi Cromero3000 ,
The excel file in Google Drive should be shared publicly for Power BI to be able to connect to it. If the data is confidential, you can use Data.world to sync with Google and then use the Data.World connector. You will have to set the scheduled data refresh right after syc is complete.
There are also third party-services (zapier, multcloud) that sync files between Googld and One Drive. Once synched, you can use the sharepoint connector to pull data.
Helper IHello danextian ,
Yes, it is public to Web, even with edit permissions. In fact Power Bi recognizes the link as a table but it never loads all the content, it just keeps loading and loading, and at the end it gives an error as shown below:
Regarding the third-party services, thank you for the suggestion, I will need to test it out. The thing about loading the files in Google Drive is so for everyone has access to modify the files instead of a corporate account so, I was trying to avoid paid apps or other apps but, I'll test what you mentioned before.
Thank you