Ellipsis (with Export Data) missing from matrix visual

[Anonymous]

Hello PBI community,

I have created and published an app through the Power BI service that contains some KPI card indicators and a large matrix containing some summarized data. I would like for my users to have the option of downloading the data in the matrix, for further analysis and searchability purposes. However, once my report is published, the elipsis that normally appears when you hover over the matrix in Desktop disappears in the Service, so my users cannot export the data.

I have experimented with using the same dataset on a different PBI file, and I was able to export this other report's matrix in the Service. Is there a local setting somewhere in my first report that is removing the elipsis from my matrix?

1. I am able to export the complete underlying data from my KPI cards

2. I have ensured that the "Allow users to export both summarized and underlying data" is checked in my PBI files

3. I have checked with my system admin, and the "Export Data" is enabled for my entire organization.In the Service, no ellipsis appears when I hover over a matrixIn the desktop, the exact same matrix will give me its ellipsis & "export data" option

[GilbertQ]

Hi @Anonymous 

Did you check on the Power BI Service under the report settings what the option is there:

[Anonymous]

@GilbertQ 

I wasn't able to find that setting, actually; I was looking around in my workspace but I couldn't even pull up the report inside the settings menuI have a report in this workspace, but nothing is showing in the "Reports" tab of the settings

[GilbertQ]

Hi @Anonymous 

Apologies you will find the settings here

[Anonymous]

@GilbertQ 

Oh, yes I completely forgot about those settings. The option is currently set at 'allow end user to export both summarized and underlying data'.

My current report settings

[deepu299]

This coud be silly but since the whole ellipse is missing, Have you turned more options ON? 

Also if only Export option is missing and you are able to see all the options, check BUILD permissions on the data set. 

[Anonymous]

@deepu299 

That may be the issue, as the ellipsis simply isn't to be found for that specific visual.

Where are those options you have in your screenshot? The only options I know of are the ones as in the screenshot below.

I only know about these visual options

[deepu299 · Accepted solution]

@Anonymous Sorry that you didn't find those. You are at the right place. It's called "Visual Header" if you go further down. This is the last one in that list. 

[Anonymous]

@deepu299 

Yep, turns out I had the visual header turned off completely and that fixed the issue. Thank you!