Load to Dataverse failed. Details

(0) Share

Report

Posted on by Arsnova

We are recevining the following error in Dataverse when trying to load data in a new Data Integration Project.

Loading data from SQL Server into Dataverse.

There was a problem updating the data stream. Please try again later.

Error code: Mashup Exception Error. Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: AzureDataLakeStorage could not get response: "Base connection closed: Connection was closed unexpectedly." Details: (Request ID: d545b43e-608f-4744-912a-7152bc2bc5c8)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (13)

Answers (1)

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Arsnova,

Are you still having this issue? Possible to share screenshots of the different Dataflow steps? It could be an authentication issue, try with an account that has no MFA. Cheers

Was this reply helpful? Yes No
Arsnova 28 on at

Like (0)

Report
Copy link

Link copied!

@EricRegnier ,Do I need to customize the Dataverse in the Admin Power Planform? Even if I try to insert data with 1 column but 20,000 rows, it gives this error. - Error code: Mashup Exception Error. Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: AzureDataLakeStorage could not get response: "Base connection closed: Connection was closed unexpectedly."

Was this reply helpful? Yes No
Arsnova 28 on at

Like (0)

Report
Copy link

Link copied!

Hello @EricRegnier ,
Yes, the problem persists. I am creating table / columns. Then I add data, but it turns out that I can only insert data into 7 columns. There is a problem with the 8th column, even if I delete the one with the data and add the one that did not work, then it will be added. But the one that deleted - it will not work to add, an error occurs when updating the data.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

No you don't need to edit in Dataverse in the Admin Power Platform. You can edit in make.powerapps.com. Possible to share the SQL service column and their datatypes and screenshot of paste the Dataflow transformation from the query editor?

Was this reply helpful? Yes No
Arsnova 28 on at

Like (0)

Report
Copy link

Link copied!

Hello @EricRegnier ,Yes of course.
columns are of data type INT and nvarchar.SQL ServerAdvanced editorAdding data from SQL Server to new table on Dataverse

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Arsnova,

Everything looks alright and hard to determine the exact issue, based on the error don't think it's the mapping. A few other hints/comments and questions:

You're importing 20k rows how long is that taking? It may be that it's taking too late and the connection is closed, hence the "Base connection closed" message.

Ensure that all Dataverse table text columns/fields are 150 in length or greater.

Try with a smaller dataset (1000 instead of 20k). Does that work? If not, try to isolate if it's a column mapping issue by mapping the column one by one and trying it still with a small dataset. I know this sucks but will help you identify the problem.

The SQL Server connection might timeout, try increasing it: https://docs.microsoft.com/sql/database-engine/configure-windows/configure-the-remote-query-timeout-server-configuration-option?view=sql-server-ver15

Hope this helps...

Was this reply helpful? Yes No
Arsnova 28 on at

Like (0)

Report
Copy link

Link copied!

Hello @EricRegnier , need to use Fast Combine with personal gateway?

Was this reply helpful? Yes No
Arsnova 28 on at

Like (0)

Report
Copy link

Link copied!

Hello @EricRegnier ,
I'm currently importing 230 rows of 8 columns. one-to-one column mapping. the columns are less than 100 characters long. If the problem was with the column length, it would throw a different error (it was checked). Gives an error 10-20 seconds after the start of the update.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Weird... it's hard to diagnose like this without access and understand the data... Have you tried submitting a Microsoft Support ticket at: https://admin.powerplatform.microsoft.com/support for more support? They might be able to provide more detailed error logs with their telemetry and internal logs.

Was this reply helpful? Yes No
Arsnova 28 on at

Like (0)

Report
Copy link

Link copied!

@EricRegnier , filed an application 2 weeks ago - a solution to the problem has not yet been found.

Was this reply helpful? Yes No