Power BI

Dataflows are part of the Power BI service for a while now. More and more people are starting to benefit from it in multiple perspectives. The two most heard ones are re-use of data (and logic), but a…

Patrick shows how you can make one little change to your Power BI slicers to improve report performance. It’s bananas!

How to use Power BI Q&ampA to explore your data

Reporting/Analytics Made easy with FourMoo and Power BI

I received today what is becoming a common question: I have a customer who is using dataflows to populate a 255M row fact table, refreshing the last 2 months of data (which is working) but experiencin…

Power BI is without question the best way to report on data in SharePoint lists. The query tools available in Power Query make working with SharePoint data relatively painless, an the cached datase…

In the late 1300s and early 1400s, Fiore de'i Liberi was a knight, a diplomat, and a fencing master. He also wrote one of the most comprehensive treatises on medieval combat, his Flower of Battle, of …

This article shows how to add an additional “other” row to the selection obtained using the Top N filter in a Power BI report. Power BI offers the abili

In Power Query, there is an easy way to use Duration and get the number of days, hours, minutes and seconds from it. However, sometimes you need this calculation to be dynamic as a measure in DAX. I h…

If you ever need to create a list of numbers (either decimal or whole number), or list of dates and times, there is a very simple and useful function in DAX which helps. GenerateSeries is a simple fun…

In the previous article, I have explained what is the key influencers visual and how it works. Later the count and impact have been explained in the other Post. Initially, Key Influencers visual just …

Power BI lets you filter the visual data by a measure, such as by a measure that dynamically calculates the customer’s rank. This is convenient but there are performance implications related to the wa…

Power BI comes in three parts, Power Query, Modeling, and Visuals. Power Query is an essential part of data modeling. Learn about it from Gil Raviv's book.

Whether you want to analyze your personal “My Workspace” environment, your gateways, or all workspaces and solutions you are an admin of, you will find the Power BI Workspace Metrics solution invaluab…

Whether you want to analyze an individual solution or your full Power BI environment (all workspaces and solutions you are an admin of), you will find the Power BI Model Analyzer solution invaluable. …

I was recently talking to a potential customer about getting started in Power BI. A question they asked me was essentially “What are the difficult parts of Power BI, how do these engagements usually g…

Reporting/Analytics Made easy with FourMoo and Power BI

Reporting/Analytics Made easy with FourMoo and Power BI

In this article, I’m going to describe a technique you may wish to consider to help speed up your Power BI reports. This specific technique is designed to help speed up reports that show comm…

Introduction This is part 1 in a series of articles I plan to write over in the coming weeks regarding the use of Aggregate Tables in Analysis Services databases. Some of the techniques covered in …

Part II of this series on creative aggs looks at a specific technique I like to call Horizontal Aggs. The theory behind this particular technique is relatively straight forward, although the mechan…

#PowerBI #PowerQuery

DataChant is launching a new series that will focus on bad practices in Power BI. Instead of sharing with you tips & tricks on how to deliver best-of-breed analytics solutions in Power BI, let us try …

This post will walk through the fourth report in BlueGranite’s Power BI showcase – a series designed to highlight key capabilities and tools within the Power BI platform using real and reproducible me…

DCAC recently had a custom PowerPoint template built for us. We use PowerPoint for teaching technical concepts, delivering sales and marketing presentations, and more. One thing I love about working a…

Case Exiting news from the Microsoft Power Platform. You can now use Microsoft Flow to refresh a Power BI dataset. How does it work and why...

October Gateway release

The new workspaces in Power BI Service contain 4 roles: Admin, Member, Contributor, and Viewer. Simplifying the table below, users or groups granted an Admin role have permissions to make any type of …

Intro In the coming days I have a meeting with technical people about PowerShell and would like to start with a survey to get an idea of the knowledge about PowerShell of the people in the room. Putti…

Since last week's post proved very popular (it turns out people want video - who knew?) I thought I'd post the recording of a presentation I did earlier this year at the Power BI User Group in Welling…