Power BI

I was recently brought into a report design review to see what we could do about performance of the report page load. The model was optimized and the DAX was running very quickly, but they were see…

It’s time to recap all the features and announcements we made for the Power BI service and mobile for the months of May and June.

As Power BI becomes a key tool for decision makers, more and more content is being created and published for them. Being able to easily find that content, to navigate between related items, and to share relevant content with colleagues has become critical to making these users productive when using Power BI and the Power BI Mobile apps. In the last few months the team has being working on improving navigation in the Power BI mobile apps to make it easier for our users to understand their content hierarchy and to navigate between items quickly. We’ve also made it easier to share relevant content with colleagues.

We have exciting updates this month! The updates include support for Perspectives in Personalize visuals, rectangular select for data points, dynamic formatting support to more visuals, Direct Query support for Q&A, several new AppSource visuals, and more! Check out the full blog to learn more about all the updates and enhancements.

In the July update of the Power BI Desktop we now can add external tools to the ribbon. If you install the latest versions of Tabular Editor, DAX Studio and the ALM Toolkit these will be added as t…

In the Power BI Desktop July release, the External Tools capability was released (in preview). With that 3rd party tooling integration is now possible. Tools such as ALM Toolkit, DAX Studio and Tab…

In one of my last tutorials here, we learned how to apply time-intelligence in DAX to analyze the COVID-19 data that is provided by Johns Hopkins University. The focus so far was to provide correct calculations on a daily level or to smooth them using running averages here. In today's quick tutorial, you will learn…

A while ago I wrote a blogpost on how to use Unicode characters in Power BI. In that blogpost I used a recursive Power Query function to convert Hex values to Dec values. A few weeks back one of my site visitors kindly shared his non-recursive version of Power Query function which beautifully does the … Continue reading Quick Tips: Converting Hexadecimal, Oct and Binary to Decimal in a Single Power Query Function

Video by: Reid Havens Learn how to add a different image to each button state in Power BI. Creating rich interactive buttons for the end user experience . Links/Resources: Curbal: The Ultimate Button Resource Travis John's Falcon Toggle Button

I saw this post on r/powerbi today asking about filter alerts: and it inspired me to make my first post in a while. While this method might not always meet the need for things like screenshotted re…

well, you must be wondering what is this all about. Why would someone want to create a Power BI Dataflow programmatically when you can do it very easily using Power BI service? But there are scenar…

Learn how you can take conditional drill to the NEXT LEVEL in Power BI Desktop with buttons. Patrick also shows how you can add in dynamic page navigation as well. Download Sample: https://guyinacu.be/condrillsample 📢 Become a member: https://guyinacu.be/membership ******************* Want to take your Power BI skills to the next level? We have training courses available to help you with your journey. 🎓 Guy in a Cube courses: https://guyinacu.be/courses ******************* LET'S CONNECT! ******************* -- http://twitter.com/guyinacube -- http://twitter.com/awsaxton -- http://twitter.co...

Learn how to connect an Excel document to a Power BI data model. This technique is a proven way to enable your business team to ... EXCEL!

For this blog, I want to share a technique that allows you to use tools such as Visual Studio Code to connect and make changes to Power BI models. The technique not only allows you to browse the un…

With the release of the July 2020 version of Power BI desktop we can create tools that can interreact with the Power BI Desktop model directly using an external tool....

Learn about datasets and dataflows from Reza Rad from Radacad.com. This is the monthly Power BI user groups for Milwaukee Wisconsin.

Let’s say you want to compare time series of two product launches that are six months apart. Plotting data chronologically will not be very user friendly. The best way to do it is to plot the…

I was helping a client this past week to calculate the total business hours between a start date/time and an end date/time, taking into account the working days, public holidays and non-working weekends, etc. As is often the case, I thought it would be a great blog article that I [...]Read More »

I have learnt a lot over my 50 something years in life, and one of my greatest learnings is that “it doesn’t matter how much you already know, there is still more to learn”. Hopefully this is one of the reasons you read my blog – because you want to [...]Read More »

The latest blog post explains how to use Power Query to configure and use Power BI Incremental refreshing for the Power BI Dataset

Date functions in Power BI are not always easy. And sometimes they can be a little confusing… And sometimes, a little more than just a little.. For no other reason than pure serendipity, I have dec…

Microsoft just recently announced that it is taking a “new approach to retail”. What’s the new approach you ask??? Well, it is a bit unorthodox. The new approach to retail is to have no retail. This is a bit of a sad news for me as I do a lot of work with Microsoft and have a lot of good friends who work for Microsoft and, therefore, I would much prefer that Microsoft was successful in all of its business initiatives including retail stores. However, as I put my customer hat on, this becomes a much more nuanced issue. I get very concerned when a company does not see its commitments through. I used to buy all hardware for my company from Microsoft because I wanted its store network in case I needed any hardware support. Moreover, I was purchasing largely Microsoft branded hardware as well. Recently we switched to Lenovo, because of apparent innovation paralysis that I observed with respect to the Surface devices. I am typing this on a machine that has double the specs of my old Surface Book 2 at a roughly the same cost. So, when Microsoft drops out of the retail race, I can’t help but worry about what other races Microsoft just might drop out of. I sincerely hope that Power BI and the rest of BI stack are safe as I have never seen any indications to the contrary, but the same could have been said with respect to Microsoft stores just a week ago.

[vc_row][vc_column width="1/1"][vc_single_image media="87885" media_width_percent="100"][vc_column_text]The above video walks you through how to perform looping in Power Query in order to iterate […]

A typical task when cleaning data is to extract substrings from string that follow a certain pattern. In this post I’m going to describe a method that uses the List.Accumulate function for it. …

In my previous blog, I wrote about using Tabular Editor to migrate existing (Azure) Analysis Services models to a Power BI data model. This is pretty awesome already! Once you moved your model to P…

in this video I talk about the fatal flaw of the Power BI’s Filter pane and how we can fix it with breadcrumbs. What fatal flaw am I talking about? What the heck is a breadcrumb? Well, watch …

Few handy keyboard shortcuts I use frequenctly in Power BI

This post is to support my virtual session at London Reactor on 22nd June. It will include the recording and links to the data source and the final Power BI Report. Link to Reactor Recording will go here…. Data Used and Final File Data in a single Excel File Final PBIX File Links to great Resources Guy in a Cube...

In this post we share our M365 conference presentation on the Power of a Prototype. We explore a common scenario where business users and data analysts need to work together on projects, and how a prototype can allow for greater communication and a better result.