Forum Discussion

Gareth Jayne's avatar
Gareth Jayne
Copper Contributor
Oct 19, 2018

Hiding Power BI Web Part if no PBI licnense

Hi everyone, I think I already know the answer to this question but thought I'd double check...

 

We are looking at using the Power BI web part on some of our SharePoint pages.  Not all of our users have Power BI Pro license though so if they access the page they get a message in the web part saying they don't have access to the report.  This doesn't look great so I wondered if there's any way to hide the web part if the user hasn't got a Power BI license?

 

Thanks in advance.

SharePoint Online

2 Replies

Sort By
  • Matt Coats's avatar
    Matt Coats
    Steel Contributor
    Oct 19, 2018

    Our organization got around this by setting unique permissions at the page level--if the user doesn't have a Pro license, they don't get to the page at all. That approach won't work if you need everyone to get to pages that happen to also have PowerBI reports in them, though.

  • Carol DeMuth's avatar
    Carol DeMuth
    Iron Contributor
    Oct 19, 2018

    We have limited users with Power BI Pro, so I came up with a workaround.  In PowerBI, you can open the report, then from the top menu of the report, choose File, publish to web.  Copy the embed code.  On the SharePoint page, I use the Embed web part and copy the embed code.  It's not as interactive as the full blown PowerBI web part, but it works for our staff to see the visuals without the need for a PowerBI license.  Not exactly what you were asking about, but if you look at the roadmap, they are working on web parts with audience filtering and that would limit the view to your select audience.  I'm just not sure of the release date.

Resources