Table loading error in PBI Service

[sheikh_mishuk]

Below is the screenshot of a Table visualization in POWER BI SERVICE.

The table perform well in Power BI desktop but after publishing it shows the above message.

I have deleted all complex measure/calculated table from it but still it shows like above. 

What is the solution?

[Icey · Accepted solution]

Hi @sheikh_mishuk ,

Please check if this post could help you: The “Visual Has Exceeded The Available Resources” Error In Power BI.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[mahoneypat]

I can't explain what you are seeing.  Sorry.  I would do a save as with another name to your pbix and try publishing it again.

Regards,

Pat

[mahoneypat]

That is odd.  Are you able to refresh other datasets/reports in the same workspace?  What about other workspaces?  If it is refreshing locally in your pbix in a reasonable amount of time, then it should in the service too.

Regards,

Pat

[sheikh_mishuk]

Hi @mahoneypat , thanks for getting back. Below are my answers.

> Using the same parameter, dataset, and data model; the table is working in PBIX but not being shown in service.
> In the same workspace, I have other files also. But all the files have not such problem. This is the specific one with this kind of problem. Is it anyhow relevant to the workspace? However, I am a Pro user.

[mahoneypat]

Looks like a memory error which means too many rows or more likely a calculation that is too resource intensive.  If you have multiple measures in the visual, remove each one separately until it works to find the one that is the problem and then share that measure here for optimization suggestions.  Also share more details about your data model (e.g., # rows).

Regards,

Pat

[sheikh_mishuk]

@mahoneypat  I tried the steps. To do that, I removed all the complex measures/calculated tables. 
Even though I am getting the same error. That's what confuses me. 

Should I share something more to clarify?

[mahoneypat]

Please click on See Details and share the error shown.

Regards,

Pat

[sheikh_mishuk]

Hi  @mahoneypat  thanks for reply. Below is the error note:

More details: Resource Governing: The memory used by the query exceeded the configured limit. The query or calculations referenced by it might be too memory intensive. Please consider simplifying the query or calculations. If the dataset is hosted on a dedicated capacity/server, you may also reach out to your capacity/server administrator to see if the per-query memory limit can be increased. Additional information: Requested 1048582KB, Limit 1048576KB.
Activity ID: 1ffc075e-7d69-42f4-bb6f-2e84c6fb4210
Correlation ID: 35b32b9f-d65c-fdbf-c956-8d1ab11930a0
Request ID: a3bc75f5-af6b-77a4-77d3-461dd50fedf4
Time: Mon Dec 07 2020 10:54:49 GMT+0100 (Central European Standard Time)
Service version: 13.0.14788.65
Client version: 2011.3.03863-train
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net/