How to pull visualized table data to send to user as CSV? Although the visual is too big to show

[naoyixue1]

Hey there,

I saw some tips to send table data as CSV file to user by power automate, but my challenge is my visual is too big to show the visual. It always pops up error message ' visual exceed the capacity'. Right now, I have to put category as a filter, so user can pull the data separately by different category and then sum up to see the full picture. But it takes some time to do so. I'm thinking whether Power Automate can pull that big table data and send to user as CSV file, even the table will not show any visual (see below) . Does anyone try that before? Thanks! 

[Anonymous]

Hi @naoyixue1 

If your data source supports pagination, implement pagination in your queries to fetch data in chunks rather than all at once. Most databases and APIs support some form of pagination, which can help in handling large datasets efficiently.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nandic · Accepted solution]

@naoyixue1 here is great article that might help: https://blog.crossjoin.co.uk/2023/06/18/the-visual-has-exceeded-the-available-resources-error-in-pow...
If it doesn't solve the issue, is there any option to import data and refresh it when needed instead of using direct (live) query to database?

Cheers,
Nemanja Andic