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

[yuvarajm]

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.

[Anonymous]

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

[AlexisOlson]

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

Power BI Desktop Modeling View