Data & Analysis

Making Sure All Columns Appear When You Combine Data From Multiple Files In Power BI/Power Query M

Here’s a really common problem that occurs when combining data from multiple files, or indeed any type of data source, in Power BI/Power Query/Excel Get&Transform. Imagine you have a folder with two Excel files in, and each Excel file contains a table called SalesTable: Bron :…

14 December 2017

Data & Analysis

The Extension.Contents() M Function

Following on from my post last week about M functions that are only available in custom data extensions, here’s a quick explanation of one of those functions: Extension.Contents(). Basically, it allows you to access the contents of any file you include in the .mez file of…

21 November 2017

Data & Analysis Dynamics NAV & BC Tips & tricks

Selecting Dynamics NAV companies in Power BI

During my latest Power BI workshop at Directions EMEA in Madrid a question came up: How do I create a filter in my Power Bi to select different companies? Well, this is possible. Bron : Aphorisms about Microsoft Dynamics NAV Lees meer...

15 November 2017

Data & Analysis

Which M Functions Are Only Available To Custom Data Connectors?

Here’s one for all you M geeks out there. If you look at the example code for custom data connectors on the Power BI custom data connectors GitHub repo it’s clear that there are several M functions that are available in custom data connectors that aren’t…

14 November 2017

Data & Analysis

Exploring The New SSRS 2017 API In Power BI

One of the new features in Reporting Services 2017 is the new REST API. The announcement is here: https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/10/02/sql-server-2017-reporting-services-now-generally-available/ Bron : Chris Webb's BI Blog Lees meer...

25 October 2017

Data & Analysis

Creating a Date Table in Power BI

Learn how to create a calendar or date reference for your data and organize it by building a DAX date table in Power BI. Bron : ArcherPoint Lees meer...

18 October 2017

Data & Analysis

Power BI Connector for CBS Open Data / Statline

Since this post primarily concerns a Dutch data source, the rest of this post will be in Dutch. English summary below. De open data die het Centraal Bureau voor de Statistiek (CBS) via Statline (http://statline.cbs.nl) aanlevert is van onschatbare waarde voor analisten. Over diverse thema’s wordt…

5 October 2017