Forum Discussion

BirdyM's avatar
BirdyM
Frequent Visitor
6 months ago
Solved

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!)   ...
  • vojtechsima's avatar
    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])