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

[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