Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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  
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    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.

     

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi shanmanz,.

 

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

 

 

shanmanz's avatar
shanmanz
New Member
6 years ago

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.