Hi mwegener 

thank you so much!!!!!!!!😎 ...it working like anything

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.

Hi mwegener 

I am also creating reference table but getting error

Reference table query

Query in reference table

Go to file option and select ignore privacy session and run it . i just tested it working fine

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

Suggestion please

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

Hi Expert,

Suggestion Please

Regards,

Hi Anonymous ,

open an Advanced Editor insert this M Code and Replace TableName with you Source Table.

let
    Source = #"TableName",
    ToArray = Table.ToRecords(Source),
    ToJsonBinary = Json.FromValue(ToArray)
in
    ToJsonBinary

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

Please give Kudos for support.

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.

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

Hi Expert,

Suggestion Please

Regards

Shree

suggestion please

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

.

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

Hello  mwegener 

Can you help me with third step please

Shree

Hi Anonymous ,

Could you post a few screenshots of your current steps?

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

Hi Anonymous ,

start with this and post a screenshot

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:

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

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?

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

Hi mwegener 

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

Shree

Hi Anonymous ,

has data arrived in flow?