Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power Automate - Export Button

Hi there,    I have created a power automate export button to send a csv export file via email. It is working perfectly. However, the csv file doesn't contain all the rows. there should be 1460 row...
Need Help
  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi Anonymous ,

    As far as my know, there is 1000 row limitaion in Power Automate visual in Power BI Desktop.

    When I filter 1000 row value in Power Automate visual, it works fine.

    After updating to filter 1001 rows, the visual reminds that too many values which would not show all data.

     

    So if you want to export to csv file by Power Automate button, you need to consider this limitation.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Community Support
4 years ago

Hi Anonymous ,

As far as my know, there is 1000 row limitaion in Power Automate visual in Power BI Desktop.

When I filter 1000 row value in Power Automate visual, it works fine.

After updating to filter 1001 rows, the visual reminds that too many values which would not show all data.

 

So if you want to export to csv file by Power Automate button, you need to consider this limitation.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.