Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
randyminder
Frequent Visitor

Power BI Service vs. SharePoint - Which to use?

Our company is trying to decide where the best place is to host their Power BI reports, Excel worksheets, Excel models and Power Pivot models. We have SharePoint Online and we're also going to be purchasing Power BI Premium (one node). It's not clear to us if it would be better to host these on Power BI Service or on SharePoint, and how to make that decision.

4 REPLIES 4
Xorba
New Member

I read that a Power BI site in SharePoint Online is basically analogous to a Power Pivot Gallery in SharePoint.

We have to make sure to import our data to Power Pivot and not to worksheet.

In SharePoint BI, the maximum workbook size is 2GB.

henriquesilveir
Resolver IV
Resolver IV

@randyminder Hello if your company will buy premium use premium !

 

You will have a lot of features do use like Power BI embedded, you can publish into SharePoint 365 too.

 

Take a look in these article to understand about PBI Premium, Embedded and SharePoint 365.

 

Premium: https://docs.microsoft.com/pt-br/power-bi/service-premium

 

Embedded: https://docs.microsoft.com/pt-br/power-bi/developer/azure-pbie-what-is-power-bi-embedded

 

Sharepoint: https://docs.microsoft.com/pt-br/power-bi/service-embed-report-spo

 

I Reccomend you to use the maximum of Premium it is the 'dream of PBI Developers' lol! 🙂

 

 

 

 

 

Thank you for the response! If we go with Power BI Service (via Premium), can we have our datasets, Excel spreadsheets and Power Pivot models refresh on a schedule? I think this is possible but wanted to verify.

Yes, it is possible, but for each type of source you must set their refresh.

Take a look into microsoft documentation to got all information necessary.

 

https://docs.microsoft.com/en-us/power-bi/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors