Forum Discussion

POSPOS's avatar
POSPOS
Post Partisan
1 year ago

Exporting Power BI Table visual as CSV to SharePoint Folder using Power Automate only gets 500 rows

Hi All, I have a requirement to export one of the table in Power BI report as a CSV and upload into SharePoint folder. I have created the below flow, but the csv file only brings in 500 rows whereas...
Need Help
vicky_'s avatar
vicky_
Super User
1 year ago

If you've just copied the code straight from the performance panel, remove the section at the end that starts with TOPN(501...) and update the evaluate part accordingly.

POSPOS's avatar
POSPOS
Post Partisan
1 year ago

vicky_  - thank you for your response. Yes, I was using the code directly from Performance analyser. I removed the TOP N  and now it brings 28k rows which is still not matching Power BI output which has 50k rows. Can you advise ?