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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
JeffMcBride
New Member

Making simple self service datasets from Complex Datasets

I have a very complex PowerBI DataSet with litterally thousands of columns and scores of tables joined together in the model.  The model works and is meeting the needs of report creation for relatively sophisticated PowerBI users.  However, I want to create a simpler view of this Dataset that a novice powerBI user could work with to build simple reports.   

 

I know I can make a copy of the .pbix file and hide all the columns I don't want visible in the "Simple Version", but then if I publish it, I bascially have duplicate models in my Premium service of the exact same data and I also have to worry about keeping them in synch going forward.

 

Is there a way to allow some users to see all the columns and other users a limited list of columns.

 

Thanks in advance,

1 REPLY 1
GilbertQ
Super User
Super User

Hi @JeffMcBride 

 

You can use perspectives to do what you are looking to do, here are more details: 

Let users personalize visuals in a report - Power BI | Microsoft Docs





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.