Forum Discussion
import file from google drive
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...
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.
