Forum Discussion
Excel datasheet as source to Power BI from Google Drive without conversion to Google Sheets
Hi
I have an xlsx file in a Google Drive folder which I would like to use as my data source. However, it looks like I need to convert it to Google Sheets to use it.
How can I connect my PBI to my Excel sheet without conversion? Also, since information is confidential, I can't publish my Excel sheet online if needed.
Rgrds
Medmbchr , I tried a few ways, but for me, it only worked for option -> anyone has link
You will get URL
https://docs.google.com/spreadsheets/d/<ID>/edit?usp=sharing&ouid=<UID>&rtpof=true&sd=true
Change it to
https://docs.google.com/spreadsheets/d/<ID>/export?format=xlsx&uid=<UID>
1 Reply
Medmbchr , I tried a few ways, but for me, it only worked for option -> anyone has link
You will get URL
https://docs.google.com/spreadsheets/d/<ID>/edit?usp=sharing&ouid=<UID>&rtpof=true&sd=true
Change it to
https://docs.google.com/spreadsheets/d/<ID>/export?format=xlsx&uid=<UID>