Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
When I update a dataset on the web Power BI app I'm getting the following error:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @swasistemas
Please update your gateway to the latest version and then recreate a data source in Manage gateways . Map the dataset with new datasource to check the refresh .
Best Regards,
Community Support Team _ Ailsa Tao