Whitepaper – Power BI Varianten (Cloud, hybrid, On-Premise)
Whitepaper – Power BI Varianten (Cloud, hybrid, On-Premise)
Unternehmen, die Power BI einführen, stehen häufig vor der Frage, ob Power BI als Cloud-Service (powerbi.com) verwendet werden soll, oder ob eine lokale (On-Premise) Installation vorzuziehen ist. Diese beiden Varianten sowie eine Hybrid-Varianten (Nutzung [..]Read More
Directions EMEA 2017 in Madrid
Directions EMEA 2017 in Madrid
This year navida was again invited to host sessions at Directions EMEA conference. Directions EMEA was hold in beautiful Madrid this year. In our first session on Wednesday, October 4th, we talked about our experiences and about Do's and Don'ts in [..]Read More
Account schedule hierarchies in Power BI
Account schedule hierarchies in Power BI
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 [..]Read More
Filtering NAV’s OData with Power BI
Filtering NAV’s OData with Power BI
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 [..]Read More
Power BI with multiple companies in NAV – repeatable approach
Power BI with multiple companies in NAV – repeatable…
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. The [..]Read More
Plug and Play solution for NAV Dimensions in Power BI
Plug and Play solution for NAV Dimensions in Power…
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 [..]Read More
Power BI Sessions @ Directions EMEA
Power BI Sessions @ Directions EMEA
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 [..]Read More
Open Dynamics NAV page directly from Power BI
Open Dynamics NAV page directly from Power BI
In April 2014 we blogged about a new feature of our Excel-addin NAVBI that allows opening NAV pages from any Pivot table. Due to a limitation of pivot tables, the link had to be added to the drill-through (details) sheet. We are very pleased that the [..]Read More