Data sharing with another area

[gdps_vc]

Greetings everyone!

I have the following situation here where I work:

I have a premium workspace where IT has provided a data flow containing all the facts and dimensions related to the company's employees. One of these tables (fopag) contains payroll information + organizational structure data. And only IT can edit this data flow.

To share this information, I created a BI containing a table, which other areas access to extract an excel file.

However, one specific area got tired of extracting the excel and asked if they could consume the data in a more automatic way (they use the extracted excel to feed their own BI).

How can I do this? In the case of this area, they could have access to all fopag columns, except those related to compensation data.

Best regards

[v-aatheeque]

Hi @gdps_vc 


We’d like to check if you were able to go through the previous response to your issue. Please let us know if you need further clarification we’ll do our best to support you.

[v-aatheeque]

Hi @gdps_vc 

We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.

[gdps_vc]

But how do I select only the columns I want to keep?

After loading the data as a live connection, there seems to be an option to hide the column/table—but it is disabled for me.

[tayloramy]

Hi @gdps_vc, 

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 Learn

If 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 Learn

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

[tayloramy]

Hi @gdps_vc,

Here’s how I’d enable “automatic” consumption while protecting compensation columns.

1. Use a semantic model with Object-Level Security (OLS)
   Build a dataset on top of fopag and apply OLS to hide the compensation columns from that specific area. Grant them Build permission on the dataset so they can connect to it (Live connect, Analyze in Excel, or their own reports) without ever seeing those columns. OLS lets you secure specific columns/tables in a model. See: Object-level security (OLS).
2. Or publish a curated “safe” table and share it via OneLake/Warehouse
   Have Dataflow Gen2 write fopag (minus compensation columns) to a Lakehouse/Warehouse in a shared (or new) workspace, then:
   • Share it via OneLake shortcuts to the requesting area’s workspace (no copying, central governance). See: OneLake shortcuts.
   • Or expose it through the Warehouse SQL endpoint so they can pull it directly with ODBC/JDBC/SQL tools into their BI. See: Connect to Fabric Data Warehouse and Warehouse connectivity.
   Dataflow Gen2 supports writing directly to Lakehouse/Warehouse destinations. See: Dataflow Gen2 destinations.
3. Label and govern the data
   Apply sensitivity labels (e.g., “Confidential – HR”) to the dataset/table so protection and auditing follow the data across exports and usage. See: Sensitivity labels in Power BI and Information protection in Fabric.

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

[GrowthNatives]

Hi @gdps_vc , 
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]