Forum Discussion
The XML for Analysis request timed out before it was completed. Timeout value: 225 sec.
Microsoft EmployeeHi wenthe,
It returns the error, because your visual has attempted to query too much data to complete the result with the available resources. You'd better try filtering the visual to reduce the amount of data in the result. You can see the error in this troubleshooting article: Troubleshooting tile errors.
And I post a similar thread below for your reference. Hope it's useful.
http://community.powerbi.com/t5/Service/visual-has-exceeded-available-resources/td-p/115962
Best Regards,
Angelia
Hi Angelia,
Thank you for your reply.
As I mentioned, all the visual in the report query the same SQL data, why only one of them cannot be displayed normally in website? (It works fine in desktop.)
I have limited the date in the SQL view to reduce the output of the SQL view, no more than 50k rows come from the result of the SQL view. What's the limitation exactly? What else can I do to filter the abount of data?
Thank you,
Wenting
- v-huizhn-msft
Hi wenthe,
There is no restriction on how large a pbix file can be locally. However, when you publish a pbix file over 1GB to Power BI Service, please check the size of your .pbix file.
Best Regards,
AngeliaHi Angelia,
The size of my .pbix file is 251KB, far away from the limitation.
Hi Angelia,
The size of my .pbix file is 251KB, far away from the limitation.
- v-huizhn-msft