Forum Discussion

RZidaj's avatar
RZidaj
Regular Visitor
3 months ago
Solved

Dataflow Gen2 Mashup Error

Error Code: Mashup Exception Expression Error, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Expression.Error: We cannot convert a val...
CICD
data hub
  • v-achippa's avatar
    v-achippa
    3 months ago

    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

v-achippa's avatar
v-achippa
Community Support
3 months ago

Hi RZidaj,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

RZidaj's avatar
RZidaj
Regular Visitor
3 months ago

Hi Anjan!

Just letting you know that I found the issue and unfortunately it was actually rooted in my function. Once I changed the otherwise null in the function too, that's when the issue resolved. Thank you so much for checking if your solution worked!