Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
candicehan
Frequent Visitor

How to share a subset of the dataset used for a dashboard?

I have a dashboard created on a single table stored in SQL. It has 15 columns and for internal use. Now we would like to share the data from 5 columns to an external user. 

I did some research. If the BUILDING PERMISSION is granted to the external user, he/she will be able to connect to the dataset. However, he/she will see all 15 columns. How can I restrict the visibility or access to only the 5 columns of data we would like to share?

 

Thanks very much. 

1 REPLY 1
lbendlin
Super User
Super User

Power BI does not yet support Column Level Security.  You have to maintain a separate dataset that does only include the columns you want to share externally.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors