Export to xlsx or csv 12.000.000 rows split in files that will have only 10.000 rows

[Ana-Maria]

Hello,

I have a table in Power BI with a little over 12 million rows. I need to export this table into excel/csv files, and each to have  maximum 10.000 rows.

How can I condition this ...with power apps ?

Thank you,

Ana

[ibarrau · Accepted solution]

Hi. I think it might be important if you can explain why this is important or what you want to acomplish with that. Because it's not very straight forward or make sense as a data architecture perspective.

You have integrated 12 million rows at power bi and now you want to split it by 10k rows files. I think it might be tricky but possible. I would probably add a new column at the power query data model that writes a number for each 10k rows. That way you can filter by that column 10k rows.

Then using the power bi rest API you can check how many samples of 10k rows are and loop it executing a dax query to the model that filters by the new column.

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries-in-group

I hope that make sense. 

[Ana-Maria]

Hi, I needed to upload this data in an internal app (at work). The problem is that the internal app has a restriction and I am allowed to upload excels only with maximum 10.000 rows.
In the end, I added an Index column and downloaded manually each time excels of 10.000 rows.

So the issue is solved, but if another solution exists, that would be good to know.