Power BI Tips

Power BI desktop edition for reporting and visualizations.

SubCategory Tip Title Author
All Tips How to visualize multivariate relationships using Power BI Siddharth Mehta
Administration Managing Power BI Workspaces with PowerShell John Miner
Administration Publish Power BI Report to Power BI Service Eduardo Pivaral
Aggregate Aggregate Functions in Power BI including Running Total, Running Average and Max Hristo Hristov
Aggregate Calculate Relative Weeks in Power BI Aveek Das
AI Artificial Intelligence Features in Power BI - Part 1 Koen Verbeeck
Analysis Services Extend your Power BI Reports with Analysis Services 2022 Data Koen Verbeeck
Automation Power BI Report Automation Scott Murray
Azure Data Factory Refresh Power BI Dataset from Azure Data Factory - Part 1 Koen Verbeeck
Azure Data Lake Storage Connect Power BI to Azure Data Lake Gen2 Storage for Reporting Temidayo Omoniyi
Best Practices Development Best Practices for Power BI Scott Murray
Calculations Analyzing Multiple Personal Accounts using Power BI Nat Sundar
Calculations Analyzing Personal Finances using Power BI Nat Sundar
Calculations Analyzing Personal Finances with Power BI - Expenses Versus Budget Nat Sundar
Calculations Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI Nat Sundar
Calculations Design Patterns for Calculated Tables in Power BI Nat Sundar
Calculations Power BI Calculate Cumulative Total by Week Within Quarter Aveek Das
Calculations Power BI Calculations without Complex DAX using Power Query Editor Harris Amjad
Calculations Power BI use case - Developing a Personal Finance Calculator Nat Sundar
Comparison Building Reports with Power BI vs Tableau from SQL Server Data Pablo Echeverria
Comparison Compare Power BI Desktop vs. Power BI Online Scott Murray
Comparison Comparing Power BI vs Tableau as Data Visualization Tools Daniel Calbimonte
Comparison SSRS vs Power BI Scott Murray
Concatentation Combine Text Strings in Power BI Using DAX Kenneth A. Omorodion
Concatentation Concatenate Strings in Power BI Using Power Query M Language Kenneth A. Omorodion
Concatentation Power BI CONCATENATE Function: How and When to Use it Kenneth A. Omorodion
Concatentation Power BI DAX CONCATENATEX Function: How and When to Use It Kenneth A. Omorodion
Connection Strings Power BI Data Source (PBIDS) Files Scott Murray
Connections Create Power BI Connection to Azure SQL Database Rahul Mehta
Connectivity Connect to on-premises data sources with Power BI Personal Gateway Scott Murray
Connectivity How to use the Power BI Enterprise Gateway Scott Murray
Dashboard How to Build your First Power BI Dashboard Koen Verbeeck
Data Binning and Grouping Data with Power BI Scott Murray
Data Change Power BI Reports Source from Multidimensional SSAS Cube to Tabular Aseel Al-Laham
Data Combining multiple files from multiple folders in OneDrive for Business in Power BI Kenneth A. Omorodion
Data Conditional Column in Power BI Aveek Das
Data Configure Incremental Refresh for Non-Query Folding Sources in Power BI Desktop Kenneth A. Omorodion
Data Create Calendar Table Using Power Query M Language Kenneth A. Omorodion
Data Dynamic Power BI Slicer Using DAX Logic Kenneth A. Omorodion
Data Exploring the Split Columns Option in Power Query Editor for Power BI Harris Amjad
Data Get Files from SharePoint Folders in Power BI when Column Names or Column Numbers are Expected to Change Kenneth A. Omorodion
Data How to connect to a Power BI Datamart in Power BI Desktop Kenneth A. Omorodion
Data Identify the Most Current Record from a Historical Dataset for a Power BI Report Kenneth A. Omorodion
Data Incrementally Refresh Data in Power BI with Power Query for Integer Date Fields Kenneth A. Omorodion
Data Normalize Repeated Data in Power BI reports and Charts with Power Query Kenneth A. Omorodion
Data Power BI Anomaly Detection Scott Murray
Data Power BI Datasets Koen Verbeeck
Data Power BI Desktop Data Source Considerations Koen Verbeeck
Data Power BI Incremental Refresh for SQL Sources Kenneth A. Omorodion
Data Power BI Merge Queries and Append Queries Scott Murray
Data Power BI to Visualize and Profile Data for Data Quality Hadi Fadlallah
Data Power BI Workbooks Koen Verbeeck
Data Power Query Editor in Power BI for Formatting Text Columns Harris Amjad
Data Real-Time Streaming using Power BI Streaming Dataset Eduardo Pivaral
Data Refresh a Power BI Dataset using Microsoft Power Automate Bhavesh Patel
Data Using Power BI with JSON Data Sources and Files Scott Murray
Data Masking Data Masking and Unmasking Strategy for Power BI Report Testers and Business Users Haroon Ashraf
Data Model How to Create a Star Schema in Power BI Desktop Harris Amjad
Data Model Multiple Relationships on the same Table in a Power BI Data Model Harris Amjad
Data Model The Importance of a Good Data Model in Power BI Desktop Koen Verbeeck
Dataflows Understanding Power BI Dataflows and Connect to Various Data Sources Temidayo Omoniyi
Datamarts Power BI Datamart Low-Code and No-Code Functionality to Streamline Reporting Temidayo Omoniyi
Date Range Calculate Percentage Growth Over Time with Power BI Kenneth A. Omorodion
Date Range Creating a Date Dimension Table in Power BI Nat Sundar
Dates Calculate Values for the Same Fiscal Week in a Previous Fiscal Year with Power BI and DAX Kenneth A. Omorodion
Dates Calculate Working Days in Power BI Kenneth A. Omorodion
Dates Calculating Work Days for Power BI Reports using NETWORKDAYS Function Kenneth A. Omorodion
Dates Dynamically Compute Different Time Duration in Power BI Using DAX Kenneth A. Omorodion
Dates How to Create Date Dimension Tables in Power BI from Text Columns Kenneth A. Omorodion
Dates How to Manage Date Formats in the Power BI Service Kenneth A. Omorodion
Dates How to Slice Data by Fiscal Month using DAX for Power BI Reports Kenneth A. Omorodion
DAX DAX CASE Statement Functionality with IF, SWITCH and SWITCH True Jared Westover
DAX Dynamically Create Tables in Power BI with DAX Functions Kenneth A. Omorodion
DAX Getting started with DAX in Power BI Kenneth A. Omorodion
DAX New Power BI DAX Functions - RANK and ROWNUMBER Sean Lee
DAX Power BI DAX MINX and MAXX Functions for Values Across Data Set Sean Lee
DAX RELATED vs LOOKUPVALUE in DAX: How and when to use them in Power BI Kenneth A. Omorodion
DAX Simplify Data Merging in Power BI with DAX NATURALINNERJOIN Kenneth A. Omorodion
DAX Write Logical Expressions using DAX with Power BI Operators and Functions Harris Amjad
Deployment Deploy Reports from Development to Test to Production using the Power BI Deployment Pipelines Scott Murray
Design Power BI Drill Through Example Scott Murray
Design Power BI Focus Mode for Images and Data on Dashboards Scott Murray
Design Setting up Drill Through in the New Power BI Report User Interface Kenneth A. Omorodion
Design Tools Power BI Designing with Diagrams Scott Murray
Development Power BI Advanced Q & A Techniques Scott Murray
Development Power BI Embedded Example Scott Murray
Development Power BI Enterprise Content Packs Scott Murray
Development Power BI Q & A Example and Demo Scott Murray
Development Power BI Q&A Linguistic Schema Scott Murray
Development Power BI Templates, Printing and Favorites Scott Murray
Development Power BI Visual Interactions Scott Murray
Development Querying SQL Server Data with Power BI Desktop Scott Murray
Export Power BI Export and Publish to PowerPoint Scott Murray
Export Power BI Export to Excel Kenneth A. Omorodion
Features Power BI Animated Scatter and Bubble Charts Scott Murray
Features Power BI Personal Bookmarks Scott Murray
Features Power BI Smart Narrative Scott Murray
Features Power BI Tooltips Enhancements Scott Murray
Features Power BI Zoom and Focus Scott Murray
Features Using AI Insights in Power BI Eduardo Pivaral
Features What can you do with the Preview Data Feature in Power BI Service? Kenneth A. Omorodion
Filtered Power BI Filter Pane Scott Murray
Getting Started Power BI in One Hour Hadi Fadlallah
Import Analyzing Multiple Pages of UK Petition Data Using Power BI Nat Sundar
Import Implement Incremental Refresh for non-Query Folding sources in Power BI within a Datamart Kenneth A. Omorodion
Import Read and Import Data from PDF Files using Power BI Siddharth Mehta
Installation Install and configure Power BI Report Server and Power BI Desktop Siddharth Mehta
Installation Power BI - How to Download and Get Started Scott Murray
KPI How to use the Custom Power KPI Visual in Power BI Harris Amjad
M Language Advanced Mathematical Formulas using the M Language John Miner
M Language Converting and formatting numbers using the M Language John Miner
M Language Introduction to the Power BI Desktop and the M Language John Miner
M Language Rounding Numbers using the M Language John Miner
M Language Simple mathematical formulas using the M Language John Miner
M Language Text Extraction using the M Language with Power BI John Miner
Microsoft Office Integration Analyzing Power BI data with Excel Scott Murray
Navigation Power BI New Navigation Features Scott Murray
Notifications Notify Users of Power BI Dataset Changes Kenneth A. Omorodion
Notifications Power BI Features for Notifications Scott Murray
Notifications Power BI Online Alerts Scott Murray
Overview Getting Started with Power BI - Part 1 Eduardo Pivaral
Overview How to Make Power BI Reports More Useful for End Users Kenneth A. Omorodion
Overview Introduction to Power BI Report Server Scott Murray
Overview Most Overlooked Features in Power BI Amira Bedhiafi
Overview Overview of Power BI Dashboards and Visualizations in the Cortana Intelligence Suite Dattatrey Sindol
Overview Power BI Best Practices Koen Verbeeck
Overview Power BI Data Insights Scott Murray
Overview Power BI Desktop - The What, Why and How Scott Murray
Overview Power BI Desktop - What is it and how do I use it? Scott Murray
Overview Power BI for Business Intelligence Kenneth A. Omorodion
Overview Power BI: What I wish I knew when I started? Scott Murray
Performance Improve Power BI Performance with Auto Date/Time and DAX Variables Kenneth A. Omorodion
Performance Improve Power BI Performance with Horizontal Filtering Kenneth A. Omorodion
Performance Improve Power BI Performance with SQL Server Indexing Semjon Terehhov
Performance Power BI Performance Analyzer Scott Murray
Performance Power BI Performance Optimization Tips Kenneth A. Omorodion
Pivot New Power BI Explore this Data Feature: An Alternative to Excel Pivot Tables Kenneth A. Omorodion
Power BI Power BI Quick Reference Guide Hristo Hristov
Power Query Common Data Transformations in Power Query Kenneth A. Omorodion
Power Query Deep dive on Using Column from Examples in Power BI on Dates Kenneth A. Omorodion
Power Query Getting Started with Power BI and Power Query for Simple ETL - Part 2 Eduardo Pivaral
Power Query Getting Started with Power Query M Language in Excel Nai Biao Zhou
Power Query Read API Data with Power BI using Power Query Semjon Terehhov
Power Query What is Power Query? Koen Verbeeck
PowerShell Manage Power BI Dataset with PowerShell John Miner
PowerShell Manage Power BI Reports with PowerShell John Miner
Python Transform Data in Power BI with R and Python Siddharth Mehta
R Language Import data dynamically using R and Python in Power BI Desktop Gauri Mahajan
R Language Transform Data in Power BI with R and Python Siddharth Mehta
Ranking DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections Aseel Al-Laham
Ranking Rank and Sort Data Based on Multiple Columns in Power BI with DAX Kenneth A. Omorodion
Reporting Analyze UK Petition Data Using Power BI Nat Sundar
Reporting Faceted Search and Filtering in Power BI Reports Siddharth Mehta
Reporting Integrate data driven Visio diagrams in Power BI Reports Siddharth Mehta
Reporting Pinning a SQL Server Reporting Services Report to Power BI Scott Murray
Reporting Power BI Advanced Q&A Scott Murray
Reporting Power BI Dashboard vs Report vs Workbook Koen Verbeeck
Reporting Power BI Data Import and Export with Excel Scott Murray
Reporting Power BI Desktop Custom Visualization Scott Murray
Reporting Power BI Desktop Report and Panel Design Scott Murray
Reporting Power BI Desktop Web Queries to Screen Scrape Data from Websites Scott Murray
Reporting Power BI Histogram Example using DAX Junaith Haja
Reporting SQL Server Power BI Cortana Search Scott Murray
Scheduling Power BI Subscriptions Scott Murray
Scheduling Schedule, Export and Email Power BI Reports using Power Automate Kenneth A. Omorodion
Scheduling Use Power Automate to Export and Email Power BI Reports with Row Level Security Kenneth A. Omorodion
Security Power BI Row Level Security Scott Murray
Security Power BI Table Based Row Level Security Scott Murray
Security Power BI Workspace Permissions and Roles Scott Murray
Security Understanding Power BI Security Options - Row-Level, Column-Level and Object-Level Security Temidayo Omoniyi
Slicer Convert Power BI Card Visuals into Slicers to add Report Functionality Kenneth A. Omorodion
Slicer How to Sort String Date Values on a Power BI Slicer Visual Kenneth A. Omorodion
Statistics Exploring Statistics Calculations in the Power Query Editor of Power BI Harris Amjad
Statistics Scientific Calculations in Power BI - Cube, Square, Logarithms, Powers, Inverse and more Harris Amjad
Synchronization Power BI Data Gateway to Connect Data Sources in the Cloud and On-Premises Temidayo Omoniyi
Text Files Azure Text Analytics and Power BI Eduardo Pivaral
Tools Power BI Desktop External Tools and Why You Should be Using Them Kenneth A. Omorodion
Troubleshooting Power BI Native Query and Query Folding Scott Murray
Tutorials Getting Started with Microsoft Power BI Training Greg Robidoux
Tutorials Getting Started with Power BI Designer Scott Murray
Tutorials Using Parameters in Power BI Scott Murray
Tutorial Topic Author
DAX in SQL Server Tutorial and Example DAX in SQL Server Tutorial, Formulas, Functions and Examples Haroon Ashraf
DAX in SQL Server Tutorial and Example DAX in SQL Server and How it Can Be Used Haroon Ashraf
DAX in SQL Server Tutorial and Example Setup Tabular Model from SQL Server Database or Power Pivot on Analysis Server Haroon Ashraf
DAX in SQL Server Tutorial and Example Install DAX Studio for SQL Server Haroon Ashraf
DAX in SQL Server Tutorial and Example DAX in SQL Server Evaluate Statement to Retrieve Data Haroon Ashraf
DAX in SQL Server Tutorial and Example DAX in SQL Server Summarize Statement to Group Data Haroon Ashraf
DAX in SQL Server Tutorial and Example DAX in SQL Server Rollup Statement to Group and Total Data Haroon Ashraf
DAX in SQL Server Tutorial and Example DAX in SQL Server Filter Function to Filter Data Haroon Ashraf
DAX in SQL Server Tutorial and Example DAX in SQL Server AddColumns to Add New Columns to Query Results Haroon Ashraf
DAX in SQL Server Tutorial and Example Additional Learning for DAX in SQL Server Haroon Ashraf
DAX in SQL Server Tutorial and Example Get Free SQL Tips - DAX in SQL Server Tutorial and Example Haroon Ashraf
CategoryGroup Category (articles)
Analysis Services Analysis Services Administration (33)
Analysis Services Analysis Services Development (95)
Analysis Services Analysis Services Dimensions (16)
Analysis Services Analysis Services Measure Groups (7)
Analysis Services Analysis Services Performance (14)
Analysis Services Analysis Services Security (7)
Analysis Services Analysis Services Tutorials (6)
Business Intelligence Artificial Intelligence (34)
Business Intelligence Big Data (25)
Business Intelligence Data Science (3)
Business Intelligence Data Warehousing (8)
Business Intelligence Import and Export (80)
Business Intelligence R Language (11)
Business Intelligence Snowflake (28)
Cloud Amazon AWS (38)
Cloud Amazon AWS RDS (22)
Cloud Azure (154)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (15)
Cloud Azure Functions (7)
Cloud Azure SQL Database (52)
Cloud Azure SQL Managed Instance (7)
Cloud Cloud Strategy (31)
Cloud Google Cloud (10)
Cloud Analytics Apache Spark (13)
Cloud Analytics Azure Data Factory (73)
Cloud Analytics Azure Databricks (40)
Cloud Analytics Azure Integration Services (14)
Cloud Analytics Azure Synapse Analytics (43)
Cloud Analytics Microsoft Fabric (36)
Data Quality Data Cleansing for Validation (5)
Data Quality Data Quality Services (10)
Data Quality Master Data Services (41)
Database Administration Central Management Servers (10)
Database Administration Comparison Data and Objects (15)
Database Administration Database Administration (213)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Scripts (35)
Database Administration System Databases (31)
Database Configuration Compression (22)
Database Configuration Database Configurations (20)
Database Configuration Database Mail (19)
Database Configuration FILESTREAM (9)
Database Configuration Full Text Search (21)
Database Configuration In Memory OLTP (32)
Database Configuration Linked Servers (18)
Database Configuration Policy Based Management (29)
Database Configuration Recovery Models (4)
Database Configuration Resource Governor (5)
Database Configuration SQL Server Configurations (75)
Database Design Constraints (20)
Database Design Data Types (22)
Database Design Database Design (95)
Database Design Identities (17)
Database Design JOIN Tables (23)
Database Design Synonyms (5)
Database Design Table Valued Parameters (4)
Database Design Temp Tables (16)
Database Design Temporal Tables (13)
Database Design User Defined Type UDT (3)
Database Design Views (17)
Database Development Application Development (53)
Database Development Common Runtime Language (13)
Database Development Debugging (4)
Database Development DevOps (40)
Database Development Entity Framework (13)
Database Development Language Integrated Query LINQ (7)
Database Development Paging (5)
Database Development Referential Integrity (5)
Database Development Service Broker (11)
Database Development Testing (32)
Database Development XML (15)
Database Maintenance Database Console Commands DBCCs (25)
Database Maintenance Fragmentation and Index Maintenance (28)
Database Maintenance Maintenance (34)
Disaster Recovery / High Availability Availability Groups (81)
Disaster Recovery / High Availability Backup (81)
Disaster Recovery / High Availability Clustering (77)
Disaster Recovery / High Availability Database Mirroring (33)
Disaster Recovery / High Availability Disaster Recovery (23)
Disaster Recovery / High Availability High Availability (3)
Disaster Recovery / High Availability Log Shipping (18)
Disaster Recovery / High Availability Replication (78)
Disaster Recovery / High Availability Restore (42)
Functions Dates (56)
Functions Functions System (99)
Functions Functions User Defined UDF (41)
Infrastructure Contained Databases (4)
Infrastructure Containers (13)
Infrastructure Hardware (13)
Infrastructure Spatial Data Storage (9)
Infrastructure Virtualization (25)
Integration Services Admin Integration Services Administration (10)
Integration Services Admin Integration Services Best Practices (12)
Integration Services Admin Integration Services Configuration Options (22)
Integration Services Admin Integration Services Performance (12)
Integration Services Admin Integration Services Security (7)
Integration Services Admin Integration Services Upgrade (4)
Integration Services Development Data Transformation Services (6)
Integration Services Development Integration Services Analysis Services Tasks (5)
Integration Services Development Integration Services Connection Managers (5)
Integration Services Development Integration Services Control Flow Transformations (14)
Integration Services Development Integration Services Data Flow Transformations (19)
Integration Services Development Integration Services Development (118)
Integration Services Development Integration Services Error Handling (8)
Integration Services Development Integration Services Excel (14)
Integration Services Development Integration Services Execute Package Options (8)
Integration Services Development Integration Services Oracle (4)
Microsoft Office Microsoft Access Integration (8)
Microsoft Office Microsoft Excel Integration (46)
Microsoft Office Microsoft Flow (1)
Other RDBMS Other Database Platforms (16)
Other RDBMS PostgreSQL (16)
Other RDBMS SQL Server and Oracle Comparison (30)
Other RDBMS SQL Server on Linux (78)
Other RDBMS SQL Server vs Oracle vs PostgreSQL Comparison (20)
Performance Dynamic Management Views and Functions (34)
Performance Error Logs (12)
Performance Extended Events (22)
Performance Indexing (97)
Performance Locking and Blocking (44)
Performance Monitoring (110)
Performance Partitioning (17)
Performance Performance Data Warehouse (4)
Performance Performance Tuning (129)
Performance Profiler and Trace (20)
Performance Query Optimization (15)
Performance Query Plans (20)
Performance Query Store (9)
Power Platform Power Apps (20)
Power Platform Power BI (180)
Power Platform Power BI Charts (59)
Power Platform Power BI Formatting (17)
Professional Development Professional Development Branding (16)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (21)
Professional Development Professional Development Certifications (64)
Professional Development Professional Development Community (16)
Professional Development Professional Development Interview Questions BI (18)
Professional Development Professional Development Interview Questions DBA (23)
Professional Development Professional Development Interview Questions Developer (9)
Professional Development Professional Development Interviewing (40)
Professional Development Professional Development Job Search (24)
Professional Development Professional Development Management (14)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Python Python (99)
Reporting Services Admin Reporting Services Administration (21)
Reporting Services Admin Reporting Services Best Practices (6)
Reporting Services Admin Reporting Services Configuration (10)
Reporting Services Admin Reporting Services Installation (10)
Reporting Services Admin Reporting Services Migration (5)
Reporting Services Admin Reporting Services Monitoring (5)
Reporting Services Admin Reporting Services Network Load Balancing (4)
Reporting Services Admin Reporting Services Performance (6)
Reporting Services Admin Reporting Services Security (9)
Reporting Services Development Reporting Services Analysis Services (4)
Reporting Services Development Reporting Services Charts (25)
Reporting Services Development Reporting Services Data Sources (10)
Reporting Services Development Reporting Services Development (68)
Reporting Services Development Reporting Services Dynamic Reports (11)
Reporting Services Development Reporting Services Formatting (26)
Reporting Services Development Reporting Services KPI (5)
Reporting Services Development Reporting Services Overview (6)
Reporting Services Development Reporting Services Parameters (15)
Reporting Services Development Reporting Services Report Builder (9)
Security Auditing and Compliance (48)
Security Encryption (35)
Security Security (201)
Security SQL Injection (5)
Security Surface Area Configuration Manager (4)
SharePoint SharePoint (131)
SharePoint SharePoint Administration (45)
SharePoint SharePoint Configuration (27)
SharePoint Sharepoint Design (46)
SharePoint SharePoint Document Management (20)
SQL Coding Change Data Capture (16)
SQL Coding Common Table Expressions (5)
SQL Coding Dynamic SQL (7)
SQL Coding Error Handling (13)
SQL Coding Stored Procedures (32)
SQL Coding Transactions (10)
SQL Coding Triggers (44)
SQL Coding TSQL (355)
Tools Azure Data Studio (18)
Tools PowerShell (131)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (96)
Tools SQL Server Management Objects SMO (3)
Tools SQL Server Management Studio (79)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (10)
Tools Tools (35)
Versions Deprecated Features (6)
Versions Express Edition (16)
Versions Install and Uninstall (33)
Versions Licensing (4)
Versions SQL Server 2016 (96)
Versions SQL Server 2017 (44)
Versions SQL Server 2019 (20)
Versions SQL Server 2022 (21)
Versions Upgrades and Migrations (54)










get free sql tips
agree to terms