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

[Anonymous]

Hello Expert,

 i think below mentioend are the steps which i needs to excute it

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

5. Convert the Webcall Response

Shree

[Anonymous]

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

[mwegener]

Hi @Anonymous ,

I'm skeptical if this proof of concept can transfer millions of records.

You don't need to add power apps to do this task.

Reference

Reference is another way of copying a query, However, the big difference is that; When you reference a query, the new query will have only one step: sourcing from the original query. A referenced query, will not have the applied steps of the original query.

 

[Anonymous]

Hello Expert,

can you please explain me this step. i have simple table in power BI

2. Convert this to an Array of Records.

3. Convert the Array to a Json Document

Shree

[Anonymous]

Hi Expert,

Suggestion Please

Regards,

[mwegener]

Hi @Anonymous,

has your question been answered?

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

Please give Kudos for support.

[Anonymous]

Hi Expert,

In order to work in this steps ..it needs to export power bi report into JSN file. I have below mentioned steps but do not how to export power bi schema in jsn file and which needs to paste in get method of http request

https://community.powerbi.com/t5/Desktop/How-do-i-create-a-Json-file/m-p/422206#M194131

can you help me with steps for this. It is used in http get method which is first step

Shree

[Anonymous]

Hi Expert,

Suggestion Please

Regards

Shree

[Anonymous]

suggestion please

[Anonymous]

.

[Anonymous]

Hello Expert,

could you help me with steps for this

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

5. Convert the Webcall Response

Shree

[Anonymous]

Hello  @mwegener 

Can you help me with third step please

Shree

[mwegener]

Hi @Anonymous ,

Could you post a few screenshots of your current steps?

[Anonymous]

Hi @mwegener 

I am trying the generate the url using below mentioned code

Error :Enter valid JSON

let
Source = #"Tracker – SAP",
ToArray = Table.ToRecords(Source),
ToJsonBinary = Json.FromValue(ToArray),

[Content = ToJsonBinary]),
LinesFromBinary = Lines.FromBinary(WebCall)
in
LinesFromBinary

[Anonymous]

Hi @mwegener ,

thanks for the response,

Parse the result and load this query to the datamodel (this is very important, because otherwise the WebCall wouldn’t be made if the dataset is refreshed!):

• row 8: Lines.FromBinary(<WebCallFromAbove>)

I think it is power bi desktop datamodel edit query option ..is it correct?

Shree

[mwegener]

Hi @Anonymous ,

did you receive a URL?
Yes, the next steps are at Power BI Desktop.
Can you do that steps and post a screenshot?

[Anonymous]

Hi @mwegener ,

here is the screenshots but i am getting after the step,

Error Message

Formula.Firewall: Query '10 millions (2)' (step 'LinesFromBinary') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

Error

[Anonymous]

Hi @mwegener 

I corrected this step,No reference table required, can do it with original table

Shree

[mwegener]

Hi @Anonymous ,

has data arrived in flow?

[Anonymous]

Gives error in 3rd step

Entered correct value

[mwegener]

Could you post a screenshot from your 2nd step?