Problem with MySql connector to Azure server

[isancho]

Hello good, I have been using the mysql connector without problems to access my database, both on a local server and on an Accenture server, the problem comes when I take the database to the Azure server, it gives me the following Failed with the "mysql" connector that has powerapps:

"An error occurred while reading data from the provider: 'The restrictions cannot be successful. One or more rows contain values ​​that violate the NON-NULL, UNIQUE or FOREIGN-KEY restrictions.' Internal exception: An error occurred read data from the provider: "The restrictions cannot be successful. One or more rows of values ​​that violate the NO-NULL, UNIQUE or FOREIGN-KEY restrictions ". ClientRequestId: d1a9c2d3-fdf4-4bae-9bd1-cd9368a18489"

The sql file that I launched to create the database is always the same, I do not understand because if the other two servers have no problems with this one, there is something else, if the database is empty, that is, without tables or nothing, the connection if I can make it, but as soon as I launch the sql to create and try to see the tables in powerapps, I fail.

[v-xida-msft]

HI @isancho ,

Could you please share a bit more about the data structure of your SQL Table?

Based on the issue that you mentioned, it seems that there is something issue with the restrictions (NO-NULL, UNIQUE or FOREIGN-KEY) you defined in your SQL Table.

Please check if there are some records whose corresponding column value has violated the NO-NULL, UNIQUE or FOREIGN-KEY restrictions defined in your SQL Table.

In addition, there are some known limits when using SQL Connector in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/connectors/sql/

Best regards,

[isancho]

Dear All, Thank you so much for your answers

First of all, the language I have used for the database is mysql no sql, that´s why I have used the mysql connector that have powerapps

I don´t understand why in this case I have the problem with the restrictions if I dont have it with the other servers I have used, the only problem appears when I take my database to Azure. Because if the restrictions are wrong, this problems must be also with the other two servers

The code I have used to create the database has been always the same and I have never modified it, so how it´s posible that the problem appears only when I take my database to Azure and I try to conect powerapps with the database I have in Azure if I always use mysql conector?

Thanks & Best Regards

[v-xida-msft]

Hi @isancho ,

Do you mean that you create a connection to your mysql database hosted in Azure using MySQL connector?

Based on the issue that you mentioned, I think this issue is related to the MySQL Connector. Currently, within PowerApps, the MySQL Connector could only be used to connect to On-Premises MySQL Server, it could not be used to connect to MySQL Server hosted in Azure.

Please check the following article for more details:

https://docs.microsoft.com/en-us/connectors/mysql/

If you would like this feature to be added in PowerApps, please consider submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

As an alternative solution, you could consider add a VM within your Azure, and then wthin the VM instance, install your MySQL Server, then you could connect to the MySQL Server hosted in the VM (in your Azure) from your app using MySQL Connector.

Best regards,

[JohnShine]

Has this limitation been resolved, you sell Azure hosted MYSQL so I would expect PowerApp to be able to work with the connection.