Power BI with views on Google BigQuery

[Zzema]

When i try to get data from Views and tables on Google BigQuery use (ODBC),

That leaves the following error:
An element with the current key has already been added.

But with some another tables all ok,

Error Message:

An element with the same key has already been added.

Stack Trace:

Microsoft.Mashup.Evaluator.Interface.ErrorException: An element with the same key has already been added. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: An element with the same key has already been added. ---> System.ArgumentException: An element with the same key has already been added. ---> System.ArgumentException: An element with the same key has already been added.
   In the System.Collections.Generic.Dictionary`2.Insert (TKey key, TValue value, Boolean add)
   In Microsoft.Internal.DictionaryTracing.AddWithTracing [K, V] (IDictionary`2 dictionary, K key, V value, IEngineHost host)
   In Microsoft.Mashup.Engine1.Library.Odbc.OdbcColumnInfoCollection. <EnsureInitialized> b__0 (IOdbcConnection connection)
   In Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource. <> C__DisplayClassf. <Connect> b__e (IOdbcConnection connection) etc
  

[v-shex-msft]

Hi @Zzema,

>>An element with the same key has already been added.

Based on the error message, it seems like there are 2 or more columns with the same name in your query. Please double check these query to ensure your columns in the query has the unique name.

Regards,

XIaoxin Sheng

[Zzema · Accepted solution]

When I use another connector ( with R), thats all ok for me

[Zzema]

Anybody can help me?

Maybe this is due to the fact that the ODBC connector is not working properly?