An entry with the same key already exists error

[amiquel]

Im importing diferente tables from a datamart, and i get this error when i try to import the fact table. Why is this?

Thanks,

[Greg_Deckler]

Typically that means that you have two columns with the same name and you need them to have distinct names within the query context.

[amiquel]

In this i dont have fields with the same name. I deleted all the other tables and i tried to import the fact table, and threw the same error. Any ideas?

[Greg_Deckler]

Probably a lot of work, but I generally troubleshoot stuff like this by importing one column, do I get the issue? No, import half the columns, do I get the issue? Yes, import half as many columns again...and so on and so forth. Bisection troubleshooting method.

[amiquel]

Sorry, Im new in this tool. How can i import just a few columns? When i tried to import the tabel i get this error:

Expression.Error: La clave no coincidió con ninguna fila de la tabla.
Detalles:
Key=Record
Table=Table

And i cant select just a few columns...

thanls,

[amiquel]

The table had 300.000 rows, and that was the proble, i tried importing just 50.000 and it was ok.

How many rows does power BI support?

Thanks.

[andre]

a 64 bit version will support as much as how much you can fit in your RAM, typically millions of rows.  Do you have any relationships for your fact table?  Can you start a brand new model and just import that one fact table and see what happens?

[curth]

What kind of database server is this?

[amiquel]

I have MySql. Could it be the problem?

[andre]

it should not matter what your back end is.  I would try to create a new model with just that table in it and see what happens.