Share
Report
2In Power Automate / Run a query against a dataset (Power Bi)
I have a dataset with roughly 30,000 rows. It also has a set 279 columns. When I run the normal export to CSV, it only returns 2500 to 5000 rows. I found a solution from curbal (https://youtu.be/fbeMw9jtJB4?si=YrEi-a6TnF4TZj6G) on how to iterate incrementally through chunks of rows. I thought this worked initially, but then noticed the columns were not lining up.
As you can see, when it appends new data to the CSV, the columns get messed up. I also noticed that many rows are missing. These show up in the Excel reference rows compared to the index column. Example, 331 rows missing after the first append. These issues are shown in yellow for my added double check column. Any thoughts or methods to correct this?
I have a dataset with roughly 30,000 rows. It also has a set 279 columns. When I run the normal export to CSV, it only returns 2500 to 5000 rows. I found a solution from curbal (https://youtu.be/fbeMw9jtJB4?si=YrEi-a6TnF4TZj6G) on how to iterate incrementally through chunks of rows. I thought this worked initially, but then noticed the columns were not lining up.
As you can see, when it appends new data to the CSV, the columns get messed up. I also noticed that many rows are missing. These show up in the Excel reference rows compared to the index column. Example, 331 rows missing after the first append. These issues are shown in yellow for my added double check column. Any thoughts or methods to correct this?
Categories:
All responses (
Answers (
