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
amay15
Frequent Visitor

Embed with report web part in SharePoint Online

Once the report is Added in web part in SharePoint Online. Then

 

1. How we can give read access to this report to Group of Users (1000 users +)

2. Once User have access to report - can they export Report  to Excel, CSV etc ?

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @amay15

1.

Please read through this article to learn how to provide access to the report

https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo#granting-access-to-reports

 

As for large mumber of users (a Group of Users (1000 users +)), you could add members to an AD group in PowerBI, then give access to the AD groups. (grant read-only permission for group)

automatically add new members to the AD group.

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

 

2.

the end user can export the report to excel when they have access to the report from Power BI Service.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

Export data is not available for users outside of your organization who are using a dashboard that has been shared with them.

 

Best Regards

Maggie

 

 

View solution in original post

4 REPLIES 4
v-juanli-msft
Community Support
Community Support

Hi @amay15

1.

Please read through this article to learn how to provide access to the report

https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo#granting-access-to-reports

 

As for large mumber of users (a Group of Users (1000 users +)), you could add members to an AD group in PowerBI, then give access to the AD groups. (grant read-only permission for group)

automatically add new members to the AD group.

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

 

2.

the end user can export the report to excel when they have access to the report from Power BI Service.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

Export data is not available for users outside of your organization who are using a dashboard that has been shared with them.

 

Best Regards

Maggie

 

 

Thank you for comments. Regarding point 2 - Users are not outside organization & i want to know if they can export from report web part in SharePoint Online instead from Power BI service?

 

Regards,

Amay Singh

Hi @amay15

As tested, yes, they can!

12.png

 

Best Regards

Maggie

Thank you for your quick reply. This really helps!!!!

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