Forum Discussion
NAV Dynamics and Powerbi 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.
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.