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,

 

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

  • RZidaj's avatar
    RZidaj
    Regular Visitor
    3 months ago

    Thanks so much Anjan!

     

    Your suggested query returned the result (all rows). Unfortunately I pressed the solution button a bit too quick and I'm still getting the same mashup error when selecting save & run 

    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 value of type Table to type Text. Details: Reason = Expression.Error;ErrorCode = 10276;Value = #table({"Value"}, {});Microsoft.Data.Mashup.Error.Context =

    • RZidaj's avatar
      RZidaj
      Regular Visitor
      3 months ago

      I'm wondering if this could be the problem step

      I've just updated it to this below but it's also still returning the same error

      Table.FromList(Source, Splitter.SplitByNothing(), {"PRs"}, #table({}, {}), ExtraValues.Error)
       
      • v-achippa's avatar
        v-achippa
        Community Support
        3 months ago

        Hi RZidaj,

         

        Here looks like the issue is still related to the PRs column. The Table.FromList step looks fine, please change the step back to:

        Table.FromList(Source, Splitter.SplitByNothing(), {"PRs"}, null, ExtraValues.Error)

         

        The error is likely happening in a later step during refresh. Please try removing any auto-generated Changed Type after the PR and Issues column is created and explicitly expand the columns directly after creation.

        Dataflow Gen2 refresh is somewhat stricter than desktop when handling the nested record or table values, so queries that work in PBIX preview can still fail during Save & Run.

         

        Thanks and regards,

        Anjan Kumar Chippa