Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I've been using PowerBI for the better part of a year now. For the last month and a half or a little more, we've had annoying failures to refresh for 6 of our 14 tile visualizations. It's also inconsistent. Some days certain tiles of the 6 refresh and others they don't. The dashboard in question contains nothing more than 14 pinned single data point cards. They are simple queries made to our Azure SQL Database. On the database, all the queries run immediately with no delay. I have all my visualizations set to connect live to our Azure database. I'm at a loss for what to do. It seems like it's an issue with resources on Microsoft's servers. Here's the error I get:
Solved! Go to Solution.
Hi @jgarciabu,
Yes, the issue occurs when a visual has attempted to query too much data for the server to complete the result with the available resources.
As suggested in the error, you may need to try filtering the visual to reduce the amount of data in the result currently.
Regards
Why is this issue marked as solved? What is the "available resources" and what is the solution?
In my instance, some users are seeing this issue in the PowerBI service and some are not. How do I deal with this kind of issue? It would be terrible to believe a visualization is working properly, go out on a sales opportunity to a client and have this fail like this.
This simply does not make any sense without considering the data size, result size, type of visuals etc.
For intsnace, In my POC environment there are 34000 Rows even after all the joins. I have a tabular view which is displaying not more than 40 Rows currently (8 Columns).
As soon as I try and add Another column, the visual fails.
One of the column is a Measure returning Data in relevant currency.
I can't understand How inefficient my query could be to make resources so scarce !
I'm having the same issue with a visual that uses 2 DAX fields to calculate cumulative profit $ between 2 dates, this year and last year. The visual is just a line graph. It was fine until 4-5 days ago.
This is annoying since the visual is exactly what the UI and DAX should be for..
I don't think this issue is solved. What are the actual limits, and are they the same for all visuals? I'm having this issue with a simple date filter which is querying a view that has only a few thousand rows. We barely have 1.5 years of data, this is pathetic.
Is this a limitation in the Power BI Web Service?
I'm also working with a fairly large DAX calculation - it works fine on my Desktop environment, but fails to load as soon as it's published.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.