Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to 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.
Happy to help!
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.
Happy to help!
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
16 | |
12 | |
10 | |
8 |
User | Count |
---|---|
34 | |
26 | |
19 | |
17 | |
16 |