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,
Thankyou for the update.
We kindly request you to share the feedback provided by the support team with the community, as it will help other members facing similar challenges and benefit the broader community.
Thanks
Just to confirm - I did raise a support ticket in the end. However, when I tried to share the issues, I was unable access the report either and had a permissions issue with the report and all the tables failed, including the dax - and I am an admin!
To resolve the issue I did the following -
- rebuilt the report totally from scratch
- looked at the lineage and changed permissions on the workspaces, and lakehouse - to ensure the user had read all, execute on sql endpoint on the original lakehouse.
- They did not require any permissions on the event house which was upstream which is attached to the development version of the lakehouse
- I published the new report and they were able to see it.
It has taken a very long time and several reports, but I have got there.
Thanks to everyone for your help and patience, but permissions and a new report seems to have worked. It has been very frustrating!
Karen