How to split a table with data into multiple seperate tables.

[HafizNadeem]

here we have a data table that contains all the tables that have been imported from the database. now I want to split this table into multiple separate tables automatically rather than doing it manually. as shown in the screenshot 

[Ritaf1983]

Hi @HafizNadeem 
Unfortunately, it is not possible to divide a large table into several smaller ones automatically...
The attached link leads to a discussion of the same operation with a different logic
https://community.powerbi.com/t5/Desktop/Splitting-a-Table-into-several-tables-based-on-the-value-of...

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

[HafizNadeem]

thank you for your reply can we achieve this through dynamic partitioning?

[Ritaf1983]

Unfortunately, PowerBI does not include such an option.
If it is an existing model, this can be done by duplicating and filtering one table at a time.
If it's a new model, pull each table separately.

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

[HafizNadeem]

I mean to say in a tabular model??

[Ritaf1983]

Sorry , tabular model is out of my knowledge