Mashup Exception: Any ideas to try?

[RZ]

I have been trying to solve a MashUp exception error for some time now. 

I have managed to simply the problem as follows. I have a main and related table, they have a common id between themselves. For debugging purposes the main table has only one column "id" and one row.

And I have a function GetRelated(id) that retrieves the related records from an API given an id. When I add a column with a call to this function referencing the id and then remove the column; DataFlow gives a MashUp Exception when published but looks fine in the PowerQuery Editor. Just a note: the error is the same if I dont remove the column.

Fail

let
    Source = mainTable,
    #"Invoked Custom Function" = Table.AddColumn(Source, "related", each GetRelated([id])),
  #"Removed columns" = Table.RemoveColumns(#"Invoked Custom Function", {"related"})
in
    #"Removed columns"

However if I retrieve the related records outside the failing query in another table...

GetRelatedInAdvance:

let
  Source = GetRelated("98035f6c-e16f-46cd-9fea-08db04f8aa2f")
in
  Source

And then add this table into a column

let
    Source = mainTable,
    #"Invoked Custom Function" = Table.AddColumn(Source, "related", each GetRelatedInAdvance),
  #"Removed columns" = Table.RemoveColumns(#"Invoked Custom Function", {"related"})
in
    #"Removed columns"

The flow works. Looks the same as the failing one in the editor.

What else should I look into?

Thanks

Ruchan

[RZ · Accepted solution]

OK.  I had two calls with Microsoft Support without a resolution yet. But in the meanwhile I found a way around it, as I was able to get closer to the core issue.

The function GetRelated(id) was accepting id as any. Changing this to text fixed the issue. I also had to create another version when I needed  to call the function with a record. 

Maybe this will help someone...

Ruchan

[v-cboorla-msft]

Hi @RZ 

Glad to know that you got a work around for your query.

Please continue using Fabric Community for any help regarding your queries.

[RZ]

Thanks.

Here is the ticket# 2312290050000243

Happy new year

I was hoping 

[v-cboorla-msft]

Hi @RZ 

Thanks for using Microsoft Fabric Community.

Apologies for the issue you have been facing.

This might require a deeper investigation from our engineering team and they can guide you better.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support
Please provide the ticket number here as we can keep an eye on it.

Thanks