Visual is not loaded in BI web (but works fine in BI Deskhop)

[Anonymous]

Hello,

Starting this week, I have an issue with some data doesn't want to be loaded in Power BI web but loads perfectly in Power BI desktop.

Power BI Desktop:

Power BI web:

I tried filtering the data to very short period / just selecting one product, still result is the same. 

In details of the error I see the following:

More details: The XML for Analysis request timed out before it was completed. Timeout value: 225 sec.
Activity ID: 03db68e1-f5f0-4425-9fe5-21142aa7c208
Correlation ID: fe8bcacc-9010-7bc2-f625-b7adda131e99
Request ID: 8c179d85-95c1-0403-6702-c641c9cbdeb4
Time: Thu Dec 09 2021 11:59:24 GMT+0600 (East Kazakhstan Time)
Service version: 13.0.17257.48
Client version: 2111.5.08869-train
Cluster URI: https://wabi-north-europe-d-primary-redirect.analysis.windows.net/

Not sure if it helps somehow, but formula looks like that (I'm just calculating the final price and multiply it on packs:

MS NET = CALCULATE(SUMX(VALUES(Cons[INDEX]),([MS VOL]*[Price NET/YTD NET])),ALL(Cons[GROSS/NET]))

Previously everything was working, is it a server issue taking into account that everything works perfect in Desktop?

Thanks

[Anonymous · Accepted solution]

Hello, thanks for trying to help.

Unfortunately, that didn't work for me and changing the formula was the only solution (but not the optimal one).

However, in parallel I sent request to Microsoft Power BI support team regarding different issue, and by changing some settings it also solved an issue with visuals, everything started to be loaded properly! 

Hope that it will help someone else 🙂

Thanks

Ruslan

[v-janeyg-msft]

Hi, @Anonymous 

 You can see the error in this troubleshooting article: Troubleshooting tile errors.

Here is a similar solved thread for your reference:Solved: Visual has exceeded the available resources - new ... - Microsoft Power BI Community

According to your description, If the underlined part is a measure, then your measure will be very complicated (from the standpoint of resource occupation). If it is a column, it is also not simple.

You can open the preformance analyzer to check.

This is related to your data model structure(Attempt to optimize), data size(Try to filter data in data source or in pq), connection mode(import,dq,lc), and resource utilization() in the service.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If you still can’t solve the problem, please upload some insensitive data samples and expected output. Let’s see if we can write the measure in another way.

Best Regards,
Community Support Team _ Janey