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

Hi Expert,

I do not understand these steps

 

As Chris Webb described in this article, Power Query can create POST requests to a webservice, thereby passing values in the body of the call to the webservice. This allows to export the data from Power BI. With Flow, it is very easy to setup a webservice: Just create 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:

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago
Thats a trick.
Power Query collects the data and with a web connector (query) you push the data out to a flow endpoint (Web trigger) as part of your request data.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Very true, but i do not understand the steps from the ink mentioned below

    any url to follow and configure these steps and is it free with Power BI Pro account

    and this steps ..i never seen

     

     

     

     

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

      Hi Anonymous ,

       

      this step is configured in flow. 

      Create an instant flow and use this http trigger.

      https://flow.microsoft.com 

       

      The further steps are shown as M code.

      You have to adapt it to your needs.

       

      If I answered your question, please mark my post as solution, this will also help others.

      Please give Kudos for support.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

         

        HI Expert,

        I am able to do this below mentioned 1st step

        unable to understand power BI Step. I just have table 

         

        Shree