Dataset – Page 2 – Pardaan.com

How do I: Create a timeline in a report dataset in AL?

A question I got recently was, how can I visualize or create a dataset that can show/fetch information on a timeline? For example, I have a time-sheet and want to visualize the hours employees worked at certain projects, per day, week, month, year, and so on.…

31 July 2019

Data & Analysis

Storing Large Images In Power BI Datasets

Power BI has added the ability to set the Data Category property on measures as well as columns in tables. This means it is now possible to have the output of a DAX measure displayed as an image in a Power BI report and this in…

6 June 2019

Data & Analysis

Extracting All The M Code From A Power BI Dataset Using The DISCOVER_M_EXPRESSIONS DMV

DMVs (Dynamic Management Views) are, as the Analysis Services documentation states, “queries that return information about model objects, server operations, and server health”. They’re also available in Azure Analysis Service, Power BI and Power Pivot and are useful for a variety of reasons, for example for…

15 May 2019

Data & Analysis

Power BI And Column Order In M Queries And Dataset Tables

The order of the columns in a table in a Power BI dataset doesn’t matter all that much, especially because the Fields pane in Power BI Desktop ignores the original column order and lists the columns in a table in alphabetical order. However there are a…

28 December 2018

Data & Analysis

Calling The Power BI REST API From Microsoft Flow, Part 2: Refreshing A Dataset When a Data Source Changes

For a while now I’ve had an idea stuck in my head: wouldn’t it be cool to build a Power BI solution where a user could enter data into an Excel workbook and then, as soon as they had done so, they could see their new…

1 November 2018

Data & Analysis

New Power BI Reports from a Golden Dataset

This is a further (third) update to an article I first wrote on 18th April 2017 and then updated on 30th Jan 2018. As Power BI becomes more and more pervasive in the business world, I am being increasingly asked “How can I build 1 master…

25 June 2018

Data & Analysis

Pushing Data From Excel To Power BI Using Streaming Datasets

One Power BI feature that almost passed me by (because it was released in August while I was on holiday) was the ability to create streaming datasets in the Power BI web app and push data to them via the Power BI REST API. Bron :…

14 November 2016