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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mehaboob557
Resolver IV
Resolver IV

Restrict the access in published report and export data option

Hello All,
 
I need your suggestions or approach.
 
I need to know  whether it is possible to achieve this or any approches for the below scenario.
 
 Assume "TEST" is a company. It has 3000 branches across the globe. I want to share the embeded iframe all over the branches.
  1.  If "abc" branch wanna view the report(published embeded), it should only show thier data(i.e pre selected filter to that "abc" branch and hide other branches data).Is this possible? Because, i can't create 3000 reports using visula or page leve filteres and publish (or) I can't buy 3000 pro user licences also. I want any dynamic way.
  2. I want to give the export data option to that published report. Is this possible? Because, they need export the data also for the 3000 branches

NOTE: The published report will be embedded in website. So i need the restriced report with respect to that branch

 

Thanks a ton in advance

1 ACCEPTED SOLUTION
v-jiascu-msft
Employee
Employee

Hi @mehaboob557,

 

Do you mean "Publish to web"? If so, you have to consider the risk of privacy of your data. Publish to web makes the reports accessible to everyone on the Internet. Please refer to: service-publish-to-web.

 

Some suggestions according to your questions.

1. The RLS (Row level security) could be very helpful in your scenario. You can restrict the access in the rules of RLS. But it isn't available in Publish to web. Please refer to service-admin-rls.

2. That depends on your choice. Publish to web doesn't support "export data".

3. The Power BI premium would be a great option in your scenario. Please refer to: service-premium.

 

Best Regards,

Dale

Community Support Team _ Dale
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

2 REPLIES 2
v-jiascu-msft
Employee
Employee

Hi @mehaboob557,

 

Do you mean "Publish to web"? If so, you have to consider the risk of privacy of your data. Publish to web makes the reports accessible to everyone on the Internet. Please refer to: service-publish-to-web.

 

Some suggestions according to your questions.

1. The RLS (Row level security) could be very helpful in your scenario. You can restrict the access in the rules of RLS. But it isn't available in Publish to web. Please refer to service-admin-rls.

2. That depends on your choice. Publish to web doesn't support "export data".

3. The Power BI premium would be a great option in your scenario. Please refer to: service-premium.

 

Best Regards,

Dale

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

Thank you so much Dale

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors