Solved: Connecting to an Excel File in Sharepoint in Power...

BirdyM · ‎03-13-2026

Why would one of my users gets this message? He is using Power BI Desktop and a Pro licence isn't required for Desktop! However, I can connect to it without issues (I have a Pro licence!)

Thanks,

Michelle

vojtechsima · ‎03-15-2026

Hey, @BirdyM ,

That's extremely strange indeed. I wonder whether Excel uses some Embedded Power BI stuff, but that would be kinda weird, I guess you can just double-check the connector you use.

This works the best:

= SharePoint.Contents("https://tenant.sharepoint.com/sites/siteName", [ApiVersion=15])

✔
Any kudos or recognition appreciated. To learn more on the topic, check out my blog and follow me on LinkedIn.

View solution in original post

vojtechsima · ‎03-15-2026

Hey, @BirdyM ,

That's extremely strange indeed. I wonder whether Excel uses some Embedded Power BI stuff, but that would be kinda weird, I guess you can just double-check the connector you use.

This works the best:

= SharePoint.Contents("https://tenant.sharepoint.com/sites/siteName", [ApiVersion=15])

✔
Any kudos or recognition appreciated. To learn more on the topic, check out my blog and follow me on LinkedIn.

tayloramy · ‎03-13-2026

Hi @BirdyM,

This is interesting, I've never seen that before in Powr BI Desktop.

What version of Power BI Desktop is being used, and what connector is being used to access the excel file from sharepoint (Web, SharePoint Folder, etc)?

If you found this helpful, consider giving some Kudos.
If I answered your question or solved your problem, mark this post as the solution!
Join the Fabric Discord!

Proud to be a Super User!