Forum Discussion

knoah's avatar
knoah
Frequent Visitor
3 months ago

Issues with Semantic Model sharing

We're trying to share a report with business users at my organization. We've done this before, but now users are unable to see the data from the semantic model. We've isolated the issue to the semant...
data hub
one lake
security
cengizhanarslan's avatar
cengizhanarslan
Super User
3 months ago

Verify the semantic model's cloud connection. Go to the semantic model settings in the Fabric workspace → Data source credentials. The cloud connection determines the "effective identity" used for data access. If it uses SSO (Single Sign-On), the end user's identity is passed through to the warehouse. If it uses a fixed identity, that fixed identity must have the required permissions. Make sure the connection is set to OAuth 2.0 and that SSO is enabled if you want per-user access.

  • knoah's avatar
    knoah
    Frequent Visitor
    3 months ago

    The cloud connection is set to SSO, which is what we want to have happen - that the user credentials are passed through to the warehouse. The one thing that is different between an older model that's working as intended and this one that is broken is that the first has SQLServer as the data source, and the second has AzureDataLakeStorage as the data source mapping to SSO. They both point to the same warehouse, and as far as I can remember were set up in the same manner.