Forum Discussion
Power BI with views on Google BigQuery
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
When I use another connector ( with R), thats all ok for me
3 Replies
Anybody can help me?
Maybe this is due to the fact that the ODBC connector is not working properly?
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
When I use another connector ( with R), thats all ok for me
