Power BI

So this happened yesterday – one of my customers pinged me and asked whether it is possible to set customized data alerts for her end users? I froze for a second, knowing that such a functionality …

Introduction If you are a mechanical engineer or mechanical engineering student, then you can skip past this introduction and the background information and just get right to the solution. I know this from my own experience in earning my Mechanical Engineering degree at Ohio Northern University. I h...

A few months ago, Power BI expanded the capabilities of Themes to include more than colors. You can now change the Format and even configure Analytics such as forecasting. In a previous post, I loo…

PowerBI has the ability to mashup data from different sources; this may introduce problems when joining or matching data between systems. I was able to get around this issue by leveraging an R script from an article in the community. As a consultant there is a rule that if you use something from the community, you need to give back and particularly if you use it twice, you have to write a blog post. This is such a post.

As advanced analytical techniques become more popular, companies are looking to hire people to find answers in their data. What kind of answers? Predicting the future, determining what factors mak…

This measure computes the aggregation of the specified value but inverts a slicer selection on the specified category. In other words, instead of returning the SUM, COUNT or other aggregation of what is selected in a slicer, this measure computes the inverse of that selection such that selected item...

Power BI and Azure Data Lake Store outputs are now supported in Visual Studio tools. Previously users can only create or view jobs with these types of outputs in the Azure portal. Now all these actions can also be performed in Visual Studio tools. With this capability, developers can enjoy the same powerful developer experience...

We are excited to announce that we have just released the January update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release:…

We’re excited to announce we’re rolling out report sharing to users worldwide. Now reports and dashboards have the same sharing features, making it even easier for Power BI users to collaborate with their teams and partners. These changes make it possible for users to share reports directly, add reports to their favorites, find it in Shared with me, and works great with the recently released Azure B2B sharing features for external partners

Many people will say that 2017 was the year of the Bitcoin. Whether you have invested in cryptocurrency or not, here is your best Power BI tool to play with different What-If scenarios. Select the initial invested amount, set the buy and sell dates, and enter the time machine. You can also review al...

Design Mode in Power BI Desktop To better support large Power BI datasets with many tables, DAX measures, and potentially complex M query expressions, it seems that a ‘design mode’ expe…

One of the challenges I had working with a client recently was around how to work with ranges/bands of numbers in Power BI. I thought I’d share the approach I took. I was looking to deal with this in the data preparation layer using Edit Queries as this is the most appropriate place to get my data ...

If you have followed some of my recent posts, you may have noticed that I have focused a lot on the HTML Viewer custom visual for Power BI. As I have started using it, I have enjoyed the versatilit…

Microsoft released Power BI exam 70-778 (Analyzing and Visualizing Data with Microsoft Power BI) around July 2017 as a beta exam and in January 2018 the exam was removed from beta. This week, I decided to do the exam and it was a great experience as I have been working with Power BI since it ... Read morePower BI Exam – 70-778 Analyzing and Visualizing Data with Microsoft Power BI

Practice test questions for 70-778 - Analyzing and Visualizing Data with Power BI. This exam is part of the Microsoft Certified Solutions Associate (MCSA).

For everyone who likes to keep up with the latest news and changes to Office 365, and stay on top of what’s being worked on, the Office 365 Roadmap is a really useful tool. This is Microsoft&…

Trailing twelve months (TTM) Power BI. Show each month and total trailing twelve months (TTM), the total for prior TTM, AND the variance in one table.

Power BI Report Server Monitoring Let’s say you’ve recently deployed the Power BI Report Server and you want to get started with some monitoring to answer common questions such as: Who …

Hi, I try to leverage a SSRS report as a data source to Power BI via the Data Feed / OData functionality. So I open the report, export it as a Data Feed, take the URL from the feed and try to use it as OData source in Power BI. I use Windows authentication. However I receive an error like: Deta...

A customer of mine is in the midst of a proof of concept using SQL Server and Power BI. During the POC, all the modeling was done in Power BI Desktop. Now that the POC is coming to the next phase, …

There still seems to be a bit of confusion about Power BI licensing since the changes made back in May 2017. I get a number of questions about embedding options, were a client wants to share report…

Data Ambiguity…The Silent Report Killer Hello P3 Nation, I’m excited to be back and writing a technical post again...it’s been too LONG! Today I want to ta

Every month Power BI gets an update that adds a nice handful of new features. Here at P3 we ALL get excited for new Power BI features!

Recently I came across this great blog post from Dustin Ryan on how to convert a Power BI Desktop File from Import to Live: I’ve been using another technique that is very simple and don’t req…