How do I break down one large table into a group of tables (database)?

[difaturoti]

Is there a table analyzer wizard tool in Power BI similar to the tool in Access that breaks down one large table into many tables in order to reduce redundacy and improve consistency?

[hthota]

Yes, we can break the single table into multiple tables. But it becomes complex to make relationship among them. Please check it once.

[difaturoti]

How do you so? I cannot find any material on line on how to proceed.

[hthota]

In Power Bi Desktop. Go to Edit Queries and Right click on the table create reference table and delete the unrequired columns in the reference table.

[difaturoti]

Thanks for responding. I would like to create a relational database from the large table, are you saying I can do that on Power BI?

[v-yulgu-msft · Accepted solution]

Hi @difaturoti,

There is no direct way to break down one large table into multiple relational small tables in Power BI. As hthota said, you may need to duplicate the source table in Query Editor mode, then, filter rows and remove unnecessary columns in duplicated tables. After that, you also need to establish relationship between them manually.

Regards,

Yuliana Gu