The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
@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>
@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>