Need to export data from each visual to readable format like json or csv

[jaryszek]

Hi Guys,

I want to create regression tests for comparing my input data aggregations done on raw csvs sqls (in java) with visuals created with DAX measures. 

I want to have fully automated way, not like in DAX studio where you need to hardcode values. 

so if i could have data like using Export to data from visual directly - below example rows from csv exported directly from power bi desktop:

MeterCategory MeterSubCategory Sum of CostInBillingCurrency
Virtual Machines Mdsv3 High Memory Series Linux $20739,84
Azure NetApp Files $17116,24
Virtual Machines Mdsv3 Medium Memory Series Linux $10140,57
Virtual Machines Edsv5 Series $7783,53

How can i generate it automatically in order to be read by java to perform regression/comparison tests?

Best,
Jacek

[jaryszek]

Problem is not solved!!!

[KonradZawel]

You can export data from Power BI visuals as CSV or Excel files. This lets you save either summarized or underlying data in a readable format for analysis or sharing.

[jaryszek]

Thanks, but is the way to make this automatically through rest api or other tools? 

[v-priyankata · Accepted solution]

Hi @jaryszek,

Thank you for reaching out to Microsoft Fabric Community.

This may achieve through power Automate, i would suggest raising a ticket is power automate forum for faster resolutions. 

Forum Linke : Microsoft Power Platform Community Forum Thread

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos".

[v-priyankata]

Hi @jaryszek 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[jaryszek]

Nope problem is not solved.

[v-priyankata]

Hi @jaryszek

Thank you for confirming that you have raised the issue with the respected forum. Please wait until the issue is resolved; they will address your query. If you have any other questions related to Power BI and Fabric, please reach out to this forum.

Thanks.

[jaryszek]

Ok crossposted here:
https://community.powerplatform.com/forums/thread/details/?threadid=2e97d9b5-1336-f011-8c4e-7c1e5247...