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

KarenL7's avatar
KarenL7
Advocate V
4 months ago

Hi Shai_Karmani 

thanks for this, I will be testing this solution this morning - I have redeployed the report into a separate workspace to update the permissions to test.  I had the same error, but once I changed permissions and refreshed the visuals it went away.


However, I need to test this with several users to confirm that it is working for them.  To confirm which permissions they need.

 

I will accept as solution once confirmed.

 

Thank you for your help.

 

Karen