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.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

mwest Wouldnt a data alert trigger a separate flow to the original web service conifgured?

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

Hi Anonymous ,

 

can you give an overview of your entire concept / process?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    mwegener  concept is to automate csv data exports to a dedicated sharepoint folder everytime the dataset is refreshed in power bi service.  

    an addition ive made is build in a datetime stamp against the filename so each refresh will generate a new file but the problem im encountering is a new file isnt being generated even though the underlying dataset is triggered to refresh 3 times/day.

    it only appears to work when i test the flow and manually refresh in power bi desktop 

     

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

      Hi Anonymous ,

       

      is the service refresh executed without errors?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        mwegener No errors