Andrew on 14 Jun 2019 21:56:24
We have the ability to Group tables and everything else within Query Editor. Even some grouping ability within Relationship view.
Currently the only sorting that occurs outside of the alphabet is your Measures tables go to the top.
Please add the ability to Group together Tables within the Report View of Desktop. It would be much easier to organize a data model that doesn't sort by alphabet no matter if it is a dimension, fact, or intermediate table.
- Comments (6)
RE: Group Tables in Report View
I was just going to submit this idea but thought I should vote and comment on this instead. This would be great for reports I work on that are cross departmental. For example Department A uses a different data source and tables then Department B I can organize the tables into folders labeled Department A and Department B.So if something needs to be in Department A's calculations of the report I can go know where and what table to implement this. Two departments aren't too hard to manage but if I have 5 or 6 it can get overwhelming.Even if we could organize by subject. If the report has multiple subjects or purposes, I can organize the tables by that.Right now the only folders we can create are at the measure or column table.
RE: Group Tables in Report View
I agree - for those of us with large model , we already use this feature in query editor. I believe the actual requirement should be to show the same groupings that are already in Query Editor in Report View
RE: Group Tables in Report View
This is 100% a good idea. When I am creating a dataset that other people are going to be able to use, it would make it alot clearer for the end users when I can group tables into buckets for the use case. ex. Data Tables, Dimension Tables, Measures.
RE: Group Tables in Report View
I'm surprised this doesn't have more votes! I'm working on a large shared dataset for project teams, and have a few dozen tables that I would love to be able to group into categories like "finance", "project", "schedule", "staff", etc. in the Fields panel view to make it easier for the team users to create reports off my curated dataset.
RE: Group Tables in Report View
Yes, this would be a significant improvement. Either allow us (as commented below) to carry over the table groups from the Power Query Editor view and or, allow us to create custom ones in Report view.
Dataflows and Datasets may be developed by different developers or under different meta schemas and so we could have to use different naming conventions at different levels.
Having the ability to group them the same or differently would be great for the long-range governance needs. Thanks
RE: Group Tables in Report View
Simply (optionally?) carrying through the PowerQuery groups into the table list and allowing the ability to collapse and expand a group would make the model far more readable, especially for shared data sets.