Forum Discussion
Power BI table data export in csv to email using Microsoft Flow
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.
Most Valuable ProfessionalHi Anonymous ,
check Power BI "Data Alerts"
https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-flow-integration
mwest Wouldnt a data alert trigger a separate flow to the original web service conifgured?
- mwegener
Hi 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
- mwegener
Hi Anonymous ,
is the service refresh executed without errors?