Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Which reporting tool is best for NAV and why?

Posted on by 25

Hi All,
Hope everyone is safe and healthy,

I would like to get your opinion on which reporting tool is best for NAV. Currently we are using Jet Services for most of the reporting, but there are many limitation. We are exploring SSRS and PowerBI. In your experience what is the best tool and why?

Thank you in advance.

Categories:
  • Suggested answer
    srttel Profile Picture
    srttel on at
    RE: Which reporting tool is best for NAV and why?

    I think there is not a simple answer to that question. I think it depends on the business need, is it more an ad-hoc reporting or something which will return periodically. You can utile the build in functionality of RDL reports or maybe even simpler a word report layout. You can take Excel add-in for getting data into Excel or use a Query object with Odata to get data into Excel to put on a SharePoint and users can simply refresh data which can be shown in pivot and graphs. Or as you said use PowerBi to get data in a nice shape. So I would evaluate the needs and users preferences.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Which reporting tool is best for NAV and why?

    Hello,

    My experience is to use Jet Reports/Analytics and Power BI. Jet for financial reporting and Power BI for Dashboards, Management Reports, Sales, other areas. If needed, I can combine external data into Power BI too.

    Power BI is easy to learn and there are an immense amount of You Tube videos and recordings on Power BI.

    Hope this helps.

    Thanks,

    Steve

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans