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.
65 Replies
Hi Anonymous ,
maybe this can help.
https://www.thebiccountant.com/2019/04/01/export-data-from-power-bi-using-microsoft-flow/
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi Expert,
yes but i do not understand these steps..can you please explain the steps
https://www.thebiccountant.com/2019/04/01/export-data-from-power-bi-using-microsoft-flow/
Shree
Hi Expert,
I do not understand these steps
As Chris Webb described in this article, Power Query can create POST requests to a webservice, thereby passing values in the body of the call to the webservice. This allows to export the data from Power BI. With Flow, it is very easy to setup a webservice: Just create a Flow whose trigger is a “When a HTTP request is received” (no further inputs in that step) and add a “Compose”-action with the Body-element in it. Then save the Flow and copy the generated URL:
mwegener is there any other way to do this ..i have corporate restriction to use the http and here is the error
Hi DeepakSavanur , what kind of scenario are you trying to achieve?
Hey,
this is not supported, at least not now.
If you have a Premium capacity, you might consider to use a scheduled report rendering from within a paginated report.
You might also check to look for a 3rd party tool like this one:https://go.christiansteven.com/start-pbrs/how-to-automate-power-bi-reports?utm_campaign=PBRS&utm_source=youtube&utm_medium=social
Regards,
Tom
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. 🤔
Hi 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?
