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.
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.
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: | |