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.

cengizhanarslan's avatar
cengizhanarslan
Super User
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.