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

Hi mwegener 

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

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 mwegener 

if i publish the same pbis file to the workspace or say myworkspace and schedule data refresh from there as mentioned in your link and then if i trigger flows further export data will it take it from workspace or power bi desktop

Shree

Workspace (Power BI Service)
Power BI Desktop is only for the development and you have no connection from the internet (flow) to your Power BI Desktop.

Hi mwegener ,

CSV. file is created in JSON format how it will convert it 

convert in columns and rows like mentioned below in csv file

column1

1

2

3

Shree

Could you post a screenshot from your 2nd Flow step?

Modify the “Compose”-step to parse out the table from the JSON like this:

Hi mwegener 

Here is screenshot

Hi Anonymous ,

please check which Output you use.

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

Hi mwegener 

output is still JSON format..Do we have to convert it in power BI Desktop as output itself is coming in JSON format in web call method. can we use direct web call method with JSON format

Shree

Hi mwegener 

The issue is after adding to the web call method ...it is showing as list and afer converting not showing any data

in every column in output it is showing like this

[{"Column1":"1"} {"Column1":"2"} 

Hi mwegener 

when converting the same list into table getting blank data 

[Edit]

I'm receiving the same error.

Query

let
Source = #"BE Confirmations Driver",
ToArray = Table.ToRecords (Source),
ToJsonBinary = Json.FromValue(ToArray),
WebCall = Web.Contents("https://prod-99.westeurope.logic.azure.com:443/workflows/.../triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=...",
[Content=ToJsonBinary]),
Lines.FromBinary = Lines.FromBinary(WebCall)
in
Lines.FromBinary

Data Source setting anonymous

Any help would be much appreciated ! 

Hi , 

I tried above solution but stuck at Powerquery editor step converting to JSON.

•  I created 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 .

• Open Power BI Desktop ,  Connect to  dataset  created at https://app.powerbi.com/groups/me/list/datasets . However,  after connection  Tranform Query option is grayed out .  

• Also tried this : open Power BI Desktop, do not connect to any data source,  Select Transform Query, Advanced Editor as shown . However there is no  option  to connect to  dataset  created at https://app.powerbi.com/groups/me/list/datasets .See Screenshot PBI2

• What source do I need to enter in  the below code in Powerquery editor to connect to dataset at apps.powerbi.com  that will convert records to JSON format. 

let
Source = #”1_SourceTable”,
ToArray = Table.ToRecords(Source),
ToJsonBinary = Json.FromValue(ToArray),
WebCall = Web.Contents(
“URL from FLow ”,
[Content = ToJsonBinary]),
LinesFromBinary = Lines.FromBinary(WebCall)

in
Lines.FromBinary

Thanks

Hi shanmanz,.

Unfortunately, you cannot currently access an existing dataset in Power BI Service with Power Query.

Oh.. OK 😞 .   I am trying to convert  Microsoft Teams call quality Dashboard Data to CSV format then email or store it to onedrive for  internal audit purpose. My plan was to publish Microsoft Teams Call Quality Dashboard to Power BI service , Use Power Query editor to convert it to JSON , then Use flow to convery to CSV then Email. 

Is there any connector in  Power Query I can use to get data from  POwerBI service or Microsoft Teams Dashboard directly ? 

 Any other thought?? 

 Thanks again for  the input. 

Hi,

I have managed to recreate the steps mentioned in the following article to export data from Power BI.

https://www.thebiccountant.com/2019/04/01/export-data-from-power-bi-using-microsoft-flow/ 

I have created report using excel file on local computer.There are no errors on flow and power bi side. However, flow doesnt trigger when a dataset is refreshed.

Could someone please help me check what's going wrong with triggering the flow?

Thanks.

SV

take large scale of data