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.
mwegener
Most Valuable Professional
Most Valuable ProfessionalHi Anonymous ,
can you give an overview of your entire concept / process?
mwegener concept is to automate csv data exports to a dedicated sharepoint folder everytime the dataset is refreshed in power bi service.
an addition ive made is build in a datetime stamp against the filename so each refresh will generate a new file but the problem im encountering is a new file isnt being generated even though the underlying dataset is triggered to refresh 3 times/day.
it only appears to work when i test the flow and manually refresh in power bi desktop