Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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>
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |