Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
assume I have a column "Location" with a stringvalue like "PlaceA", "PlaceB", "PlaceC" and so fourth. Every string has many rows in that big table. I want to separate that table, instead of having one big table I want several smaller tables to work with.
Is there a way to extract those from the big table? Otherwise I need to do it manually and that takes a lot of time.
Solved! Go to Solution.
Generally, it's better to have a single table rather than multiple tables with the same structure but it should be possible to split if you need to for some reason. You would create a query for PlaceA that references the big table and then filter for "PlaceA" in the "Location" column. Repeat for each smaller table.
Note that while you can duplicate each small table query to create the next small table query, I don't think there's a way to automatically/dynamically separate a single query into multiple tables. Each table that gets loaded to the data model from Power Query must have its own query.
Generally, it's better to have a single table rather than multiple tables with the same structure but it should be possible to split if you need to for some reason. You would create a query for PlaceA that references the big table and then filter for "PlaceA" in the "Location" column. Repeat for each smaller table.
Note that while you can duplicate each small table query to create the next small table query, I don't think there's a way to automatically/dynamically separate a single query into multiple tables. Each table that gets loaded to the data model from Power Query must have its own query.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
40 | |
26 | |
22 | |
21 | |
16 |