Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have created Power BI report in MS Fabric . The tables are present in Data Warehouse . I reated this report 3 days ago. However none of the visuals are vble now.
It shows error as "
This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed"
Please find below details about the error.
More details: The XML for Analysis request timed out before it was completed. Timeout value: 225 sec.
Activity ID: c8077255-7383-4400-9726-0e0b105b5867
Correlation ID: 49e97b7d-130c-b670-b831-ffe6f127f578
Request ID: 843a1326-7a18-44f1-b824-90b24b25761e
Time: Fri Jul 21 2023 00:30:33 GMT+0530 (India Standard Time)
Service version: 13.0.21124.55
Client version: 2307.2.14810-train
Cluster URI: https://wabi-india-central-a-primary-redirect.analysis.windows.net/
Thank you!
Solved! Go to Solution.
Hi , @Dipesh123
Based on your error message given when interacting with visuals within the Power BI report page, it returns the error, because your visual has attempted to query too much data to complete the result with the available resources.(which meets the Power BI report visuals rendering timeout limit 225 seconds) You'd better try filtering the visual to reduce the amount of data in the result. For the detailed limitation description, please refer to this official documentation:
Set visual query limits in Power BI Desktop - Power BI | Microsoft Learn
There are two protential reason for why the error message returning,
1 The visuals truely has attempted to query too much data to complete the result with the available resources, you may need to first use the filter on the page for the data amount reducing and go under the limit
2 You encountered the connectivity issue between the PBI cloud service with the data source Data Warehouse, you may need to go to the dataset setting for the detailed checking and credential configuration:
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @Dipesh123
Based on your error message given when interacting with visuals within the Power BI report page, it returns the error, because your visual has attempted to query too much data to complete the result with the available resources.(which meets the Power BI report visuals rendering timeout limit 225 seconds) You'd better try filtering the visual to reduce the amount of data in the result. For the detailed limitation description, please refer to this official documentation:
Set visual query limits in Power BI Desktop - Power BI | Microsoft Learn
There are two protential reason for why the error message returning,
1 The visuals truely has attempted to query too much data to complete the result with the available resources, you may need to first use the filter on the page for the data amount reducing and go under the limit
2 You encountered the connectivity issue between the PBI cloud service with the data source Data Warehouse, you may need to go to the dataset setting for the detailed checking and credential configuration:
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly