Error fetching data for this visual

Hi knissm ,

Thank you for the clarification. From your description, this does not appear to be an issue with the report or model, nor does it seem related to credentials or configuration, as those would cause consistent failures for all users. With DirectQuery to Azure SQL, each visual refresh relies on a live connection from the Power BI Service to the database. If the report works for some users but temporarily fails for others and then works again without changes, it typically points to a temporary condition on the service or data source side, rather than a problem with the report itself.

Such intermittent issues often occur due to brief resource pressure or connectivity fluctuations on the Azure SQL side or within the Power BI Service capacity. Under heavy load, DirectQuery requests may fail if the database is throttling connections, experiencing high CPU or memory usage, or if Power BI capacity is saturated. Once the load decreases, the report works again, which matches your observations.

I suggest checking Azure SQL performance metrics around the times when failures occur, focusing on CPU, DTU or vCore usage, and connection limits, to identify any spikes or throttling. Also, consider how many users are accessing the report at the same time and whether the visuals are generating heavy DirectQuery workloads. If the workspace is on shared capacity, moving to dedicated capacity or increasing Azure SQL resources may help improve stability.

Thank you.