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.
Solved! Go to Solution.
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 menu
Oh, yes I completely forgot about those settings. The option is currently set at 'allow end user to export both summarized and underlying data'.
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.
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.
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!