Get around the Navigation 10,000 limit - Simple query

[Anonymous]

Hello everyone!

My database on our SQL server is massive and dropped into one folder/place. When accessing it via Power BI, I run into the 10,000 limitation problem in the navigator that prevents me to reach some data.

From my researches, I understand the best way is to handle the SQL server differently and make partitions there or trim the unused data. Unfortunately, I dont have the resources and knowledge to do so. My question is: If I know exactly the name of the dataset I want to import, is there an easy SQL statement (in Advanced Option > SQL Statement) that could allow me import it even if it is beyond the 10,000 Navigator display limit?

Sorry for my lack of technical knowledge and if I am not using the correct terms. Any help on the matter will be highly appreciated. I wish you a great day!

Best,

Romain

[AntonioM · Accepted solution]

One thing you could try is import the first table on the list and then in power query advanced editor change the name to the table you want.