Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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
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
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 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.
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,
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,
could you help me with steps for this
4. Push the Json Document to your Flow Web URL.
5. Convert the Webcall Response
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 @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!):
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 @Anonymous ,
has data arrived in flow?
Gives error in 3rd step
Entered correct value
Could you post a screenshot from your 2nd step?