Forum Discussion

marius1106's avatar
marius1106
Helper II
3 months ago
Solved

Seperate Semantic Model Permissions between Excel and Power BI

Dear Support Team, I want to grant customers access to an Excel report built on a semantic model. However, this requires Build permissions on the dataset, which also allows them to create Power BI r...
Need Help
Tips and Tricks
  • cengizhanarslan's avatar
    cengizhanarslan
    3 months ago

    There is no way to separate Build permission between Excel and Power BI. Build permission is a single, unified permission that grants the user the ability to connect to the semantic model from any client tool, including Excel (Analyze in Excel), Power BI Desktop, and third-party tools via XMLA. You cannot allow Excel access while blocking Power BI Desktop access at the permission level.

v-ssriganesh's avatar
v-ssriganesh
Community Support
3 months ago

Hi marius1106,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to cengizhanarslan for sharing valuable insights.

 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you for being part of the Microsoft Fabric Community.