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
- Anonymous1 year ago
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
- AnonymousNot applicable
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".
- KonradZawel
Helper I
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
Super User
Thanks, but is the way to make this automatically through rest api or other tools?
- jaryszek
Super User
Problem is not solved!!!