Forum Discussion
Power BI table data export in csv to email using Microsoft Flow
Hello Expert, How Power BI table data export in csv to email using Microsoft Flow as we know it can refersh data sets but how about tables export as email attachment Shree
Hi Anonymous ,
here are a few screenshots from my test.
My source table:
My Power Query Code to send the data to Flow.
My transformed data in Flow.
Hope this helps.
Hi mwegener ,
CSV. file is created in JSON format how it will convert it
| [{"Column1":"1"} | {"Column1":"2"} | {"Column1":"3"} | {"Column1":"4"} |
convert in columns and rows like mentioned below in csv file
column1
1
2
3
Shree
mwegener
Most Valuable Professional
Most Valuable ProfessionalCould you post a screenshot from your 2nd Flow step?
Modify the “Compose”-step to parse out the table from the JSON like this: