Power BI

In my last tutorial here, you learned how to import COVID-19 confirmed and death cases from Johns Hopkins dataset to build your own Power BI dashboard using Power Query. In this tutorial, we will go quickly through the DAX measures that will help you gain better analytics capabilities using Power BI time intelligence. To follow …

Announcing – Copy a Visual as an Image in Power BI Service

I recently on some internal email by the developers where they mentioned something, offhand, what I think is amazing :). It will allow you to add measures by copy and...

Today I discovered a way to easily copy all queries (including the groups) from a PBIX file to Excel without entering the power query editor in Excel. In my case I needed to copy the data returned …

Time series forecasting in PowerBI. (An Almost) Comprehensive Guide

ALM Toolkit is one of those must have tools for PowerBI. Learn about this tool from Christian Wade and how the ALM Toolkit aids your Power BI Development.

I have seen so many people have different ways of using Power BI as an analytic and reporting tool. They all have their own way of designing dashboards/reports, naming objects, create calculations,…

This is the second post of a series covering best practice guide for Power BI users. If you have not read the previous post, you can check using below link. In this post, I’m mainly focusing on nam…

In this blogpost I’m going to talk about how to design an effective Power BI report. While report designing is a highly subjective area, I will try to make it more generalize as much as possi…

Do you want to learn how to contain your ETL within Power BI? In a recent webinar with Consultant Nick Lee you’ll learn some tips and tricks when it comes to setting up your ETL pro…

Sometimes in the grind of data wrangling, slinging some DAX code, and laying down some sweet charts, graphs, and tables, we can forget that the softer “non-data stuff” can really drive usability and adoption. It’s very easy for us (the report authors) to underestimate how much better we understand our reports than our users do. We just implicitly “get” the meaning of each metric, and are aware of each interactive capability. It’s important for us authors to try to step outside our own knowledge and history in order to see things from the naïve user perspective. A good data visualization is ...

I recently on some internal email by the developers where they mentioned something, offhand, what I think is amazing :). It will allow you to add measures by copy and...

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of

There are three main points of advantages in using aggregations (what we can get from the official documentation): Better query performance over big dataOptimized data refreshBalanced architectures…

Power BI incremental refresh is a very powerful feature and now it’s available in Shared capacity (not just Premium) everyone can use it. It’s designed for scenarios where you have a da…

Theory If you just want to see read/write XMLA endpoints in action, skip to the Practice session. Otherwise, if you never heard of it or just wanna read up on the specifics, keep reading here and we'll get there eventually Preview Feature To start with a side-note disclaimer: XMLA Endpoint If ...

The Accounting and Finance community deals with high volumes of sensitive and confidential information. As such, reporting which enables everyone within an organisation to see only the information they are authorised to see is of importance to this community. Leveraging the Row Level Security and ...

If you have ever wanted to refresh selected or multiple tables in Power BI desktop, but not ALL the tables this blog post explains how to achieve this.

If you are using a date slicer in your Power BI report, a relative date slicer is one of the options to consider for sure. This is a very simple type of slicer to use, but very effective in terms of options that it provides for the user to slice and dice the data. Let's…

In my last tutorial here, you learned how to apply basic time intelligence in Power BI to build your own COVID-19 dashboard following the initial tutorial, in which we imported confirmed and death cases from Johns Hopkins dataset using Power Query. In this tutorial, we will continue our journey and learn how to apply a …

I’ve been testing incremental refresh for more than half a year in an enterprise environment and I’d like to share my experience with this feature. You can read a full description of Power BI incremental refresh here. If you have not worked with incremental refresh yet, I recommend that you read the...

From 2019 – December version, Power BI allows to export existing themes as theme files. With this, rather than creating a theme file from the scratch, we can export existing theme and modify …

Using Calculation Groups to show currency formatting strings which will display the currency sign in Power BI or Analysis Services

You asked for the sessions, and we’ve got them for you! View over 50 great sessions from the Microsoft Business Applications Summit 2020. Here’s the Power Platform sessions quick reference blog

We are excited to announced general availability (GA) of shared and certified datasets in Power BI.