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.
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.
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 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.