Forum Discussion
Create a folder structure for tables in Power BI Desktop
Hey.
I have a lot of tables and I would like to know if the tables could be put together in a folder structure. I know that columns could be, and that's not what I am looking for. I also was able to create groups with tables in it in "edit queries" option, but I want the structure in the report view.
If it is not possible, I at least need to know that. Please help.
Hi Anonymous ,
Based on my research, I am afraid you could not achieve this feature currently, I sugges you vote for below idea:
Regards,
Daniel He
6 Replies
Hi Anonymous ,
Based on my research, you could refer to below link:
https://blog.crossjoin.co.uk/2018/11/14/nested-display-folders-in-power-bi/
Expected result:
Regards,
Daniel He
thanks a lot v-danhe-msft for the reply. Like I mentioned in the issue, I know that columns could be put together in groups. I am looking for such thing regarding tables.
Hi Anonymous ,
Based on my research, I am afraid you could not achieve this feature currently, I sugges you vote for below idea:
Regards,
Daniel He
Anonymous You can logically group the tables in "Power Query Editor" only but not on the report view.
Hi!
Let me share my workaround, even though the thread is pretty old.
The easiest way to structure the data in the Data (Field) Pane is to structure the table names.
1. Use DIM, FACT, MSR, PAR, etc. prefixes to differenciate between the kind of data
2. Use standardized table names to cluster the tables: "FACT_Supply_...", "FACT_Sales_...", etc. or "Supply_Fact_..." , "Sales_Fact_..." etc. depending on your preferences.
The pane is sorted by alphabet. So, the clusters are created "automatically".Altertenative naming: Use an outlined structure and number your tables e.g. "0101_FACT_Revenues", "0102_FACT_Sales", "0201_FACT_Regions", etc.
I hope this is a helpful idea for everybody with the same problem.
