Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Visualising SharePoint lists with Power BI

Some users in my organisation have discovered the "visualising SharePoint lists" feature in Power BI: https://powerbi.microsoft.com/en-in/blog/visualizing-sharepoint-lists-now-available-to-all-users...
Need Help
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    4 years ago

    Hi PetyrBaelish,

    I found this out the same way you did. There are lot of limitations in this feature which giving the Power BI admin team a headache.

    You are right, it is somehow "outside" of Power BI service, as it is published in the Sharepoint library, not a Power BI workspace. And there is not way to assign Premium capacity to that library, thus all users who want to view them need a Pro license. I hope they allow this to be publish into a Premium workspace in the future. Free license can still create the report, but cant publish it nor view published report.

    We decided to educate them on how to connect to the list from Power BI desktop and publish to a premium workspace. This way a free users can view it too.

    Here is a list of other limitations
    https://docs.microsoft.com/en-us/power-bi/create-reports/service-quick-create-sharepoint-list#considerations-and-limitations

    im following this post in case theres a solution.

Tutu_in_YYC's avatar
Tutu_in_YYC
Super User
4 years ago

Hi PetyrBaelish,

I found this out the same way you did. There are lot of limitations in this feature which giving the Power BI admin team a headache.

You are right, it is somehow "outside" of Power BI service, as it is published in the Sharepoint library, not a Power BI workspace. And there is not way to assign Premium capacity to that library, thus all users who want to view them need a Pro license. I hope they allow this to be publish into a Premium workspace in the future. Free license can still create the report, but cant publish it nor view published report.

We decided to educate them on how to connect to the list from Power BI desktop and publish to a premium workspace. This way a free users can view it too.

Here is a list of other limitations
https://docs.microsoft.com/en-us/power-bi/create-reports/service-quick-create-sharepoint-list#considerations-and-limitations

im following this post in case theres a solution.