Forum Discussion
NAV Dynamics and Powerbi Data
Dear All, this is regarding NAV Dynamics 2016 data model. I have Vendor Ledger Report in NAV and the same report is retrieved in Powerbi Data using SQL server. But I noticed some of the columns are missing in Powerbi. THere are lot more columns in NAV data. Please let me know how is this possible and what is the way out to get all data ?
Hell0 Analytics11
Thank you for reaching out to the Microsoft Fabric Forum Community.
The SQL table you're accessing might be a view or custom query that doesn't show all columns. NAV data often comes from multiple joined tables, and some fields may be custom or hidden due to permissions, security, or data masking.
Try Connecting directly to the base table (Vendor Ledger Entry) in SQL, not a view. Review Power BI Power Query steps to avoid filtering out columns. Use NAV OData/Web Services for virtual or computed fields. NAV displays calculated or virtual fields generated at the application tier, which aren't stored in SQL Server. Check with the DBA for full read access to NAV tables.
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
1 Reply
Hell0 Analytics11
Thank you for reaching out to the Microsoft Fabric Forum Community.
The SQL table you're accessing might be a view or custom query that doesn't show all columns. NAV data often comes from multiple joined tables, and some fields may be custom or hidden due to permissions, security, or data masking.
Try Connecting directly to the base table (Vendor Ledger Entry) in SQL, not a view. Review Power BI Power Query steps to avoid filtering out columns. Use NAV OData/Web Services for virtual or computed fields. NAV displays calculated or virtual fields generated at the application tier, which aren't stored in SQL Server. Check with the DBA for full read access to NAV tables.
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.