Unanswered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building flows

I have the same question (0)

All responses (52)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Giant ,

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.

Was this reply helpful? Yes No
tomatminceddata 21 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Giant ,

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

HI Expert,
I am able to do this below mentioned 1st step
unable to understand power BI Step. I just have table

Shree

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Giant ,

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Expert,
I hope it will work to send millions of records in email and i have integrated with Jira and polulated the data in power BI . Do i have to add power apps from marketplace and do this task
Create a Reference of your Source Table (Query).
can you more elaborate on above step
Shree

Was this reply helpful? Yes No