Unanswered

MySQL Connector Loading Tables but Errors when Adding to App

(0) Share

Report

Posted on by jlusk

I have a MySQL database that I would like to connect to in Power Apps.

I have an on premises gateway that is operating and connected properly. The weird part is, I am able to pull a list of tables in the database, so that shows my connection, and credentials are working fine. When I click connect at the end of the wizard, I get an error. Power Apps tells me it cannot find the table, which doesn't make sense; how did it find the list of tables in the first place?

I have attached screenshots of moving through the wizard and the error it is giving me.

And here is my connector settings:

How can I eliminate the error and access my data in Power Apps?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Since you are connecting from the cloud through a gateway I think you need to supply the fully qualified domain name (FQDN) for the server instead of just a servername.

Was this reply helpful? Yes No
jlusk 2 on at

Like (0)

Report

I just gave this a try, and I am getting the same error with the FQDN in the "Server" field as well.

The specified item '[jss.jamf].[mobile_device_details]' is not found.
inner exception: The specified item '[jss.jamf].[mobile_device_details]' is not found.
clientRequestId: 3a522e2e-07c5-402e-9a48-7a281275b1e3
Session ID: 1e78884b-75bd-4679-92ff-42a0f40d825c

Was this reply helpful? Yes No