Forum Discussion
Setting permissions correct
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.
Hi Jessy_D are you sure you are not working for the people in MSFT that does the cert. exams?! It looks like an exam question 😅 ... here's the
#1. Enable cross‑workspace semantic model usage (Admin setting), this governs sharing and discovery across workspaces.
#2. Grant direct item permissions on the semantic model (Workspace A), from Workspace A → Semantic model → More (…) → Manage permissions:
- For app consumers: grant Read (or App) permission as they don’t need workspace Viewer
- For report authors in Workspace B (who need to build/refresh reports) grant Build permission
With F2, Fabric Free users cannot consume Power BI apps (and cross‑workspace semantic models), so in addition ...
#3. Upgrade App audiences to Power BI Pro
Let me know iof this works, in particular, take a closer look to Introduction to Semantic Models Across Workspaces - Power BI | Microsoft Learn and current consideration and limitations.
Hope it works as you expected, I would appreciate a thunbs up if this information has been useful, and mark as solution if appropiate, here if you need a follow up 😉 ... best of lucks!
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.