This error occurs on the Power BI web app. It says I can't connect to an undefined dataset and it says I have a SQL syntax error.
I get this error everytime I try to refresh the dataset
The thing is, there is not syntax error on the query. The query run successfully on the MySQL console. The query with the error even changes if I try to refresh the data one more time.
This process was working fine until I choose a on-premises gateway to enable data auto-refresh and mapped to the report.
Now, every time i try to refresh the dataset I get a sql syntax error in a different query. Anyone knows what might be causing this issue? Any help would be greatly appreciated