Forum Discussion
Dataflow Gen2 Mashup Error
Hi RZidaj,
Thank you for reaching out to Microsoft Fabric Community.
Here looks like the issue is related to Dataflow Gen2 handling the Issues column as text during the refresh, while the function is actually returning a table.
So please try explicitly keeping the column type as table and avoid returning null. Please try this below query:
Table.AddColumn(#"Filtered Rows", "Issues", each try fnGetAllIssues([Project Key]) otherwise #table({}, {}), type table)Also please check and remove any automatic changed type step for the Issues column if present.
Thanks and regards,
Anjan Kumar Chippa
Hey RZidaj,
If you want the 'Issues' column to contain a nested table that you can later expand, use a row-context filter explicitly.
Example:
Table.AddColumn(
#"Filtered Rows",
"Issues",
each
try
Table.SelectRows(
fyleDetails,
(x) => x[Project Key] = [Project Key]
)
otherwise
#table({}, {})
)Your current expression is effectively returning:
- sometimes a List
- sometimes a Table
- sometimes null
Power BI Desktop tolerates this more than Dataflows do.
Dataflows require stronger type consistency during cloud refresh. In the updated expression, now the column is always a 'table' type.
Best,
Harshit
Thanks for explaining this to me clearly While your suggested query returned a different result than I was expecting (it returned only a single row of result as opposed to all rows) it helped me understand where my problem was