Power BI table data export in csv to email using Microsoft Flow

[Anonymous]

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

[jasontran]

@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. 🤔

[mwegener]

Hi @jasontran ,

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

[jasontran]

@mwest Wouldnt a data alert trigger a separate flow to the original web service conifgured?

[mwegener]

Hi @jasontran ,

can you give an overview of your entire concept / process?

[jasontran]

@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 @jasontran ,

is the service refresh executed without errors?

[jasontran]

@mwegener No errors

[TomMartens]

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_sou...

Regards,

Tom

[mwegener]

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.

[DeepakSavanur]

@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?

[DeepakSavanur]

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 

[mwegener]

Hi @DeepakSavanur ,

this topic is not easy, because Power BI usually does a full refresh.
Imke Feldmann has made two blog posts on this topic as well. Do you know these blog posts?

How to create a Load History or Load Log in Power Query or Power BI

https://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or...

Create a load history or stage in CDS instead of incremental load in Power BI

https://www.thebiccountant.com/2020/04/13/create-a-load-history-or-stage-in-cds-instead-of-increment...

[Anonymous]

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

[Anonymous]

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]

Thats 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.

[Anonymous]

Very true, but i do not understand the steps from the ink mentioned below

any url to follow and configure these steps and is it free with Power BI Pro account

and this steps ..i never seen

[mwegener]

Hi @Anonymous ,

this step is configured in flow. 

Create an instant flow and use this http trigger.

https://flow.microsoft.com 

The further steps are shown as M code.

You have to adapt it to your needs.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

HI Expert,

I am able to do this below mentioned 1st step

unable to understand power BI Step. I just have table 

Shree

[mwegener]

Hi @Anonymous ,

you have to create these steps at Power Query.

1. Create a Reference of your Source Table (Query).

2. Convert this to an Array of Records.

3. Convert the Array to a Json Document

4. Push the Json Document to your Flow Web URL.

5. Convert the Webcall Response

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.