This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreGet Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.
Hi,
I have a client that maintains a sales bookings forecast report in a Google Spreadsheet file that is saved and updated within a Google Drive folder. When I follow the PowerBI process to "get data" via either a "Folder" or "URL" PowerBI only loads the meta data for the google spreadsheet and not the actual data.
How can I build a PowerBI report accessing data in a google spreadsheet stored within Google Drive?
Thanks.
I managed to connect to a google excel file using the following link:
https://docs.google.com/spreadsheets/d/AAXXXX/export?format=xlsx
Just substitute the red parts with the filename. The filename can be found when generating a shareable link:
Ruth from Curbal posted a youtube demo and an invoked function to make it even easier.
I would try a couple different troubleshooting things to try to sort this out. First, I would bring the file local, copy and paste and eliminate the Google Drive aspect completely. See if it works. If it does, then there's something up with Google Drive. If not, then it is something to do with the format of the Google Spreadsheet. If it is the latter, you could try some of the other import drivers, like import from Excel, etc. to see if you can get one of them to work.
You may find Ehren's response here useful: https://social.technet.microsoft.com/Forums/en-US/7b8a3017-72ae-40db-911f-34a50e95b928/using-power-q...
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 3 | |
| 1 | |
| 1 |