cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yuvarajm Visitor
Visitor

How to restrict the number of tables which show up in the fields section

As we know at times the our model might grow largerly and might have several tables in it , so if a new user wants to create a new reports it becomes difficult to identifty the fields that we need to use in any report . Is there a way that we can logically group these tables , so that the user can choose tables from the group which have the fields pertaining to his reporting needs.

2 REPLIES 2
AlexisOlson Member
Member

Re: How to restrict the number of tables which show up in the fields section

I'd suggest enabling the Modeling View and grouping your tables into different tabs.

 

Power BI Desktop Modeling View

Community Support Team
Community Support Team

Re: How to restrict the number of tables which show up in the fields section

HI @yuvarajm,

 

If your datasource is from sql service or other database who support t-sql query, you can try to direct use t-sql query(advanced option -> sql statement) to select and summary related fields to a new table instead of get data and load all tables to power bi.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 47 members 982 guests
Please welcome our newest community members: