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

[muralidharan_79]

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 measures and calculated columns from multiple tables and based on today's date we need to extract the data. So basically there will one aggregated row for every date. 

Is there any possible to attain this?

Thanks in advance for the help. 

[v-ssriganesh]

Hi @muralidharan_79,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @muralidharan_79,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-ssriganesh]

Hi @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.

[v-ssriganesh]

Hi @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.

[muralidharan_79 · Accepted solution]

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]

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.