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