Forum Discussion
How to split a table with data into multiple seperate tables.
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
5 Replies
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-a/m-p/413068#M189602If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank you for your reply can we achieve this through dynamic partitioning?
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.
