moving fields/column in another folder out of there dedicated table in Power bi desktop

[Anonymous]

Hi there,

I'm transitioning from Tableau to Power BI Desktop and was wondering about organizing data structures. In Tableau, I could easily move fields between tables by placing them in manually created folders. I've tried using the properties pane in Power BI, but it seems that fields are restricted to their original tables.

Could you advise on alternative approaches for achieving a similar level of organization within Power BI? Any insights you can offer would be greatly appreciated.

Thanks,

Azad

[Anonymous · Accepted solution]

Hi @Anonymous ,

Power BI's Query Editor offers extensive capabilities for data transformation and organization before loading it into the model. You can merge or append queries to consolidate fields from different tables, effectively organizing them as needed. For detailed steps on how to use these features, please refer to the official documentation on combining data:

Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn

The append operation creates a single table by adding the contents of one or more tables to another, and aggregates the column headers from the tables to create the schema for the new table.

Append queries - Power Query | Microsoft Learn

A merge queries operation joins two existing tables together based on matching values from one or multiple columns:

Merge queries overview - Power Query | Microsoft Learn

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.