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

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.