Viewing NAV SQL Data in Power BI

[petewest]

I've downloaded and installed Power BI Desktop app.
Established a connection to our SQL server and selected our NAVISION 2009 database.
PowerBI then loads 10,000 items. But when I scroll through, the 10,000 items is data only from the firs 2 NAV Companies of about 35. Is there an incombatlity with NAV 2009? from  a dat astructure standpoint?
Is there extra work I need to setup NAV or POWERBI to get POWERBI to show me all the available DB items?

Thanks in advance

Pete 

[abinashphuel]

Did you resolve this issue?

[v-huizhn-msft]

Hi @petewest,

Actually, I am confused about your issue. At first, you loaded the 10000 items successfully, and some of them lost when you scroll through? What's meaning of the operation: scroll through. Based on my understanding, when you type the server and database when you get data like shown in this video, all items sholud display. And I think there is compatibility with NAV 2009, if not, how can you get part of the items?

Best Regards,
Angelia