If you are reading this before October 30 we would kindly like to invite you to join our Power BI workshop at this year's Direction EMEA in The Hague. Please find the session details here
In this workshop we will guide you through important parts of [..]Weiterlesen
Hierarchies are an important concept in most if not all BI-solutions. This is not different in Power BI. Hierarchies allow aggregating data on different levels - for example users may drill down into a date-hierarchy from the year-level to quarters, months [..]Weiterlesen
From time to time we get questions on how to filter NAV data when working with Power BI.
As an example let’s say we want to create a report on Item Ledger Entries in order to allow analyzing item sales and inventory value. This sort of entry table [..]Weiterlesen
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.
Handling NAV dimensions in Power BI has been a pain point since the first days of Power Pivot. Most solutions required that the dimension codes that were of relevance needed to be hard-coded as additional calculated columns to the fact table. Although [..]Weiterlesen
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
One of the great aspects of Power BI is the fact that Microsoft hears what partners and the community want. Thanks to short release cycles ideas can be implemented within short time. Power BI's support platform is a good place to start when you want [..]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
Yesterday Microsoft announced the general availability of Power BI - it will be available July 24th.
Great new features include new visualizations and additional formatting options through the browser:
One new chart type are waterfall-charts. Have [..]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