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

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
3 months ago

Hi KarenL7,

Based on our understanding, since users are able to access the semantic model, create DAX queries, and interact with slicers or dropdowns, but the visuals continue to fail, this behaviour likely points toward an upstream query execution or identity propagation issue during visual rendering. Visuals may execute live backend queries using the viewer's identity and may still validate access across upstream dependencies such as Eventhouse or other lineage items.

Kindly follow the validation steps mentioned below:
1.Review the complete lineage view to identify any remaining upstream dependencies.
2.Verify permissions not only on the semantic model, but also on all upstream objects such as Eventhouse or other entities involved in the lineage chain.

At this stage, we kindly request you to raise a Microsoft Support ticket and provide all relevant details for a deeper backend investigation using the link: Microsoft Fabric Support and Status | Microsoft Fabric

We hope the information provided above helps in resolving the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

KarenL7's avatar
KarenL7
Advocate V
3 months ago

Hi v-pnaroju-msft  I have raised a support ticket for this.

mainly as ai can see the eventhouse and dependencies now. 

 

I am unsure if this is the reason, as we do not want users to have access to these -Although it has been explained - why you have to give permissions to other areas which have nothing to do with the lakehouse concerned for a user to look at visuals?   Particuarly when the user can query the dataset and open the model -  so I have asked the question.

  

 

I will keep looking and testing permissions in the meantime, and if anything else works I will update.

 

Thank you all for your help, hopefully something will work!

 

Karen