Query – Page 6 – Pardaan.com

Passing filters to Power BI reports using the URL / query string

It was only recently that I discovered this – you can pass filters to Power BI reports by deep linking to it and adding a filter in the URL (also called query string). I am not even sure this is a feature, since it only seems…

3 January 2017

Data & Analysis

Power Query, Power BI And The “Allow Data Preview To Download In The Background” Option

Recently I was asked by a customer to do some tuning on an Excel workbook with a lot of Power Query queries in it. Although all of the data used in the queries was coming from tables in the workbook itself and the data volumes were…

16 December 2016

Dynamics NAV & BC Tips & tricks

Calling Microsoft Flow From Power Query And Power BI

Since last week’s blog post caused quite a lot of interest, here’s something similar: did you know you can trigger a Flow in Microsoft Flow and get a response from it back using Power Query/Power BI? Bron : Chris Webb's BI Blog Lees meer...

24 November 2016

Dynamics NAV & BC Tips & tricks

Understanding Let Expressions In M For Power BI And Power Query

When you start writing M code for loading data in Power Query or Power BI, one of the first things you’ll do is open up the Advanced Editor for a query you’ve already built using the UI. When you do that you’ll see a very scary…

31 May 2016

Data & Analysis

Creating M Functions From Parameterised Queries In Power BI

Query parameters are, in my opinion, one of the most important features added to Power BI recently. The official blog post describing how to use them is great (read it if you haven’t done so already) but it misses out one other cool new feature that…

24 May 2016

Dynamics NAV & BC Tips & tricks

How Do I Use CAL Query Objects to Create Nested Loops

This video demonstrates how to use CAL query objects to create nested loops in Microsoft Dynamics NAV. The demonstration covers the following steps: Bron : Think about IT Lees meer...

23 May 2016

Dynamics NAV & BC Tips & tricks

How Do I Perform a Select Distinct with Queries

This video demonstrates how to perform a select distinct with queries in Microsoft Dynamics NAV. The demonstration covers the following steps: What is a Select Distinct? Bron : Think about IT Lees meer...

13 May 2016