Forum Discussion

CansuT's avatar
CansuT
Regular Visitor
1 year ago
Solved

DataSource.Error: ADBC: UnknownError while running a query with left join

I am getting this error after adding a data source that is a simple query that joins a view and a table from google bigquery. I tried adding each one of the sources (the view and the table) seperatel...
Need Help
  • vojtechsima's avatar
    vojtechsima
    1 year ago

    Hello, CansuT ,

    You can try double-checking the selection to ensure that there are no duplicate column names, so use aliases for every column. Also, if possible, wrap your request inside Value.NativeQuery (with EnableFolding=true) function that should help with ensuring it folds back to source. Alternatively, if you have non-common data types for Power BI, you can try to normalise them in the select itself.

     

    Native Query syntax:

    Value.NativeQuery(GoogleBigQuery.Database(...), SqlAsText, null, [EnableFolding = false])
vojtechsima's avatar
vojtechsima
Super User
1 year ago

Hello, CansuT ,

You can try double-checking the selection to ensure that there are no duplicate column names, so use aliases for every column. Also, if possible, wrap your request inside Value.NativeQuery (with EnableFolding=true) function that should help with ensuring it folds back to source. Alternatively, if you have non-common data types for Power BI, you can try to normalise them in the select itself.

 

Native Query syntax:

Value.NativeQuery(GoogleBigQuery.Database(...), SqlAsText, null, [EnableFolding = false])