Forum Discussion
Data Extract from Various tables (measures and cols from multiple tables) from datast using Automate
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!
Community SupportHi muralidharan_79,
Thanks for posting your query in microsoft fabric community.
While Power BI doesn't have built-in functionality to automate CSV exports without using Power Automate, you can achieve automation with Power BI REST API or third-party tools. This requires development work and access to API endpoints (or) Alternatively, you can use tools like PowerBI Robots or Power BI Export to automate exports to CSV or other formats.
If this helps then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Hope this works for you!
Thanks.
Community SupportHi muralidharan_79,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
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!