Power BI

There are two themes for this month’s Power BI Desktop update. The first is a focus on some of your major asks including multi-selecting data points across multiple charts and syncing slicer values ac…

We’ve all met them: the users whose idea of a ‘report’ is a large table of data dumped into Excel. However many beautiful data visualisations they see, however many times you try to convince them o…

And another one bites the dust... this month the Power BI team have only delivered the #1 most requested feature on the Power BI Ideas forum. Synced slice

Surfs Up A long time ago a peer in Financial Planning and Analysis said "Financial Planning starts in the home.” I modified the statement to “Data analyti

There has not been a lot happening in the past few weeks, but I am delighted to have another blog post with the latest Power BI updates. Power BI – February Update As I do every month I will go thr…

In this post I am going to demonstrate how to create a Dynamic TopN slicer using a What-If Parameter. This will allow your user to simply use the Slicer/Slider to view the TopN values and as a bonu…

I have done a few videos on YouTube explaining how to join tables using Power Query or DAX. If you follow the channel, you probably have seen the videos and this blog post will serve as a compilation of all the material. However, if you are new, this will serve as a tutorial for beginners on how t...

Troubleshooting a Power BI Dataset Refresh Error I investigated a Power BI Dataset Refresh issue tonight that had been successfully refreshing until earlier in the day, when it began to fail consistently. The report solution is an extension of the Power BI Bing News Solution Template (which is really impressive!). In the Power BI tenant,...

Late last year as part of the December Power BI Desktop release, we launched a new connector for data.world – aka the social network for data nerds. data.world is a platform where people can find, use, share and collaborate with a vast array of high-quality open data.

Announcing the winner of the 2017 Power BI “Year in Review” data storytelling contest. With 37 entries and a close race, we’re happy to announce David Eldersveld, a data visualization and analytics consultant at BlueGranite and author of the DataVeld blog, too home the top prize for his story North Korea – “Handle With Care”. Read the full post to see David’s excellent entry and more.

Bertrand d’Arbonneau added a new feature in the last version (v 1.09) of Power Pivot Utilities, which allows the visualization of Dependents and Prece

The results of last month’s Power BI Global Hackathon are in! The Hackathon was facilitated by our our PUG here in Portland with the goal of welcoming global contenders in subsequent contest. Five …

Over the past few weeks, I’ve been spending a lot of time discussing Power BI Report Server with my customers and colleagues. One of the most common questions I’m asked is: What are the differences between “Power BI Desktop” and “Power BI Desktop optimized for Power BI Report Server”? In this blog post,...

When we are doing any kind of solution our main focus is to satisfy our end users and to deliver a very user friendly solution in the end...

I am really excited to show you in this blog post how to use Active Directory (AD) Security groups to make Dynamic Row Level Security (DRLS) easy and simple. In the past when using DRLS there had t…

Learn how you can use the Power BI training offered by Pragmatic Works to prepare for the 70-778 certification exam for Power BI.

A couple of years ago when Power BI Desktop was released I did a blog post on How to: Build a SQL Server Dashboard with Power BI Desktop. Today I will be presenting to the local MN SQL Server…

I’m excited to announce the ability to automatically install apps for end users, making it easier to distribute the right apps to the right set of people. Apps deliver data that your end users need…

In my last post, I explored a less-than-ideal way to approach the lack of object-level security in Power BI. That workaround used DAX to mask sensitive values for certain users. Since that method is not a secure one, I’ll look at an alternative that involves reshaping the data to make use of Power BI’s existing…

In the past when I was answering questions I always had to get a screenshot, save it into an image and then upload the image. That was a real pain in the ……! I have to give full credit to fellow MV…

Using dynamic row-level security, Power BI report authors can provide filtered views of data without numerous security roles to manage.

Last week, I had published a Power BI contest where you had to solve some clues to unlock a hidden tab. The underlying technique was inspired from a community post but I used a totally different ap…

Mastering Power BI will likely be published by the end of March or April at the latest. Amazon, Packt, and other sites may soon be updated to reflect this change. Table of Contents The following ch…