Restrict the access in published report and export data option

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