Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm appending a very long list of queries (60+), with complex names. In the Append1 result table, I would like to still be able to filter between the original queries.
Does anyone know a way to avoid having to manually add a new Source.Query column with a custom string with the name, for each query?
Thanks,
Pietro
Solved! Go to Solution.
Hi @Anonymous
you could create some M-code that generates a table with the column names:
let
Source =
#table({"Query", "Sourcename"},
{
{#"Table", "Table"},
{#"Table2", "Table2"}
})
in
Source
Then expand out the fields from the columns.
Usually, one would go the other way around and start from a table with the source names (and the connection to their sources), apply a function that transforms them all and expands the column there.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @Anonymous
you could create some M-code that generates a table with the column names:
let
Source =
#table({"Query", "Sourcename"},
{
{#"Table", "Table"},
{#"Table2", "Table2"}
})
in
Source
Then expand out the fields from the columns.
Usually, one would go the other way around and start from a table with the source names (and the connection to their sources), apply a function that transforms them all and expands the column there.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries