Welcome to our Knowledge Base
Tip: Start typing in the input box for immediate search results.
Export more than 100k rows of Power BI data to CSV using Power Automate – Remove headers
On a previous video I showed you how to batch the Power BI exports so you don’t hit the Power Automate limit of 100k rows but while looping through the data, the headers for each loop where saved too.
In this video I will show you how to get rid of the headers.
Watch the tutorial on YouTube

The code
As Ratnakar jv explained in the comments, on the “Do until Loop” step , find the step “Append to string variable” and replace the code to this:
if(equals(variables('LoopsVar'), 2), body('Create_CSV_Table'), join(skip(split(body('Create_CSV_Table'), decodeUriComponent('%0A')),1), decodeUriComponent('%0A')))
More tips and tricks on exporting data



How to create a Export to Excel / CSV button in Power BI

Export from Power BI to Excel up to 🔥100k rows 🔥| Run a query against a dataset

Export MORE THAN 100k rows of Power BI data to CSV using Power Automate | No ROW limits!

Change column names when exporting data from Power BI | Run a query against a dataset

Automatic exports of Power BI data 🤖 | Run a query against a dataset

Automatic exports of Power BI data to a local folder

Smart Alerts are finally here!!! 🎉

Filter Power BI exports with Power Automate filters | Run a query against a dataset

Filter the data in Power BI before you export it to excel using Power Automate

Export Power BI data to any format: excel, power point, pdf, xml, …..

Export data from Power BI – No limits -No headers

Export Power BI data to different files based on CategoryID with Power Automate

Export Power BI data to different folders based on filters with Power Automate

export to different files based on category name

Was this helpful?
Reader Interactions