cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Data Integrations not working at all? Unexpected Error

Hi PowerApps Community, 

 

I'm attempting to create a data integration project using a few different sources just as a POC, but one at a time.  I've tried with an OData source, I've tried with an Azure SQL Database source, and I've even tried the EXACT steps from this article (https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-cds-newentity-pq)... However, when I get to the 'Refresh settings' page, and attempt to click 'Save', I get an 'Unexpected Error' with the mashup query displayed with no additional information.  Is something currently broken in the service?  Am I missing something obvious?

55 REPLIES 55
Highlighted

@NGTS-AL: we may have a lead on the issue you're seeing. We will need to do some further investigation.

 

@Anonymous: can you share the full error message from the load screen for your issue?

 

Thanks!

Highlighted

@NGTS-AL, just wanted to give you an update that we are actively working on a fix for your issue.

Highlighted

I'm getting a similar issue when trying to import data into CDS for Apps:

Capture.PNG

 Mashup text is as follows (have redacted the exact URL of the file with "FIRST-PART-OF-URL-REMOVED"):

 

section Section1;
shared #"Tasks Excel format" = let
Source = Excel.Workbook(Web.Contents("FIRST-PART-OF-URL-REMOVED/Tasks%20Excel%20format.xlsx"), null, true),
Navigation = Source{[Item = "Tasks Excel format", Kind = "Sheet"]}[Data],
#"Removed columns" = Table.RemoveColumns(Navigation, {"Column3", "Column5"}),
#"Promoted headers" = Table.PromoteHeaders(#"Removed columns", [PromoteAllScalars = true])
in
#"Promoted headers";

 Thanks for letting us know the issue's being worked on!

Highlighted

@dazhangthanks for the update!
Highlighted

@Interlock, your issue is actually different. There appears to be some connectivity issue in the UK region, we are still investigating.

Highlighted

 @dazhang, thanks for that.   Will you let me know here when the UK issue is fixed, please?  Or is there another thread I can keep an eye on?

Highlighted

@Interlock, will do. There is an ongoing outage in the UK region, sorry for the inconvenience.

Highlighted
Helper II
Helper II

I have this situation too. I think, this is credential error. OData can import data to Common data table without auth(anonymous), but Windows and Basic auth do not work yet.Maybe it is error of password coding? P.S. I can open my odata url in IE after enter login and password (it is not windows auth), but azure import is not working.
Highlighted

Hey @agemlex, that sounds like a different issue than the ones raised in this thread. Would you mind starting a new thread and we can follow up with you on the details?

Highlighted

@dazhang wrote:

Hey @agemlex, that sounds like a different issue than the ones raised in this thread. Would you mind starting a new thread and we can follow up with you on the details?


https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/CDS-OData-integration-Invalid-crede... my post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Users online (8,563)