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 ,
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:
- mwegenerThats a trick.
Power Query collects the data and with a web connector (query) you push the data out to a flow endpoint (Web trigger) as part of your request data.
mwegener is there any other way to do this ..i have corporate restriction to use the http and here is the error
- mwegener
Hi DeepakSavanur , what kind of scenario are you trying to achieve?
I have two excel which will be automatically changed everyday with same columns. I am comparing these two excels and create these logs appended onto a table on power bi.. I was able to compare and create the log but unable to append the everyday logs to a single table. but everytime it refreshes its deleting the old file. i want to check if there is a way using flow or DAX to append the logs
