Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

On-Premise Gateway Connector: error Couldn't Create Data Source

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi !

I'm trying to import orders data into CI (Trial) from on-premise Sql Server database using On-Premise Gateway Connector.

I've installed On-Premise Gateway Connector on local machine and using local Sql Server instance for proof-of-concept.

I've successfully registered Gateway Connector and created connection at Power Apps Portal. 

Next step is to create Data Source in CI. I can see all orders in Power Query:

Image-983.png

But when I click "Save" button - error message is displayed:

Image-984.png

I've checked browser network trace (from Developer Tools): request to /manage/datasources returns Http 503:

{"exception":null,"httpStatusCode":503,"exceptionCulprit":"System","errorCode":"DataSourceCreateOrUpdateFailed","resultSeverity":"Error","message":"Failed to create/update data source.","name":null,"params":{"InstanceId":"df41d518-d59a-42c5-83c2-6698752f7454","DataSourceId":""},"ciResults":null}

Any ideas ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: On-Premise Gateway Connector: error Couldn't Create Data Source

    Hi,

    Please find answers below.

    "Is your Power Apps a production or trial?" - Trial

    "Does the gateway page show any update required?" - No

    "Can you use the gateway in power apps? Try to add a dataflow on power apps, not just verify that the gateway is show" - Yes. I have created new Dataflow in PowerApps with this Gateway and data were imported. Please see screenshot below:

    pastedimage1627457153163v1.png

    "Do you see this page with the gateway listed in both Power apps and CI?" - Yes.

    "The issue seems to be that there is no consent given in the customers AAD tenant to use the PQO app. They should try the same with a user that has admin privileges on the customer's AAD tenant - and give consent when prompted" - I have admin rights in CI and PowerApps. Please see screenshot below. I have admin rights in CI and "Environment Maker", "System Administrator" and "System Customizer" in Power Platform

    pastedimage1627457711845v2.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: On-Premise Gateway Connector: error Couldn't Create Data Source

    Bill,

    Region is the same for CI and Data Gateway Connector - North Europe. I've already opened support request. The only thing I want - is to check how Data Gateway Connector is working and can we use it on production.

  • Bill Ryan Profile Picture
    Bill Ryan 8 on at
    RE: On-Premise Gateway Connector: error Couldn't Create Data Source

    Ivan, I  really suspect it's the region issue. I think you can hit the ? icon in Ci to open a request (even though it's a trial) but we've had to have it moved before.  B/c you can see it in PQ editor, I really think that's ultimately it but there's no way I know of to get around it without MS intervening.  I'm not trying to punt in any way, but are you just needing to get this up and running to prove a concept like Matching and merging or does the specific source matter?

  • Dev Squid Profile Picture
    Dev Squid on at
    RE: On-Premise Gateway Connector: error Couldn't Create Data Source

    Hi, sorry you are having this experience. I would like you to perform some checks in order to see if everything is in place.

    • Is your Power Apps a production or trial?
    • Does the gateway page show any update required?
    • Can you use the gateway in power apps? Try to add a dataflow on power apps, not just verify that the gateway is show
    • Do you see this page with the gateway listed in both Power apps and CI?
    • pastedimage1627405654468v1.png

    Also please ensure the following

    The issue seems to be that there is no consent given in the customers AAD tenant to use the PQO app. They should try the same with a user that has admin privileges on the customer's AAD tenant - and give consent when prompted.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: On-Premise Gateway Connector: error Couldn't Create Data Source

    Hi Bill,

    Error comes from XHR POST request to /manage/datasources. It returns HTTP Status 503 (Service Unavailable):

    {"exception":null,"httpStatusCode":503,"exceptionCulprit":"System","errorCode":"DataSourceCreateOrUpdateFailed","resultSeverity":"Error","message":"Failed to create/update data source.","name":null,"params":{"InstanceId":"bce3bc8d-d617-4e20-8735-7d8f610bb84a","DataSourceId":""},"ciResults":null}

    I have created brand new Trial environment - it did not help. The same error.

  • Bill Ryan Profile Picture
    Bill Ryan 8 on at
    RE: On-Premise Gateway Connector: error Couldn't Create Data Source

    Ivan, these trial environments can be a little wonky for sure.  I just ran through one of my instances and do not have any issue with creating a new source once I have a CDS one.  The fact you can get the data back though, is really intriguing.  If you open up the Developer tools or Fiddler, can you see what specific errors are coming back?  And just to be clear, this one was the one that was reset or is it a totally new environment? I've had a case before where it looks like something broke in terms of metadata so even after resetting the environment the issue persisted but if this is a totally clean one, IDK

  • Bill Ryan Profile Picture
    Bill Ryan 8 on at
    RE: On-Premise Gateway Connector: error Couldn't Create Data Source

    So you can definitely hit CDS but other sources you can't, is that right?  There could be a few different reasons and it might just be a coincidence that it's both SQL Server and OneDrive. The first thing i'd do is try to see if I can access either both through Power BI Desktop, if not the problem is with the sources. The fact the data comes in is really interesting, I've never seen that happen before.  At what point exactly is that error happening?  I might try to just pull in Source first, save, then try again with Navigation, Promoted headers.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: On-Premise Gateway Connector: error Couldn't Create Data Source

    Created new Trial Environment.

    It seems I cannot create new Data Source other than CDS:

    pastedimage1627056380294v1.png

    When I'm trying to import data from On-Premise SQL Server I got an error (despite the fact that I can see data from sql table):

    pastedimage1627056423465v2.png

    The same error appears when I'm trying to import data from Excel (OneDrive):

    pastedimage1627056523674v3.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: On-Premise Gateway Connector: error Couldn't Create Data Source

    I cannot reset environment :( After clicking reset I’ve got an error (Error occurred during reset). I’ve tried is several times – the same error.

    pastedimage1627032160122v1.png

    pastedimage1627034412242v1.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: On-Premise Gateway Connector: error Couldn't Create Data Source

    Yes, I have single Data Source - Common Data Service (Sales 365). Ok, I'll try to reset environment.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans