topic Re: Mashup Exception: Any ideas to try? in Dataflow

Mashup Exception: Any ideas to try?

RZ — Thu, 28 Dec 2023 14:23:51 GMT

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

Re: Mashup Exception: Any ideas to try?

v-cboorla-msft — Fri, 29 Dec 2023 07:10:26 GMT

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

Re: Mashup Exception: Any ideas to try?

RZ — Fri, 29 Dec 2023 07:59:21 GMT

Thanks.

Here is the ticket# 2312290050000243

Happy new year

I was hoping

Re: Mashup Exception: Any ideas to try?

RZ — Mon, 08 Jan 2024 08:11:52 GMT

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

Re: Mashup Exception: Any ideas to try?

v-cboorla-msft — Tue, 09 Jan 2024 11:44:03 GMT

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.