• Multiple DAX Measures Creation methods
  There are different ways we can build multiple measures at once in Power BI, and we can ask AI to build us the scripts to do the job for us. First,I will tell AI what tables I have from the publicly available Adventure Works database and then ask for generate some useful measures we can… Read more: Multiple DAX Measures Creation methods
• DAX Server Timings in DAX Studio
  We can take a measure like the one customer order measure, add it to a card visual, and use the performance analyzer to give us the DAX query, which we can paste into the performance analyzer. However, we may see different results if we use it in a matrix, so we will test that too.… Read more: DAX Server Timings in DAX Studio
• Testing DISTINCTCOUNT() in DAX
  The DISTINCTCOUNT() function can slow down reports, but if it’s required, then what are the alternatives? Test 1: Adventure Works The measures all give the same results, but which one is faster? We can test these measures by opening the above matrix for all years to give us a bit more data. The results are… Read more: Testing DISTINCTCOUNT() in DAX
• Working with Virtual Tables in DAX Measures
  Testing DAX table functions We can test the speed of measures using the performance analyzer in Power BI to see which table function used in a formula performed best. Below are the results of 10 tests per measure. SUMMARIZECOLUMNS() and SELECTCOLUMNS() are neck and neck, with the old SUMMARIZE() function finishing last. Typically, when working… Read more: Working with Virtual Tables in DAX Measures
• Power BI Model Performance Optimization
  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
• Comparison of Full Data Pipelines from Data Ingestion to Data Science
  A comparison of three types of data pipelines. Technology data flowCode data flow Technology Data flow Stage Path 1 — Microsoft / Fabric Path 2 — Snowflake + dbt (Cloud-agnostic) Path 3 — Google Cloud (GCP) Sources & Ingestion Azure Data Factory (ADF) Fabric Dataflows Gen2 Event Hubs / IoT Hub (stream) ADF Copy Activity,… Read more: Comparison of Full Data Pipelines from Data Ingestion to Data Science
• SQL Code comparisons: SQL Server, Snowflake, BigQuery
  When jumping from one project to another, it can be useful to be able to compare common code structures.I couldn’t find anything like this out there, so here it is magically created. Contents:Common Code StructuresWorking with DatesWindow FunctionsError HandlingCastingJoining TablesCTE (Common Table Expressions) Common Code Structures Topic SQL Server Snowflake BigQuery Select & Filtering SELECT… Read more: SQL Code comparisons: SQL Server, Snowflake, BigQuery
• Testing Dual mode in Power BI and BigQuery
  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
• 
  Testing Dual Mode Impact using the performance analyzer
  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
• 
  Power BI Report Builder Report Page formatting basics
  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
• 
  SQL Window Functions
  Summary 1. Aggregate Window FunctionsThese functions perform calculations across a set of table rows that are somehow related to the current row. SUM() OVER(…) – Running total or sum per partitionAVG() OVER(…) – Average per partitionCOUNT() OVER(…) – Count rows in partitionMIN() OVER(…) – Minimum value in partitionMAX() OVER(…) – Maximum value in partition 2.… Read more: SQL Window Functions
• Testing Power BI DAX Measures Speed with DAX Studio
  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

Privacy Policy