Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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.
@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
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
85 | |
65 | |
64 |