Unanswered

Syntax Error when reading the Azure MySQL Table

(0) Share

Report

Posted on by Saurabh5699

I have connected the Azure MySQL Database table named "order assignment" with PowerApps. However when i set the order assignment table as gallery item then it shows the below error

"Error when trying to retrieve data from the network: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Order Id FROM order_assignment LIMIT 500' at line 1"

Please help

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

VishalJhaveri 1,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Close the app. Reopen the app.
Remove the connection.
Readd the connection.
This is an internal error.

Was this reply helpful? Yes No
timl 36,725 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Saurabh5699

If you go to settings > general and increase the 'data row limit' to 2000, does that change the description of the error message?

I'm interested to see if this is bug that's related to the row limit setting.

Was this reply helpful? Yes No