Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
I'd suggest enabling the Modeling View and grouping your tables into different tabs.
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |