Forum Discussion
Power BI - Error Fetching data for this visual - Failed to execute DAX
Hi KarenL7
Since users can access the dataset but only slicers work while visuals fail which points to a data access or query execution issue rather than basic permissions. In OneLake or DirectLake scenarios, users also need proper read access to the underlying Lakehouse or Warehouse or SQL endpoint as visuals trigger actual data queries while slicers may rely on cached metadata. So ensure full data level access and validate identity propagation instead rebuild visuals
This usually comes down to permissions on the underlying semantic model rather than the report itself. A connected report only renders if the viewer has at least Read and Build on the source semantic model, plus Viewer access to the workspace that hosts the model. The "Failed to execute DAX" message is what users get when they can open the report but their identity is rejected when a visual tries to query the dataset.
Open the workspace that contains the semantic model, go to Manage access, and grant the affected users (or a security group) both Read and Build. If the model lives in a different workspace than the report, give them Viewer on that workspace too. Ask one of them to hard refresh and the visuals should populate without rebuilding anything.
If you also have RLS configured on the model, double check those users are mapped to a role, because an unmapped user on an RLS enabled model produces the same error.
If this helped, a thumbs up and accepting the solution would be appreciated.
Best,
Shai Karmani