Error Code: Mashup Exception Expression Error

[DLAMANSAW12]

Everytime I run dataflow I get this error code:

When I keep only the top 8 rows, I'm good but I need the entire dataset 10,000+ rows. When I keep only 20 rows I get this error message.

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: Failed to insert a table., InnerException: We cannot convert a value of type List to type Text., Underlying error: We cannot convert a value of type List to type Text. Details: Reason = Expression.Error;Message = We cannot convert a value of type List to type Text.;Message.Format = We cannot convert a value of type #{0} to type #{1}.;Message.Parameters = {"List", "Text"};Microsoft.Data.Mashup.Error.Context = User (Request ID: 246d748b-ebd4-44a0-856b-c271badf45b1).

When I publish the dataflow without the keep the rows step I get this same error message above but in regards to not being able to convert the record to type text. 

Any help or insight would be greatly appreciated. 

[v-cboorla-msft]

Hi @DLAMANSAW12 

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience.

The error message points to a type mismatch issue during data transformation within your Dataflow Gen2 mashup document.

Mashup Exception Expression Error: This indicates an error in the M code used for data transformation within the mashup document.
Couldn't refresh the entity...: The refresh process for the entity (likely a table) failed due to the M code issue.
Expression.Error: Failed to insert a table.: The specific error lies within an expression attempting to insert a table.
InnerException, We cannot convert a value of type List to type Text.: The core problem is that the expression is trying to insert a list of values (data type List) into a column expecting text.

Review Your M Code: Carefully examine the M code within your mashup document, particularly sections that involve data manipulation and table creation. Look for lines where you might be trying to insert a list of values into a text column. You should be able to identify the specific cause of the type mismatch and apply the appropriate solution.
Focus on Column Definitions: Pay close attention to how columns are defined within your tables. Make sure the data type of each column accurately reflects the kind of data it should hold. If a column is intended for text values, it shouldn't be defined as a list type.
If you are using Text.From to join list elements, it might be causing the issue. Switch to Text.Combine, which is specifically designed for list concatenation into text.

I hope this information helps. Please do let us know if you have any further questions.

Thanks.

[DLAMANSAW12]

Hey, thanks for getting back to me. Yes I've realized that the error is coming from the list the only issue is that its coming in as a list due to it coming back from the API I'm trying to expand the list and follow that up with expanding the records to get the data from the API to show in columns in power query. Let me know if you have any thoughts on this. 

[miguel]

could you transform this to a table instead of using a list?

[v-cboorla-msft]

Hi @DLAMANSAW12 

Apologies for the inconvenience.

Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

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

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

[v-cboorla-msft]

Hi @DLAMANSAW12 

We haven’t heard from you on the last response and was just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

Thanks.