Forum Discussion

muralidharan_79's avatar
muralidharan_79
Frequent Visitor
1 year ago
Solved

Data Extract from Various tables (measures and cols from multiple tables) from datast using Automate

Hello Community,   I have a requirement to export data from one of the power bi dataset to csv on daily basis. I have tried various options but all ended with some syntax error or others. We have ...
Need Help
Show and Tell
  • muralidharan_79's avatar
    muralidharan_79
    1 year ago

    Hello v-ssriganesh and hackcrr ,

     

    Thank you so much for the response and followups. Instead of copying the dax query through performance analyzer i copied from Dax query tab and it worked without any error.

     

    First we need to include all the required data in a table and then if we go the dax query tab we will find a simple and optimized query which we can paste in the flow to extract the report.

     

    Thanks!

hackcrr's avatar
hackcrr
Icon for Memorable Member rankMemorable Member
1 year ago

Hi, muralidharan_79 

 

Create a flow that uses the Power BI Export API or manually queries the dataset using the Execute Queries REST API.

Store the results in a CSV format in a SharePoint folder or email it daily.

If the dataset is part of a Paginated Report, you can schedule the export directly:

  1. Create a paginated report in Report Builder or Power BI Service.
  2. Publish the report to Power BI Service.
  3. Use the subscription feature to schedule a daily export of the report in CSV format.