Hi, I wanted to enable Export data option for 1 page but not for pages. Is there a way for it?

[skanikdale]

I have a report where there are 3 pages, 1st page have table, 2nd and 3rd page have pivot table. I wanted to just enable Export data option for the 1st page. Pivot table data should not get exported. 

I searched for it but didn't get a good solution.

Is there a way or trick to do this?

[kushanNa · Accepted solution]

Hi @skanikdale 

If you want to stop exporting the 2nd and 3rd pages, you can use the "Export current page only" option while exporting. This will ensure that only page 1 gets exported.

However, if you want to restrict access to page 1 for specific users, one immediate solution that comes to mind is to create a dashboard and pin only the visuals from the 2nd and 3rd pages to it. Then, share that dashboard with those specific users so they will not see the first page or its export. https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboards 

Or use RLS 

[v-venuppu]

Hi @skanikdale ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @skanikdale ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[skanikdale]

Hi, I use 3 dots to export data.

[kushanNa]

Hi @skanikdale 

Try to do this https://community.fabric.microsoft.com/t5/Desktop/Hi-I-wanted-to-enable-Export-data-option-for-1-pag... 

[v-venuppu]

Hi @skanikdale ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Regards,

Rama U.

[skanikdale]

I am exporting by clicking on 3 dots on table visual  -> Export Data -> summarized data -> file format : .xlsx(150000 - row max)

[kushanNa · Accepted solution]

in the table visual go to general - >header icons -> icons and you will see more options , switch off it and it will remove the three dots .. option . so the users can't export that table

[kushanNa · Accepted solution]

Hi @skanikdale 

If you want to stop exporting the 2nd and 3rd pages, you can use the "Export current page only" option while exporting. This will ensure that only page 1 gets exported.

However, if you want to restrict access to page 1 for specific users, one immediate solution that comes to mind is to create a dashboard and pin only the visuals from the 2nd and 3rd pages to it. Then, share that dashboard with those specific users so they will not see the first page or its export. https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboards 

Or use RLS 

[skanikdale]

Thank you kushanNa for your reply, I am new to Power BI, can you please suggest where can I find the option of Export current page only while exporting?

[kushanNa]

hi @skanikdale 

When you click export to PDF , you should see this option 

[skanikdale]

Oh, sorry, I think I forgot to mention that I wanted to Export the table from 1st page in Excel format. Is there a similar option for Excel as well?

[kushanNa]

How do you export to excel ? using three dost ... -> export data or using Analyze in excel option ?