Power BI

Microsoft released the exam DA-100 (Analyzing Data with Microsoft Power BI) around early April 2020 which was in Beta until around the beginning of July. After the exam become out of Beta, I was wo…

I have previously explained how to generate a row-number using Power Query. That method is good for pre-calculating row-numbers in the table. However, sometimes, you want to calculate the row number in a visual, based on something dynamic. That is where DAX comes handy. Let's see how this is possible. Sample model I have a…

I often get this question: "Is it better that I create this calculation as a snapshot table in Power Query (or T-SQL, or the data source), or write DAX measures for it?" If you ever had a scenario of creating a report of snapshots, you know what I mean. "Should I have a table for…

I always try not to overload my music with orchestration and to use only those instruments that are absolutely necessaryAbel Korzeniowski This is where the analogy starts with orchestration, to whi…

This trick was demonstrated in my last session at RADACAD channel: The idea is basically to copy the entire report (pages, filters, bookmarks,…) between two different Power BI Desktop files (…

This blog post shows how you can use Power Query to clean/cluster/group text values in Power BI

Introduction This article is an update to one of my more popular blog articles and includes updates and corrections. Free Even though Microsoft took away the ability to share using the Free version of the Power BI Service, there is still a method available for sharing reports in Power BI. That featu...

Become an Insider: be one of the first to explore new Microsoft 365 features for you and your business.

Become an Insider: be one of the first to explore new Microsoft 365 features for you and your business.

In last week’s post and video we looked at how business intelligence tools have evolved, with each evolution solving one set of problems and introducing another set. The video described how s…

Not all data is created equal. One size does not fit all. In addition to collaboration and partnership between business and IT, successful data cultures have something else in common: they recogni…

LAUNCH OFFER: the books on Amazon, Apple, and Google stores have a reduced price (35% discount) until August 31, 2020. Starting September 1, 2020, the ebook

Analyze in Excel for Power BI Desktop is an external tool for Power BI Desktop that with a single click creates a new Excel PivotTable connected to the data

Learn how to use the Hot Swap connections script to change the data source location of your power bi desktop report. download the installer here.

Download the Business Ops tool to install all the External tools for Power BI desktop. Visit this page to learn about this installer.

With XMLA endpoints available in Power BI Premium and the recent release of .NET Core versions of the Analysis Services client libraries (ADOMD.NET and AMO) in public preview, you can start building modern cross-platform Power BI solutions across Windows, Linux, and macOS, and cloud-oriented environments.

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…