Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. 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>
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
109 | |
100 | |
95 | |
38 | |
37 |
User | Count |
---|---|
152 | |
125 | |
75 | |
74 | |
63 |