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.
mwegener Anonymous
Any tips on configuring to ensure the flow is triggered everytime the dataset is refreshed?
I've also set up a scheduled refresh (multiple times daily) on the dataset via the Power BI service but its not triggering the flow unless I test it. 🤔
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