Connect to google drive folder

[Ria_]

Hello,

I am trying to connect Power BI desktop to a google drive FOLDER that has several files inside. (This link is provided by the client) I want to be able to view all files data just like if I were to connect to a local folder with several files. 

I have made sure that the google drive folder shared link has edit ability but when I enter the URL into BI I cannot see any data. (Including view of what I see)

I usually edit the URL to reflect: /export?format=csv at the end of a google sheet and that works, but that is not working for the sharable link provided for the folder.

Has anyone been able to connect to a google drive folder? 

[tgpowerbi]

I still do not see a solution. Am I missing something here?

[venal · Accepted solution]

@Ria_ 

Can you please trty to refer the below links.

https://community.powerbi.com/t5/Power-Query/import-file-from-google-drive/td-p/43218

https://www.cdata.com/kb/tech/googledrive-odbc-power-bi.rst

If you have any queries, please let us know.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

BR

venal.

[300Int]

Same for me.

[Anonymous]

How to connect with folder?

This link is not very useful : https://www.cdata.com/kb/tech/googledrive-odbc-power-bi.rst

In my case, the steps mentioned on the above link are loading metadata only.

Please help..

[mtroiano]

Hi there,

I know this was marked as solved but I don't see a solution. I have 2 pretty distinct issues - if I try and connect to a google SHEET in google drive I get an HTML window that asks me to log in instead of data.

My second problem is I just want to store my excel files in Google Drive so they're not reliant on my computer being available. When I try, it says the connection doesn't work as an excel. 

Thanks,

m

[IngAndresRojas]

Hi there @mtroiano

Were you able to fix it? I'm having this very same issue.

Thanks!