SQL Syntax Error in Power Bi while fetching Data From Diff Tables to Table - Visual

Hi hello_ ,

Based on the information you have provided, given that you are using a star schema and are having problems adding fields from different tables to the Table Vision object, here are some initial steps you can take to resolve the issue:

1. If any custom SQL queries have been written to extract data, make sure there are no syntax errors. Check that reserved keywords, quotes match, and join syntax is used correctly.
2. Keep in mind that Direct Query has some limitations. For example, many-to-many relationships may require the creation of unique keys, which can be a complex operation in Direct Query mode. Check whether the complexity of the queries generated by Direct Query may result in SQL syntax errors.
3. Ensure that the MySQL Connector/NET packages are correctly installed on the computer running the local Data Gateway, as this is required for MariaDB Connector to work properly.

In order to provide a more specific solution, if possible, please provide details of any custom SQL queries used in Power BI as well as screenshots of the relational views. With more details, we will be able to better guide you through this issue.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.