Last year we blogged about how to use Power Query to create reports across all companies. – see here. That approach is still valid with the new Power BI. However it has a few drawbacks that we would like to overcome with a new, better solution.
Three intensive days in Mannheim are over now. We had three sessions - a Power BI best practices session on Monday and two workshops on Tuesday and Wednesday. We really enjoyed the sessions and the energy and involvement of the participants!
As promised [..]Weiterlesen
ERP-Systems and BI solutions have it in common that columns should be as self-explanatory as possible. Power BI currently does not provide a way to create something like captions for fields. In contrast to NAV with multi language captions and SQL Server [..]Weiterlesen
You may know that Power BI lacks some sophisticated security concept that SQL Server Analysis Services or even Dynamics NAV offer. One common approach to security in Power BI is to create separate files with different degrees of detail or pre-defined [..]Weiterlesen
Have you ever thought how great it would be to use your beloved account schedules directly in Excel – without the need to re-export over and over again from NAV? Recently we developed a solution that provides this for most account schedules that can [..]Weiterlesen
When working with sales data it is often required to calculate values against a certain benchmark. If available, using budgets is certainly the best option. In many situations this is however not an option since even the best managed budgets cannot be [..]Weiterlesen
In December 2013 we wrote about the new business area in Power Pivot that we cover for Dynamics NAV customers: sales & receivables.
Since reporting on receivables requires some steps in Power Pivot and DAX that are not very intuitive and obvious, [..]Weiterlesen
NAVBI provides a feature to jump to NAV from the drillthrough-list of certain data models:
NAV 2009 RTC or NAV 2013 will open a filtered list for that document.
We extended this feature in our current NAVBI-release to allow links to any NAV-Page. [..]Weiterlesen
Wouldn't it be nice to to easily report on NAV data across companies? To use the company as just another dimension to slice the data by? Today's blog post explains how to use Power BI in combination with NAV to create reports such as this one: