Forum Discussion
naoyixue1
Post Patron
Post PatronHow to pull visualized table data to send to user as CSV? Although the visual is too big to show
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 t...
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-power-bi-desktop/
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
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.