Showing results for 
Search instead for 
Did you mean: 
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. 

Super User III
Super User III

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

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors