The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Solved! Go to 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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |