Forum Discussion
NAV Dynamics and Powerbi Data
Hi Analytics11 ,
Thank you for reaching out to Microsoft Fabric Community Forum and apologies for the delay in responding.
There are a few possible reasons:
--NAV includes FlowFields which are calculated fields and don’t exist directly in the SQL database.
--SQL views or tables being used might not expose all columns available in the NAV report.
--Some custom fields or extensions in NAV may not be reflected in the underlying SQL tables.
--Permissions or data access through SQL might be restricted.
To retrieve all fields, especially FlowFields and computed columns, it's generally recommended to use OData or Web Services from NAV instead of direct SQL queries. These interfaces ensure that all visible data from NAV, including computed values, are accessible in Power BI.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
3 Replies
Hi Analytics11 ,
Thank you for reaching out to Microsoft Fabric Community Forum and apologies for the delay in responding.
There are a few possible reasons:
--NAV includes FlowFields which are calculated fields and don’t exist directly in the SQL database.
--SQL views or tables being used might not expose all columns available in the NAV report.
--Some custom fields or extensions in NAV may not be reflected in the underlying SQL tables.
--Permissions or data access through SQL might be restricted.
To retrieve all fields, especially FlowFields and computed columns, it's generally recommended to use OData or Web Services from NAV instead of direct SQL queries. These interfaces ensure that all visible data from NAV, including computed values, are accessible in Power BI.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara ReddyDear 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.
Please help me on above query
