topic Re: Power BI solution for business in Report Server

Power BI solution for business

JustinDoh1 — Thu, 20 May 2021 22:57:35 GMT

I am trying to come up with best practice to use Power BI online for my/our company.

We have Azure SQL on the backend for Power BI reports, and we are moving everything into Microsoft space (One Drive or SharePoint).

We are trying to figure out the best way for users in our company to access Power BI online report in a central location (on a browser).

I thought SharePoint would be the best approach, but I don't know if there is anything else.

Is there different platform/template that users can centrally access Power BI online reports (on a browser)?

How does costs related to the license of each user to access Power BI reports work?

If we use SharePoint to access PBI reports, how does license cost differ from using PBI online reports directly?

Re: Power BI solution for business

v-janeyg-msft — Mon, 24 May 2021 03:22:48 GMT

Hi, JustinDoh1

If you want users to view reports in powerbi service(Regardless of whether the data is on onedrive or sharepoint), then the PRO license is essential. Unless the report is in premium capacity, then free users can view it. If you don’t mind, you can use 'publish to web' feature, as long as the publisher has a pro account.

Reference: Publish to web from Power BI - Power BI | Microsoft Docs

If you still have problems, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Power BI solution for business

JustinDoh1 — Mon, 24 May 2021 17:23:00 GMT

v-janeyg-msft Thank you for your feedback. I guess my focus is finding the best way for our company's employees to access the PBI reports in a central location. It appears that license fees would be same in either from Sharepoint site or directly from PowerBI link. I am so new to this, but what is common practice for business users to access PBI? I was thinking SharePoint would be easier way, but please let me know if there is other way or the best practice now days. As things are changing (as far as platform), I want to stay in a platform that would last long. Thanks.

Re: Power BI solution for business

v-janeyg-msft — Tue, 25 May 2021 03:16:06 GMT

Hi, JustinDoh1

I don't know if I understand it well. You said that SharePoint would be easier way. There are two ways to share reports in sharepoint: upload pbix desktop file and embed in sharepoint online. The former is not suitable for simply viewing reports, and the latter requires at least a PRO license.

Reference: Embed a report web part in SharePoint Online

And You can also share reports in pbi service: Share reports directly, grant user workspace/app access and etc. Also, If reports are not in the premium capacity, all users need a pro license to view.

Reference: Ways to collaborate and share in Power BI - Power BI | Microsoft Docs

Like this:

You can purchase a pro account separately, or you can purchase Office 365 E5 that includes a pro account.

Reference: Self-service sign up for the Power BI service as an individual - Power BI | Microsoft Docs

If I don’t get what you mean, please let me know.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.