Export from power bi more than 1000 records

(0) Share

Report

Posted on by mariusz_zieba

Hi,

I'm new to the community and I want to export more than 1000 records from the table using power automate.

I created a simple flow where I use 'Create CSV table' connector however when I trigger the button it returns me only 1000 records although I have much more.

I read that there could be a setting in the 'Tracked Properties' for no limits or something like that but I don't know how to find the name of such property.

Here is my flow:

Categories:

Building flows

Capture.PNG

I have the same question (0)

All responses (3)

Answers (0)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report
from the table

from what table? Is this coming from the PowerAutomate visual in Power BI or from a dataset query? What does your DAX query look like?

Was this reply helpful? Yes No
mariusz_zieba 2 on at

Like (0)

Report

I want to export the data from existing dataset table not from the visual. There is no DAX query I just took the column names from the table and filter it by my own.
Let's consider I have the table consisting of 3 columns in my dataset (CLIENT_ID, PRODUCT_CATEGORY, COST) with 3000 records I want export.

Was this reply helpful? Yes No
Reina_CP 21 on at

Like (0)

Report

Hello there

I'm sort of new also with automate, I was able to export from PowerBI to a csv then upload it to a Sharepoint list.

I do not understand the error you are getting, but I think you need to use the "Run a query against a dataset" option in Automate and should do the trick (Basically you create the table in DAX and teach Automate how to do it)

Maybe this content will help you
https://youtu.be/WsbIXJDhC_o

Was this reply helpful? Yes No