Extracting Underlying Data from Card Visual

[Anonymous]

Dear All,

I created a lot of cards in one of my dashboards, the requirement is the management want to export the underlying data of each card.

for example one card of "Total Active Employee" , they want to view the department / section / etc.. and export the underlying data to excel or csv.

the original card visual underlying data option is only extracting one row only, which is the card value without any category.

I also tried multiple 3rd part visuals .. some of them are exporting the full dataset (whether employee is active or not) and I don't even have the option to select the columns that will be exported.

Is there any solution for that? Can I define specific columns from the dataset to be exported along with the measure in the card?

Regards.

John.

[NandanHegde]

Hey,

The below blog would help in an automated way to extract the underlying data :

https://datasharkx.wordpress.com/2023/03/02/overcoming-data-size-row-limitations-of-power-bi-rest-ap...

[AnkitKukreja]

Hi @Anonymous 

Can you share a sample file to check what is the issue? If you have worked on the suggestion suggested here, also check this doc to know if you are missing anything here.
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-service#export-underlying-data

[Fowmy]

@Anonymous 

Following the best practices, you should encourage the data to stay in Power BI and provide requred analytics. One suggestion is to use drill-through from your card visual to reuired breakdown: Card drill through in Power BI – XXL BI

However, if you need to provide access to your users download the underlying data (details), you can enable it on the Report settings in Power BI Serivice.

When they click on the three dots, to export data,  Underlyding Data option could be selected.

[Anonymous]

Dear @Fowmy , Thanks for your reply.

However, this is not solving the issue, I already provided the users access to download the underlying data. when they export the card underlying data. it only shows the card value .. 

for example I attached here a very dummy and basic pbix. it has employees ,,, active employees in may 2022 is 50 ... I want the user to be able to export the data of this 50 employees with their attributes (their sections, grades, ... etc)

[Fowmy]

@Anonymous 

In that case, as I mentioned above, you should provide drill through option from your card, then once they go to this break down they can click on the three dots and export the data:
Watch this video, it should hhelp you: https://youtu.be/vFPUslxcFj4