Forum Discussion
BirdyM
6 months agoFrequent Visitor
Connecting to an Excel File in Sharepoint in Power BI Desktop - says need Pro Licence?!?!?
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!) ...
- 6 months ago
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])
vojtechsima
Super User
6 months agoHey, 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])