Unable to export data from Dataverse table - Connection to dataverse failed.

(1) Share

Report

Posted on by pwarago

Hi All,

We are trying to export data from msdyn_projecttask (Project Tasks table that belongs to Project for the web). But we are getting "Connection to dataverse failed . Please check the link below on how to fix this issue." error.

Can you tell us why?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (0)

SB-24090026-0 21 on at

Like (0)

Report
Copy link

Link copied!

I am having the same issue in my dev and production environments. If I backup my dev, create a new environment, and restore to the new environment, there is no problem in the new environment. Import also does not work. I have another thread on this and see yet another person with the same issues.

Was this reply helpful? Yes No
MichaelFP 1,847 Moderator on at

Like (0)

Report
Copy link

Link copied!

Have any logs in your environment? For example in the system jobs?

It is good to open the Developer toolbar (F12 or ctrl + shift + i) of your browser and look at network trace to get more details.

Was this reply helpful? Yes No
Shashank Bhide 946 Moderator on at

Like (0)

Report
Copy link

Link copied!

Project Operations uses PSS API which is no fun. However the PSS Api is used more for CRUD on msdyn_Project, msdyn_ProjectTask entity, there's a chance that the same framework is breaking internally, try to use the classic advanced find and see if you get the same error, else I'd open a support request

https://learn.microsoft.com/en-us/dynamics365/project-operations/project-management/schedule-api-preview

Was this reply helpful? Yes No
SB-24090026-0 21 on at

Like (0)

Report
Copy link

Link copied!
I have another thread that is showing the screenshots and DevTools. Here is the failure of CreateProjectEntity which happens on Import and Export:

Request URL:

https://projectmanagementservice.us-il301.gateway.prod.island.powerapps.com/api/DataManagement/CreateProjectEntity

Request Method:

POST

Status Code:

500 Internal Server Error

Remote Address:

52.250.230.72:443

Referrer Policy:

origin

Payload:

{projectName: "DMExport_2024_09_25T16_56_54_390Z", operationType: "Export",…}

connectionSetName: "DM_CdsToFile_39fe3be1746fef11a66d000d3a106a3a_1676e6a71aef4227af1f163114939180"

entityName: "rota_packitems"

fileFormat: "EXCEL"

operationType: "Export"

projectName: "DMExport_2024_09_25T16_56_54_390Z"

Response

{
"messageCode": "UnknownError",
"message": "[UnknownError] Type=Microsoft.PowerApps.CoreFramework.Communication.Http.NonSuccessHttpResponseException, StatusCode=NotFound, Msg=Server returned non-success HTTP response"
}

Was this reply helpful? Yes No
Suggested answer

jthewissen 28 on at

Like (1)

Report
Copy link

Link copied!

Hi,

We also experience the same issue and import failures on some of our environments.
I have found a workaround, atleast working for me.

1. Use the Edit with Excel feature

2. Connect to the Power Platform Environment (it will ask to login)

3. It will read data into the Excel sheet and save this as CSV file.

4. Edit the CSV file with a text editor and replace semicolon with comma.

5. Save the CSV file.

This CSV file can be used to import. If importing gives a HTTP error use the import function within the advanced settings view (there it works)
Hope this helps.

Kind Regards,

Jeannot Thewissen

Was this reply helpful? Yes No
Suggested answer

sandeep_angara 430 Moderator on at

Like (3)

Report
Copy link

Link copied!

@pwarago

The Dataverse connection might have been disconnected. To solve this, head to Connection tab and search for Dataverse connection. Then click on Reconnect. If you are seeing multiple connections and are disconnected., try reconnecting for all the connections.

I hope this resolves your issue. If it does, please mark it as a solution or let me know in the comments.

Thank you.

Regards,
Sandeep.

2 people found this reply helpful.

Was this reply helpful? Yes No