Power BI

This article describes how to use and interpret the information provided by the Power BI Performance Analyzer, finding the bottlenecks in slow reports. The

I blogged about the various ways to use Measure tables and Measure Sub Folders in Power BI a few weeks back. I discussed why measure tables may be required, and also a few reasons why you may choo…

I often get asked about measure tables during my Power BI online training classes. This post will discuss the merits of measure tables versus storing your measures in the table where the data comes…

Make your plan and embrace what’s next for your business. Don’t miss Microsoft Business Applications Summit, coming to Atlanta, Georgia, June 10 – 11, 2019. We’re gearing up for an amazing 2+ days filled fresh approaches, the latest technologies, and new ways to power digital transformation at every level. Save your seat today – … Continue reading “Last chance! Register for Microsoft Business Applications Summit today”

Dimensions and Fact tables are the two essential parts of building a data model, and their relationship in the form of Star Schema is the best practice of doing the modeling. However, these are all theories until you really experience it in a real-world example. In this article, I want to put everything you learned…

Resuming from Last Week Last week’s post left off here: most BI still relies on the storage layer (SQL or its many cousins) to be the brain, and storage layers are terrible brains because they were designed for storage, not for analysis. This week, I hope to explain the following points: Storage brains are siloed

When we start using Power BI in a smaller scale, things tend to work quite smoothly even if we have built not-so-good models with not-so-great calculations. But when we start loading more and more …

When using Power BI it is interesting to see how much memory the PBIX uses. Not only that but if you are looking to move to Power BI Premium you need to understand the requirements

The default configuration for Power BI dataset is to wipe out the entire data and re-load it again. This can be a long process if you have a big dataset. In this article, I explain how you can set up an incremental refresh in Power BI, and what are the requirements for it. Incremental Refresh…

The folks over at tyGraph have put together a Power BI report for Twitter activity at the Business Application Summit. If you want to track the tweets that are happening surrounding the event, this is a great Power BI report to watch. The report is refreshed every hour (limitation of the Publish to Web […]

Hopefully, you are either enjoying the start of the Microsoft Business Applications Summit or watching all the exciting news and announcements on social media! To go along with all those othe…

Thanks for watching this week’s Power BI news roundup! Last roundup: https://guyinacu.be/roundup141repost Last tech video: https://guyinacu.be/paginatedupdate Sources Announcing New AI and Enterprise …

Take our quarterly survey to help us continue to improve Power BI.

Overview Below is an overview of some of the announcements and things that were not product specific. The first picture below is incredible in terms of seeing how big the Power Platform is. Particularly if you look at how Power BI ingests more than 20PB of data month, hosts more than 25 million data...

Performance optimization in Power BI can be complex. This posts purpose is to present simple design techniques to help prevent typical performance issues.

As of this month Power BI finally supports filtering slicers down to only show rows that have fact data. Before the only thing you could do to achieve this was...

I've had a few people ask me recently for advice on getting into business intelligence/analytics consulting. I have been in consulting for 6+ years and have worked for 3 different consulting firms, so…

The Quick Access Toolbar can be a handy shortcut menu to speed up your report writing. Read this article to learn how to customize the Quick Access Toolbar.

There was a new feature released in the June 2019 version of Power BI Desktop that I really like and I think warrants some explanation and review. The new feature allows you to pre-filter a slicer…

In this webinar I discussed designing a Power BI model to plan for either a simple or complex row level security scenario.

A quick Q&A-related tip. If you create a report in Power BI Desktop and use a Power BI service live connection: …and then you put a Q&A button on the report, clicking on the button gives the following…

I was doing some online shopping last week and saw a price slicer with a histogram to show the concentration of price points. I thought it was pretty cool, so decided to see if I could build this …

Although the conditional formatting by rules feature in Power BI was released a long time ago, one very common cause of confusion is with how to implement basic “greater than” or “less than” rules. Fo…

Did you know, in some cases, it is possible to add columns to your model to speed up the DAX used behind visuals to make them as much as 100 times faster? The PBIX helper file for this article can …

In this quick post I will walk through adding a data refresh date on a report page in Power BI.

Do you have a lot of measures in your Power BI desktop file and don't know which are not used anywhere? I'll show you how to find them.ower BI Desktop file.

I was recently tasked with creating a cross sales report. This report aims to capture the product penetration across our customer base. I created the report in Power BI, leveraging Power Query to ensu…

Time and time again when I begin talking with Excel users and ask to see what current reports they are using, they usually show me [...]

The purpose of this post is to share and describe a Power BI-based solution for analyzing SQL Server Agent job history data. SQL Server Agent has been around for many years and though increasingly my …