March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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>
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
128 | |
90 | |
75 | |
56 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |