cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Zzema
Frequent Visitor

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
  

 

1 ACCEPTED SOLUTION

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

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

 

 

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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

View solution in original post

Zzema
Frequent Visitor

Anybody can help me?

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors