Forum Discussion

RZ's avatar
RZ
Frequent Visitor
2 years ago
Solved

Mashup Exception: Any ideas to try?

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

 

  • 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

4 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee

    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

  • RZ's avatar
    RZ
    Frequent Visitor

    Thanks.

     

    Here is the ticket# 2312290050000243

     

    Happy new year

     

     

    I was hoping 

  • RZ's avatar
    RZ
    Frequent Visitor

    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's avatar
      v-cboorla-msft
      Microsoft Employee

      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.