Forum Discussion

Jessy_D's avatar
Jessy_D
Helper I
8 months ago
Solved

Setting permissions correct

Hi, We just started with Fabric, but are stuck with the permissions. For the moment we use a F2 capacity. We use the medallion architecture. The lakehouse, warehouse and semantic model are in W...
security
workspaces
  • Jessy_D's avatar
    Jessy_D
    8 months ago

    Hi,

    No, I'm not working in MSFT for the cert exams. I did some of the examns and the security was my weak spot ğŸ˜…
    I checked everything and the settings were all correct. 
    But then I checked my semantic model again, and because I made it directly on the warehouse, the tables were in direct lake storage mode (no idea yet how to change that when creating them directly from the lakehouse in fabric). So I gave the user read rights to the warehouse and it was solved.
    But thanks for helping me think about all the steps.

tayloramy's avatar
tayloramy
Super User
8 months ago

Hi Jessy_D, 

 

I believe when sharing with an app, it won't automatically grant read to the semantic models on a different workspace. 

 

You should just need to grant read on the models, not viewer on the workspace. 

 

Note that free users will not be able to view the reports, you need an F64 or higher capacity for that. 

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

Jessy_D's avatar
Jessy_D
Helper I
8 months ago

I gave read rights to the semantic model in the other workspace, but when I check the report, I then get the following error on each visual using that data: 

  • Underlying Error QueryUserError
  • Activity IDaf138442-1b6f-446d-b425-fcc6a8343cca
  • Correlation IDe31d7aa2-94bb-f181-a16c-677f49b527b4
  • Request ID57c23deb-7f6d-4165-8ddf-557808ad7e3d
  • TimeWed Dec 17 2025 16:22:55 GMT+0100 (Midden-Europese standaardtijd)
  • Service version13.0.27228.39
  • Client version2512.1.27028-train
  • Cluster URIhttps://wabi-west-europe-e-primary-redirect.analysis.windows.net/