Visuals not loading in Power BI Service

[Ilaaa_13]

Hi All, 

I encounter an issue with a Power BI Report, whose visuals aren't loading in Power BI Service. 
The same report visuals loads fine with another user in the same Browser.
After long waiting time, it throws the error message 'Query has reached the available resources' and fails to load the visuals !
This happens only to my ID and it works fine for other users. 

Will be great if anyone could help on this issue, thanks in advance.

-- Ilaaa

[pallavi_r · Accepted solution]

Hi @Ilaaa_13 ,

This means your visual has attempted to query too much data at a time. Try limiting the data with filters and slicers.

Recommendation:

1. See if limiting and filtering data based on conditions solves the business purpose

2. Optimize the DAX measure using performance analyzer and DAX studio

3. If there is any decimal number, change it to integer. It will take less space

4. If there is any milliseconds in the date timestamp, just change the data type to datetime. it will save space

5. And if its happening only for you with same query as others executing, then check the capacity metrics for concurrent activities happening.

Also check this great article from Chris Webb. It will be helpful

https://blog.crossjoin.co.uk/2023/06/18/the-visual-has-exceeded-the-available-resources-error-in-pow...

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi 

[anmolmalviya05 · Accepted solution]

Hi , I hope you are doing good !

The error "Query has reached the available resources" in Power BI Service typically occurs when report queries exceed the resource limits of a Power BI Pro license. Since the report works fine for other users, the issue is likely specific to your user ID.

Causes and Solutions:

Accessing Large Data: Your user ID may retrieve more data due to Row-Level Security or custom filters. Optimize the dataset or reduce query complexity.

Browser Issues: Clear the browser cache or try using an incognito mode or a different browser.

Resource Limits: Power BI Pro has limited resources. Simplify DAX queries, use aggregations, or split large reports.

Background Queries: Scheduled refreshes or background data processing might impact performance. Consider limiting real-time refreshes.

User-Specific Settings: Reset personal bookmarks or filters and check if custom settings are causing the issue.

Permissions or Configuration: Verify workspace permissions and dataset settings, ensuring proper query folding or gateway setup.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

Subscribe my youtube channel for Microsoft Fabric and Power BI updates: https://www.youtube.com/@AnmolPowerBICorner

@Ilaaa_13

[rohit1991 · Accepted solution]

Hi @Ilaaa_13 , 

This issue typically occurs due to excessive query resource consumption linked to your specific user account. Here's how to resolve it:

1. Clear Cache and Cookies: Clear your browser's cache and cookies and then try accessing the report again.
   
   
2. Check Permissions: Verify that your user ID has the same permissions and roles as others accessing the report.
   
   
3. Optimize Report: Ensure the report is optimized for performance: Use aggregations to reduce query load Avoid excessive visuals or complex DAX queries.
   
   
4. Use a Different Browser or Device: Test on another browser or device to rule out browser-specific issues.
   
   
5. Increase Resource Capacity: If you have admin privileges, consider increasing the capacity of the Power BI workspace.

[v-saisrao-msft]

Hi @Ilaaa_13 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-saisrao-msft]

Hi @Ilaaa_13 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @Ilaaa_13 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-saisrao-msft · Accepted solution]

Hi @Ilaaa_13 

Thank you for reaching out to the Microsoft Forum Community.

The solution provided by @anmolmalviya05 @pallavi_r @rohit1991  was indeed help to rectify your query. Additionally, I am including some more points to make it easier for you.

• Please transfer the report to a Premium Capacity workspace to take advantage of higher resource limits and enhanced support for complex queries or large datasets
• Review your query and its transformations to see if you can simplify them. Remove unnecessary columns, filters, or transformations that might be consuming excessive memory. Ensure you're only loading the data you actually need for your report.
• If your dataset is too large, you might want to limit the amount of data loaded into Power BI. Consider filtering your data to include only a subset, such as a specific date range or relevant categories.

If you need any further assistance, feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

[rohit1991 · Accepted solution]

Hi @Ilaaa_13 , 

This issue typically occurs due to excessive query resource consumption linked to your specific user account. Here's how to resolve it:

1. Clear Cache and Cookies: Clear your browser's cache and cookies and then try accessing the report again.
   
   
2. Check Permissions: Verify that your user ID has the same permissions and roles as others accessing the report.
   
   
3. Optimize Report: Ensure the report is optimized for performance: Use aggregations to reduce query load Avoid excessive visuals or complex DAX queries.
   
   
4. Use a Different Browser or Device: Test on another browser or device to rule out browser-specific issues.
   
   
5. Increase Resource Capacity: If you have admin privileges, consider increasing the capacity of the Power BI workspace.

[anmolmalviya05 · Accepted solution]

Hi , I hope you are doing good !

The error "Query has reached the available resources" in Power BI Service typically occurs when report queries exceed the resource limits of a Power BI Pro license. Since the report works fine for other users, the issue is likely specific to your user ID.

Causes and Solutions:

Accessing Large Data: Your user ID may retrieve more data due to Row-Level Security or custom filters. Optimize the dataset or reduce query complexity.

Browser Issues: Clear the browser cache or try using an incognito mode or a different browser.

Resource Limits: Power BI Pro has limited resources. Simplify DAX queries, use aggregations, or split large reports.

Background Queries: Scheduled refreshes or background data processing might impact performance. Consider limiting real-time refreshes.

User-Specific Settings: Reset personal bookmarks or filters and check if custom settings are causing the issue.

Permissions or Configuration: Verify workspace permissions and dataset settings, ensuring proper query folding or gateway setup.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

Subscribe my youtube channel for Microsoft Fabric and Power BI updates: https://www.youtube.com/@AnmolPowerBICorner

@Ilaaa_13

[pallavi_r · Accepted solution]

Hi @Ilaaa_13 ,

This means your visual has attempted to query too much data at a time. Try limiting the data with filters and slicers.

Recommendation:

1. See if limiting and filtering data based on conditions solves the business purpose

2. Optimize the DAX measure using performance analyzer and DAX studio

3. If there is any decimal number, change it to integer. It will take less space

4. If there is any milliseconds in the date timestamp, just change the data type to datetime. it will save space

5. And if its happening only for you with same query as others executing, then check the capacity metrics for concurrent activities happening.

Also check this great article from Chris Webb. It will be helpful

https://blog.crossjoin.co.uk/2023/06/18/the-visual-has-exceeded-the-available-resources-error-in-pow...

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi 

[FarhanJeelani]

Hi @Ilaaa_13 ,

What is your license type?

[Ilaaa_13]

It is Power BI Pro Account