Export Data option not visible

[VamsiKrishna98]

Hi,

I have dataset and i have shared one report page to user and the user didn't see the export option. I have given read and reshare permissions.

Thanks,

vamsi

[Pragati11 · Accepted solution]

Hi @VamsiKrishna98 ,

Have you enabled the following setting in Power BI Desktop before publishing your report to Power BI Service?

If yes and it still doesn't work, then share some screenshots around what issue is coming at your end.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[VamsiKrishna98 · Accepted solution]

Thanks Pragati. We have enabled the 2nd option as shown below. What is different between 1 and 2 options?

[Pragati11 · Accepted solution]

Hi @VamsiKrishna98 ,

Have you enabled the following setting in Power BI Desktop before publishing your report to Power BI Service?

If yes and it still doesn't work, then share some screenshots around what issue is coming at your end.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[VamsiKrishna98 · Accepted solution]

Thanks Pragati. We have enabled the 2nd option as shown below. What is different between 1 and 2 options?

[Pragati11 · Accepted solution]

Hi @VamsiKrishna98 ,

- 1st option allows users to export data shown on the visual: in the layout shown on visual 

- 2nd option aloows users to export the underlying data behind creating this visual along with the data shown on the visual. Underlying data could be the raw data shown in a different way on your visual.

[VamsiKrishna98]

Hi Pragya,

I have enabled 1st option and then i shared the report. Still not getting export option. I sharing the single report page not all the pages existing in dataset. If I share the all the pages at sigle time then i am getting export option.

Thanks,

Vamsi 

[Pragati11]

Hi @VamsiKrishna98 ,

My name is Pragati first thing.

2nd thing can you share some screenshot here please?

The export functionality works at a report level that is published in PBI Service.

And this functionality is enabled on all the report pages.

I am not sure how you are just sharing a single page of your report in PBI Service. Is it a new report with just single page? If yes then make sure you have similar settings enabled on this report with single page.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[VamsiKrishna98]

Thanks Pragati. I have made single page live and shared as shown in below screenshots.

[Pragati11]

Hi @VamsiKrishna98 ,

1st thing you are using a Dashboard not a report.

2nd thing, I tried to pin a page from my report to a dashboard and I do see the export data option:

I am definitely not sure why it is not coming for you.

[VamsiKrishna98]

Hi,

I have enable the underlying option in power bi desktop and published to service. But still for user underlying option not enabled.  I have Implemented RLS for my dashboard. Is it causing an issue?

Thanks,

Vamsi

[VamsiKrishna98]

Thanks for your reply. We have enabled the second option. What is the difference between 1st and 2nd.