1. Model Optimization a) Remove unnecessary columns and tables b) Use correct data types: c) Use Star schemas d) Reduce cardinality e) Disable auto date/time tables. Turn this feature off in options, as it bloats the model with hidden additional data. Use a central date table instead. f) Aggregation tables g) Incremental refresh to reduce… Read more: Power BI Model Performance Optimization

In this test, we will try to see the performance improvement of using dual mode in a Power BI dimension table using a cloud database and a shared dataset, so we don’t get the performance issues experienced in the first dual mode test on a laptop. Test 1In the first test, we will use a… Read more: Testing Dual mode in Power BI and BigQuery

Dual mode can potentially speed up queries by enabling the cache in certain situations. In theory, it can speed up queries in certain situations by utilizing the cache. Microsoft’s description is here In the following example, we start with the V_FactOnline sales view. It is a large table with over 12M rows and 19 columns.… Read more: Testing Dual Mode Impact using the performance analyzer

While many people use Power BI, but never try report builder, but report builder is a handy tool for certain projects. If you have large volumes of detailed data that would take up too much space in your data model, or you find that direct queries are too slow, paginated reports can provide an alternative.… Read more: Power BI Report Builder Report Page formatting basics

DAX Expression > DAX query > Vertipaq query. Test 1: Testing the Impact of USERELATIONSHIP() in a DAX Measure Does using USERELATIONSHIP() with inactive relationships slow down a DAX measure? I’m not sure so I thought I would test it out. To test this I will create a measure using the existing between my date… Read more: Testing Power BI DAX Measures Speed with DAX Studio

I’ll start with some references: Definitive Guide to DAX Book by Marco Russo and Alberto Ferrari (the definitive experts).The Guy in the Cube video on model refresh slow: Chat GPT (I don’t know who that is!)My own testing and experience and demo using Power BI model using data from the Contoso Retail data warehouse First… Read more: Analysing the Power BI Data Model to Improve Refresh Rates with DAX Studio

Power BI can be useful for displaying and storing survey results for your organization. In this example we build some data for the results of a fictitious Airline survey, using questions taken from a real online airport survey. The data was built in Excel with a sheet for questions and a sheet for answers. You… Read more: How to Build a Survey Results Report with Power BI

The Power BI KPI demo report is a demonstration of how a typical KPI report will look. The report uses data from the fictitious Microsoft Contoso Retail Data Warehouse, which is stored in a SQL Server Database. I’ve renamed it to rn retail for demo purposes. The report is currently divided into 5 pages.

Most businesses will have sales and marketing departments as well as top-level C-Suite/director levels. They are all going to be interested in a bunch of similar reports from organization to organization. One of the most important reports, that sales and marketing teams are going to be interested in is:Who are our best customers? Top customers… Read more: How to Create a Power BI Top Customers Report

In the Contoso Retail database, we have old historical data which only goes up until the end of 2009. For our demo reports, we’d like to use more up-to-date data, so we want to add a date field to the FactOnlineSales (and FactSales) tables, so we can mimic more current reports. To add what we’ll… Read more: How to find Max Date with List.Max() in Power Query to Create a Future Date

Probably the most essential table you need in your Power BI model is a date or calendar table.You join your date table from any other table containing dates, such as your main Fact Sales table. The advantage of using a calendar table is that it contains associated fields such as Year, Month, Start of Month,… Read more: How to Build a Date Table in Power BI

An interesting dimension to report on for demographics is the age of customers. Understanding what type of customers buy what types of products can help inform our customer insight that can be used for targeting marketing offers more effectively. In the DimCustomer table of the Contoso Retail Sales DW, we have a field called: Birthdate,… Read more: How to create Customer Age Bands in Power BI using DAX

It’s very useful for users, administrators, and developers to have the data last refresh data added to Power BI reports as this helps confirm how up-to-date, the data is. Sometimes, when a Power BI file is refreshed, you will notice the data doesn’t actually refresh and there is no error, which can be confusing. This… Read more: How to Add a last refreshed date in Power BI