Excel datasheet as source to Power BI from Google Drive without conversion to Google Sheets

[Medmbchr]

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

[amitchandak · Accepted 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>