OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Incorrect syntax near ')'..

[Anonymous]

Hello all,

I tried connecting the AS db to Power BI through Direct Query mode and I face this issue below:

I checked the database name and they were found correct, also I have the permission to access the data. It would be great if you guys reply, whether you faced this issue. 

Thanks! 🙂  

[Watsky]

Did you happen to use a native query when you connected to your data source?