Forum Discussion
Data sharing with another area
Hi Anonymous,
Are you wanting to restrict data based on columns or rows?
FOr column level security in the model, you will need Tabular Editor:
Object-Level Security (OLS) with Power BI - Microsoft Fabric | Microsoft LearnIf you're ingesting all the data into a warehouse, you can also apply column level security at the warehouse level:
Column-Level Security in Fabric Data Warehousing - Microsoft Fabric | Microsoft LearnIf you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi Anonymous ,
To cater this problem It is recommended to create a new dataset with restricted columns & grant 'Build' access
You can follow these steps :
Step 1 – Create a new Power BI dataset
Open Power BI Desktop.
Instead of connecting directly to the dataflow, connect to your existing published dataset:
Home → Get Data → Power BI datasets → choose your existing model (the one with fopag).
You’ll now have a live connection to your dataset.
In Model view, only select or keep the fields and tables they need (exclude salary/compensation).
Save and publish this as a new dataset (e.g., Fopag_Restricted).
This new dataset automatically stays updated when the original refreshes.
Step 2 – Grant “Build” access
In the Power BI Service:
Go to the new dataset’s settings → Manage permissions.
Add the group or users from that area.
Give them Build permission.
That allows them to:
Connect directly to your dataset using Power BI Desktop or Excel.
Create their own reports or models that stay synced with your data.
⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together!🚀 [Explore More]