Skip to main content

Notifications

Power Automate - Using Connectors
Answered

MYSQL to PowerApps via MSSQL and Gateway

(0) ShareShare
ReportReport
Posted on by 9

I know PowerApps SQL gateway does not currently support MYSQL. I was wondering if it would be possible to connect MYSQL as a linked database to a MSSQL 2012 server. Then connect the PowerApps SQL Gateway to the MSSQL server and pull data from MYSQL through the link. I've got this most of the way setup, but the Gateway doesn't seem to want to pull from the MYSQL database. The SQL connection setup gives me "Error the tables didn't load correctly" when I put in my Windows credentials for the MSSQL server. If I put in the credentials for the local MYSQL it times out and never saves. 

 

MYSQL to MSSQL link

http://www.c-sharpcorner.com/article/create-a-linked-server-mysql-to-sql-server/

 

PowerApps SQL Gateway

https://powerapps.microsoft.com/en-us/tutorials/gateway-reference/

  • Verified answer
    ethanthekiwi Profile Picture
    ethanthekiwi 9 on at
    Re: MYSQL to PowerApps via MSSQL and Gateway

    We recently purchased Layer2 Cloud connector for a separate OneDrive related project. I'm going to try using that to get this data into a Sharepoint list or something similar to use with PowerApps.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics