cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mecho
Helper II
Helper II

Ellipsis (with Export Data) missing from matrix visual

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 Service, no ellipsis appears when I hover over a matrixIn the desktop, the exact same matrix will give me its ellipsis & "export data" optionIn the desktop, the exact same matrix will give me its ellipsis & "export data" option

1 ACCEPTED SOLUTION

@mecho 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. 2019-07-15_13-32-53.png

View solution in original post

8 REPLIES 8
GilbertQ
Super User
Super User

Hi @mecho 

 

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

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@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 settingsI have a report in this workspace, but nothing is showing in the "Reports" tab of the settings

Hi @mecho 

 

Apologies you will find the settings here

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@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 settingsMy current report settings

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. 

 

 

2019-07-12_21-06-00.png

@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 optionsI only know about these visual options

@mecho 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. 2019-07-15_13-32-53.png

View solution in original post

@deepu299 

 

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!