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
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
Thank for coming back to me.
Just to confirm - "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."
I have given read permissions on the original lakehouse but not access to the original workspace (as we do not want this) - note we did this through an workspace app-
So we set up a copy of the lakehouse with full permissions, with access to that workspace - and they can now access the dataset as mentioned above
So what further do we need to change?
Thank you so much for your help
Karen