Not able to connect to all tables at SQL server DDBB of Dynamics NAV 2016

[GJVDA]

I am perfectly able to connect to my SQL Server and the DDBB of Dynamics Nav 2016.

The problem starts that PowerBI does not show all the available tables.

It starts alfabeticly and at the third company it doews no show more tables.

As the company y want to connect to star with the letter "H" y cant see it because it only deplys tables until the "E"

It is a DDBB with 9 diferente companies.

Really y only want to connect to 2 companies, the rest has no interest for me, but it is impossible.

[Anonymous]

@GJVDA,

Do you have permissions on these invisible tables? How about you enter SQL statement in the following highlighted textbox to connect to a table starts with "H"?



Regards,
Lydia