Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Validate Navision table structure in SQL

(0) ShareShare
ReportReport
Posted on by

I am using Navision as my ERP system and I use Tableau as my visualization tool getting all table data from Navision. as I was told when before data gets to Tableau I have data loss as Tableau does not extract all the data. I was told to check my table joins and Navision table structure. I need to validate it . I really don't know what I need to look at , as some of the values and data in Tableau does correspond to my Olap cube data when I compare the 2 platforms so what do I need to do to check / validate the Navision table structure in SQL and when I do so what must I look out for

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Validate Navision table structure in SQL

    What do you mean that Tableau does not extract all the data (or Data Loss)?

    Can you give some specific example for better understanding?

    NAV & Tableau (or any other Reporting Tool) should work fine without any issue. Have you have checked with Tableau partner (expert) and checked the reason behind this.

    Do you need any specific data from NAV SQL Tables? Let us know your query, so that we can help you to extract the exact required data from NAV tables.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans