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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
BattPS
Regular Visitor

Help with Sharing Reports

I am using Power Bi Desktop to produce a series of reports that I now want to share with two of my colleagues in a local charity.  The data for the reports is derived from CRM and Excel files, using direct links.  It is important for my colleagues to have access to the reports, using SharePoint/Teams and to be able to refresh the data from within each report.

Can we achieve this with Desktop or do we need to subscribe to Pro or another upgrade option?

2 ACCEPTED SOLUTIONS
v-zhangti
Community Support
Community Support

Hi, @BattPS 

 

Yes, you can share Power BI reports with your colleagues using SharePoint or Teams. You can publish your Power BI report to the Power BI service and then embed it in a SharePoint page or Teams channel. Your colleagues can then view the report and refresh the data from within the report.

 

To embed a Power BI report in SharePoint or Teams, you can use the Power BI web part for SharePoint or the Power BI app for Teams. The Power BI web part allows you to embed a Power BI report in a SharePoint page, while the Power BI app for Teams allows you to embed a Power BI report in a Teams channel.

 

To refresh the data in the report, your colleagues will need to have access to the data source and the necessary permissions to refresh the data. If the data source is an Excel file, they will need to have access to the file and the necessary permissions to refresh the data. If the data source is a CRM system, they will need to have access to the system and the necessary permissions to refresh the data.

 

You do not need to subscribe to Power BI Pro or any other upgrade option to share reports with your colleagues using SharePoint or Teams. However, you will need a Power BI license to publish reports to the Power BI service and to use the Power BI web part for SharePoint or the Power BI app for Teams.

Embed a report web part in SharePoint Online - Power BI | Microsoft Learn

Power BI service features by license type - Power BI | Microsoft Learn

 

Best Regards,

Community Support Team _Charlotte

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

 

View solution in original post

Thank you, Charlotte, for your detailed and very helpful reply.

View solution in original post

2 REPLIES 2
v-zhangti
Community Support
Community Support

Hi, @BattPS 

 

Yes, you can share Power BI reports with your colleagues using SharePoint or Teams. You can publish your Power BI report to the Power BI service and then embed it in a SharePoint page or Teams channel. Your colleagues can then view the report and refresh the data from within the report.

 

To embed a Power BI report in SharePoint or Teams, you can use the Power BI web part for SharePoint or the Power BI app for Teams. The Power BI web part allows you to embed a Power BI report in a SharePoint page, while the Power BI app for Teams allows you to embed a Power BI report in a Teams channel.

 

To refresh the data in the report, your colleagues will need to have access to the data source and the necessary permissions to refresh the data. If the data source is an Excel file, they will need to have access to the file and the necessary permissions to refresh the data. If the data source is a CRM system, they will need to have access to the system and the necessary permissions to refresh the data.

 

You do not need to subscribe to Power BI Pro or any other upgrade option to share reports with your colleagues using SharePoint or Teams. However, you will need a Power BI license to publish reports to the Power BI service and to use the Power BI web part for SharePoint or the Power BI app for Teams.

Embed a report web part in SharePoint Online - Power BI | Microsoft Learn

Power BI service features by license type - Power BI | Microsoft Learn

 

Best Regards,

Community Support Team _Charlotte

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

 

Thank you, Charlotte, for your detailed and very helpful reply.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.