Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Proud to be a Datanaut!
Yeah query / table... i mean the same.
I have a column. With Error 1, error 2, error 3. Can I create a table/query, which is generated for each error a new table/query from this column? Well I find already a solution, but its not so smart.
Or do you not understand what I mean?
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
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.