Exporting to CSV from Power BI to Sharepoint

(0) Share

Report

Posted on by bonjourposte

Hi all, I've installed a Power Automate button on my Power BI Dashboard to download all the data that was generated by an API in Power Query.

However, there is a shortfall in the number of rows.

When I upload the file into Power Query, there are 924 rows. I make sure there are still 924 rows in the modelling tab, and yes there are. I make a visualization in the dashboard to make sure there are still 924 rows of data, and yes, there still are.

But as soon as I click my Power Automate button to send the data to Sharepoint, somehow it only gives me 764 rows in the sharepoint file.

I compared the two lists, and the ones that are missing are the final 160 rows of my Excel document. I have nowhere indicated that I would like to limit the number of rows.

This is what my flow looks like.