cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

How to connect an On Premise Gateway SQL table to a CDS table?

We are up and running in PowerApps using the On Premise Gateway.

Next thing we want to accomplish is connect the NAV data table (SQL table) via the On Premise Gateway to a custom defined CDS table.

We discovered this URL in how to, be we cannot follow the steps i.e. we do  not know how.

URL: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-cds-newentity-pq

Can you help us with this and possibly as soon as possible?

3 REPLIES 3
Highlighted
Power Apps
Power Apps

Re: How to connect an On Premise Gateway SQL table to a CDS table?

Adding @millopis from the Power Query team.

Thanks,
Clay.
Highlighted
Frequent Visitor

Re: How to connect an On Premise Gateway SQL table to a CDS table?

Would be nice to see an answer to this please, it is one of the first hits in a web-search.

 

Highlighted
Microsoft
Microsoft

Re: How to connect an On Premise Gateway SQL table to a CDS table?

Hi @dannyhellemons

 

Can you share with what steps in creating a dataflow to load data into CDS are you are having trouble with?

 

In PowerApps.com, you should be able to locate the Dataflows tab. When you create a new dataflow, the first step would be to give it a name, and then, select the data source to get data from. In select data source screen, select "SQL Server database" data source and the next screen will be asked for the connection details. This is where you should be able to provide the details of the gateway, in the "Connection credentials" section the On-Premise data gateway you have installed. (See attached image) If you cannot see the gateway you installed in the drop-down list, then you should follow these steps to make sure its been set up correctly in the PowerApps environment.

 

How to setup and manage a gateway:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/gateway-management

Please note that the gateway must be Installed in standard mode because the on-premises data gateway (personal mode) is available only for Power BI.

 

 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (8,424)