cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Coco_PowerApp
Microsoft
Microsoft

Why PowerApps does not support the gateway to connect Azure SQL database?

PowerBI could use gateway to connect Azure SQL database. (Even though I know that is not necessary.)

So, why the PowerApps does not allow the gateway to connect the Azure SQL database?

It looks supported as it is mentioned here: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-faq

Question: Do I need a gateway for cloud data sources, such as Azure SQL Database?

Answer: No, services can generally connect to cloud data sources without a gateway. However, you might need a data gateway if your data sources are behind a firewall, require a VPN, or are on virtual networks.

 

That's totally the same as our condition. We have the data sources which are behind a firewall, required a VPN, and we have the virtual networks. But when I do this it give me this error, please see the attachment.
 

The same gateway we used in PowerBI without any issue, but in PowerApps, it give me this error.

"The 'authType' connection parameter is null or invalid for the no-premise connection request"

 

Please help me to understand why PowerApps can't using gateway to connect Azure SQL database.

Thank you so much. Please let me know is there any workaround if I insist to use the gateway?

1 REPLY 1
timl
Super User
Super User

Hi @Coco_PowerApp 

The most likely cause of this will be because the on-premise gateway doesn't support AAD authentication to SQL Server.

If you try to connect to your Azure SQL Server through the gateway using SQL Server authentication, does that work?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (1,913)