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

Create a Power BI Slicer Panel

There is nothing worse than having a Power BI report that has 50% of the space taken up with slicers. When this happens, you only get half the page to visualise the actual data. But on the flip side, if you don’t have the slicers it…

29 October 2018

Data & Analysis Dynamics NAV & BC Tips & tricks

How Do I: Add and Link a Power BI Report to a page in Business Central?

Let’s get started. In Power BI Desktop, select Get Data, More: Bron : Think about IT Lees meer...

25 October 2018

Data & Analysis

Calling The Power BI REST API From Microsoft Flow, Part 1: Creating A Flow Custom Connector

Playing around with Microsoft Flow recently, I was reminded of the following blog post from a few months ago by Konstantinos Ioannou about using Flow to call the Power BI REST API to refresh a dataset: https://medium.com/@Konstantinos_Ioannou/refresh-powerbi-dataset-with-microsoft-flow-73836c727c33 I was impressed by this post when I read…

24 October 2018

Data & Analysis

Data Profiling in Power BI

Today Microsoft released the October 2018 update of Power BI Desktop. One of the fabulous new features that has been released is the ability to get a visual profile of your data in Power Query BEFORE you load the data. This new feature is typical of…

23 October 2018

Data & Analysis

Visually Appealing Power BI Reports

One thing I often get asked is “How do I create good looking Power BI Reports?”. This is a very good question and unfortunately the answer is not straight forward. I like to think of the visual appeal as the “Art” of communicating data insights. The…

19 October 2018