Export data not visible

[CarlsBerg999]

Hi,

I have published a report that has a table-visual for which the Export Data is not visible (or the three dots in general). I don't understand why the data in this visual can't be exported by the user, even though the settings say it should be possible. 

On the Desktop version, i have report settings as "Allow end users to export data with current layout and summarized data from the Power BI service or Power BI Report Server". 

In addition, In Power Bi Service i have checked the published report settings, and i have "Summarized data, data with current layout and underlying data".

- I am the admin. 
- No roles/RLS level security is included in the report. 

- Filters can be exported for some reason, although the data table can't be.

[RajaCSN]

You might have already performed these steps. If not check them:

1. After opening the required PowerBI report, click on the EDIT option and then try to see if your tables can be exported.

2. If not still, then you need to check your Admin portal.

The images below can help, I hope.  For example, I am the admin and have enabled data to be exported as Excel document not in CSV format.

If this gives you an idea, please update. If the issue is beyond these two points, let me see other possibilities.

Thanks.

C.S.N. Raja

[PhilW · Accepted solution]

Hi @CarlsBerg999,

The three dots are in general only visible in the Power BI Service if the visual header is activated.

You can find the setting in the format tab of the visual.

In addition to the settings you mentioned, the visual header must be turned on that the three dots are available.

Best regards,

PhilW

[CarlsBerg999]

This did the trick! I did not know this.