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 ...
  • 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!