Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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.
I still do not see a solution. Am I missing something here?
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.
Same for me.
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..
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
Hi there @mtroiano
Were you able to fix it? I'm having this very same issue.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.