Power BI

Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the Excel Data Model and Power BI d…

Overview This concept came about while I was working on a Power BI report for the 2018 Ryder Cup. I was attempting to build out an experience to match a design that a professional web/app designer …

A special episode of the series Bad Practices in Power BI WARNING!! The following article contains images and Power BI bad practices that experienced Power BI users might find disturbing and inappropriate. Accordingly, reader discretion is advised. About the Author: Ruth Pozuelo Martinez is the MD and owner of Curbal AB, a BI consultant company …

The Power BI gateways are a way to load data from your On-Prem location into PowerBI.com. Read this article to learn how to install gateways with failover.

The Power BI team recently shipped some cool new flow options and one of them is really cool. Many times I hear of reports and dataset that fully rely on...

The next chapter in this series on Creative Aggs looks at Filtered Aggs, what they are, and how you might use them to speed up reports connected to Power BI and SSAS models. The series so far : Int…

If you’re building DAX queries using Power BI Report Builder you might notice something that looks like a new DAX function called RSCustomDaxFilter. For example, here’s a simple DAX query built fro…

Through community driven innovation and decades of enterprise BI excellence, Microsoft delivers amazing data exploration experiences and enterprise grade capabilities in Power BI. Today at Microsoft Ignite, we’re announcing the next wave of innovation that will allow organizations around the world to bring analytics to everybody through trusted, actionable new experiences.

Power BI introduces Enterprise Information Management capabilities, including data lineage and data protection, to help users manage and protect their data assets.

We are excited to announce the public preview of large models in Power BI Premium. This enables fast user interactivity over large datasets. Until now, dataset caches in Power BI Premium have been limited to 10 GB after compression. Large models remove this limitation, so dataset cache sizes are limited only by the Power BI Premium capacity size.

Power BI Free Business Intelligence and analytics tool by Microsoft for doing Stock Market Analysis and creation of various Live Dashboards.

This article will show you how to download stock price data into Power BI by using Quandl into a Power Bi Data Mode automatically.

In this tutorial, I will walk you through creating your own Power BI News Dashboard, which visualizes news about any topic that might interest you. While most of us use Power BI to analyze our own data, the ‘Get Data from Web’ functionality makes it just as easy to analyze external data. The possi...

Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform related annou…

The November update has major updates in several areas of Power BI Desktop. There’s a new, modern ribbon that aligns Power BI Desktop with Office and adds more functionality. We’re also adding a new visual, the decomposition tree, which is one of the most requested ideas on ideas.powerbi.com. AI functions integrated into Power Query allows you to take your data transformations to the next level, and of course we have incremental improvements across the entire product.

The LinkedIn Sales Navigator Analytics Integration allows teams to seamlessly view and analyze Sales Navigator usage data within Power BI to increase sales effectiveness and maximize productivity.

The ribbon in Power BI Desktop has an updated and modern experience. When you turn on the “Updated ribbon” preview feature, you will see a ribbon that looks more like the ribbon in Office products. In the updated ribbon, you have access to all the existing features that you know and love, and over time, more features will be added to the ribbon.

While the addition of +/- to matrix row headers has made navigating matrices much easier, end users will often struggle with discoverability or navigating within the levels. After watching a user D…

One of the best ways to create a quality and immersive user experience in Power BI is to build in interactive navigation. I originally started building navigation into my reports when the tabs were…

Power BI Desktop has a new ribbon! Patrick shows you 5 awesome things about it that you may not be aware of.

This is a question that has come up a few times over the past few months from several clients and so I figured it’d make a good quick blog post that can easily be pointed at to save time. I e…

Want to analyze your Power BI model without having the PBIX file? Marco Russo joins Patrick to show you how!

“Have you seen the deck.gl framework from Uber? It’s designed to show large scale big data visualization?” said one of the software engineering team. I had a look at it, and it do…

This is an overview of all the updates in the Power Platform for events that have happend in Microsoft Ignite and SQL Pass

I have written dozens of articles about row-level security so far and explained in all of them explained different methods in which you can reduce the amount of data rows that a user can see based on their roles. However, in my presentations, I still get this question that: What if I want to compare…

I have explained previously how you can use the Table.Profile Power Query function to fetch the profiling data of a table, such as minimum value, maximum value, null count etc, and use it in a report page to inform the user about the quality of the data. However, that function doesn't provide you with one…