Data & Analysis

Dynamic Column Selection In Custom Columns In Power BI/Power Query/M

When you’re writing an M expression for a custom column in Power BI or Power Query it’s easy to reference the values in other columns. A slightly more difficult question, however, is how can you reference column values dynamically? For example, given the following input table:…

18 March 2016

Data & Analysis

Microsoft Power BI – Part – I

Microsoft Power BI brings your data to life, transforming your company’s data into rich visuals for you to collect and organize so you can focus on what matters to you. Bron : Ashwini Tripathi Lees meer...

15 March 2016

Data & Analysis

A Quick Look At Azure Data Catalog

I’ve been meaning to look at Azure Data Catalog for a long time but somehow never got round to it until now. I’m not sure why – perhaps it’s because there’s so much other cool stuff happening in the world of Power BI and Azure, and…

11 March 2016

Data & Analysis

Working With CSV Files That Contain Rogue Line Breaks In Power Query And Power BI

CSV files often contain text fields, and text fields often contain line breaks that shouldn’t be there (especially if the text is entered by end users). For example, here is are the contents of a simple CSV file that should contain three fields(Product, Comment and Sales)…

22 February 2016

Data & Analysis

Rendering Text On A Map With Power Query And Power Map

They say a good magician never reveals his tricks. Luckily, I’m a rubbish magician and so (at the request of Jason Thomas and David Eldersveld) I can reveal the secret behind one of the magic tricks I used in my sessions at SQLBits and the PASS…

15 February 2016

Data & Analysis

Power BI is a Global BI Leader

One of the great new features in Microsoft Dynamics NAV 2016 is natively working with Power BI. You can use this feature very easy using OData web service in NAV and copying this URL to Power BI when you try to use it. You just need…

11 February 2016

Data & Analysis

Analysing Power BI DMV Queries In Power BI Desktop

Experienced Analysis Services and Power Pivot developers will know all the interesting things you can learn from DMV queries. For example, in this blog post Kasper de Jonge shows how to use a DMV to find out which columns are using the most memory in a…

10 February 2016