Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
Hi,
We are planning on embedding power bi reports in our application. But, we are confused about a couple of things-
1. Will the end-users be able to right-click on the plot and select 'Show data point as a table' which then allows them to export the data? Will it require the dataset to be in the premium capacity or pro is enough?
2. If they are able to export it, can we control the accessibility by read-only and write only based on ADD?
3. Do the end-users need Power BI Pro licenses to access the report?
Solved! Go to Solution.
Hi @gokarajumv ,
"Will the end-users be able to right-click on the plot and select 'Show data point as a table' which then allows them to export the data? Will it require the dataset to be in the premium capacity or pro is enough?"
1, Publish to Web
1), The end-user can still use the 'Show as a table' feature.
2), The end-user can't use the 'Export data' feature.
2 Website or portal
1), The end-user can still use the 'Show as a table' feature.
2), If the ‘Export data’ feature is not prohibited by the Power BI Service administrator and the user has a Pro license (or the report is in the premium capacity), then the user can use this feature, otherwise it cannot.
Export data from a Power BI visual - Power BI | Microsoft Docs
" If they are able to export it, can we control the accessibility by read-only and write only based on ADD?"
No, this will not work. If you do not want end-user to export data, please refer to the above content.
"Do the end-users need Power BI Pro licenses to access the report?"
1, Publish to Web
No, anyone can view the report.
2 Website or portal
Yes.
Embed a report in a secure portal or website - Power BI | Microsoft Docs
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @gokarajumv ,
"Will the end-users be able to right-click on the plot and select 'Show data point as a table' which then allows them to export the data? Will it require the dataset to be in the premium capacity or pro is enough?"
1, Publish to Web
1), The end-user can still use the 'Show as a table' feature.
2), The end-user can't use the 'Export data' feature.
2 Website or portal
1), The end-user can still use the 'Show as a table' feature.
2), If the ‘Export data’ feature is not prohibited by the Power BI Service administrator and the user has a Pro license (or the report is in the premium capacity), then the user can use this feature, otherwise it cannot.
Export data from a Power BI visual - Power BI | Microsoft Docs
" If they are able to export it, can we control the accessibility by read-only and write only based on ADD?"
No, this will not work. If you do not want end-user to export data, please refer to the above content.
"Do the end-users need Power BI Pro licenses to access the report?"
1, Publish to Web
No, anyone can view the report.
2 Website or portal
Yes.
Embed a report in a secure portal or website - Power BI | Microsoft Docs
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 42 | |
| 35 | |
| 35 | |
| 22 | |
| 15 |
| User | Count |
|---|---|
| 65 | |
| 58 | |
| 29 | |
| 27 | |
| 25 |