Forum Discussion
Need to export data from each visual to readable format like json or csv
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
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".
8 Replies
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".
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.
Nope problem is not solved.
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.
Thanks, but is the way to make this automatically through rest api or other tools?
Problem is not solved!!!
