Forum Discussion

KarenL7's avatar
KarenL7
Advocate V
4 months ago
Solved

Power BI - Error Fetching data for this visual - Failed to execute DAX

Hi I have been creating a report which uses a one lake catalog model - which is working fine in Power BI Desktop.  I can publish this to the workspace and see the report without any issues.   Howe...
Need Help
  • krishnakanth240's avatar
    krishnakanth240
    4 months ago

    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

krishnakanth240's avatar
krishnakanth240
Super User
4 months ago

Hi KarenL7 

Cause might be users don’t have permission on the semantic model or Lakehouse or Warehouse. Missing OneLake item access  that is SQL endpoint or delta tables. RLS or OLS blocking data. Dataset using DirectLake or DirectQuery without proper user access.

So workarounds are giving users access to workspace (viewer is not always enough), access to semantic model (build permission), access to underlying Lakehouse or Warehouse (read or SQL access). If using DirectLake then ensure users have read access to OneLake data

Also, you can ask affected user to open the dataset directly so if it fails then it is access issue