Forum Discussion
Create table for each value (error message) from column
I have a table in Power BI. There are error messages in a column.
Now I want to create tables for each error messages.
I grouped them and then made a new query out of them. That works too.
BUT, if later a new error message appears for which no query was created, no table will created for this error message.
I want a table showing all errors of an error type, for example "Batch error 1"
Is there a way that a new table is always created for each type of error in a column (error message)?
I only created the example of the data in excel for illustration purposes.
I would be glad, if somebody can support me.
Best wishes
3 Replies
Hi Anonymous ,
When you say "a new table is created", I assume you mean a new query is created in Power Query?
Power Query cannot spawn new queries itself.
I'd need to understand a lot more about what you're trying to achieve in order to advise if there's an alternative solution/workaround.
Pete
I think I understand what you want, I really need to understand the WHY part of it.
Splitting up tables like this in Power Query for use in Power BI is neither a standard process nor a recommended one. Power BI is designed to have all similar data in a single table coming from Power Query, then DAX is used to partition the data for analysis/display.
If you can let me know WHY you believe you need to physically split up the tables in Power Query, when they contain similar data, then I can advise on whether this is actually the fastest/best route to your desired end goal or not, and probably avoid an XY Problem in the process.
Pete
