Analyze Data in Power BI like Excel Pivot Tables
Learn how to pivot and analyze data in Power BI like you can do in Excel for fast and easy data analysis.
Kenneth A. Omorodion is a Microsoft Certified Solutions Associate (MCSA) with 12+ years of enterprise application experience in Power BI, DAX, Microsoft Fabric, Business Intelligence, data warehousing, SSRS, T-SQL, and Azure. Beyond his technical skills, Kenneth has expertise working with stakeholders’ and business leaders to help them better understand key insights. He has a great track record of successfully delivering full life cycle Business Intelligence and data solutions to organizations with measurable business impact.
- MSSQLTips Awards
- Achiever Award (75+ Tips) - 2025
- Author of the Year-2021
- Author Contender-2022/2023/2024
Power BI Bookmarks, Excel Analysis, PowerPoint Export, Teams and more
Enhance Power BI reports with bookmarks, analyzing data with Excel, exporting to PowerPoint, embedding in Microsoft Teams, and subscribing to reports.
Power BI Drill Through in the New Report User Interface
In this article, learn how to implement drill-through in Power BI reports using the new user interface.
Turn Power BI Card Visuals into Slicers
In this article, I demonstrate how you can turn your Power BI card visuals into slicers.
SQL Variables for T-SQL Code and Queries
In this article, you will learn various ways to utilize local variables while working with T-SQL code and queries.
Working with a Historical Dataset in Power BI
Learn how to identify the most current record from a historical dataset for a Power BI report in this step-by-step guide.
Automate Sending and Scheduling Emails using Power Automate
Learn how to automate the sending and scheduling of emails using Power Automate.
Power BI KPI Visual Changing the Default Output
In this article, we look at how to enhance and change the output for a Power BI KPI visual in this step-by-step example.
Build a Time Slicer by Week using DAX
In this article, we look at how to build a time slicer by week using DAX for tables that store date data types.
Automate Extraction of a SharePoint List Dataset using Power Automate
Learn how to automate the extraction of a SharePoint list dataset and create a CSV file in the SharePoint folder using Power Automate.
Extract Email Attachments and Save Files in SharePoint Folder
Learn how to use Power Automate to extract and uniquely save email attachments into a SharePoint folder.
Unpivot Repeated Data Columns in Power BI to Normalize the Data
Learn how to unpivot repeated data columns in a dataset to normalize the data so it can be used in Power BI reports and charts.
Incremental Refresh for Non-Query Folding Sources in Power BI Desktop
Learn how to implement an incremental refresh for non-query folding sources in Power BI Desktop in this step-by-step guide.
Connect Power BI Desktop to a Power BI Datamart
Learn different approaches to connecting Power BI Desktop to a Power BI Datamart along with the steps to make a proper connection.
Power BI Incremental Refresh for non-Query Folding Sources
Learn how to implement incremental refresh on a data source that does not normally support Query Folding within the Power BI Service.
Calculating Work Days in Power BI with DAX NETWORKDAYS Function
In this article, we look at calculating working days for Power BI reports using the new NETWORKDAYS function.
Dynamically Display X and Y Axis Data in Power BI
Learn how to dynamically select what should be on the X or Y axis of a Power BI chart in this step-by-step article.
Power BI Preview Data Refresh Feature
Learn about the Preview Data Feature in the Power BI service and the various things that can be done with this new feature.
Increase Power BI Canvas Size
In this article we take a look at how to make the size of a Power BI canvas larger so you can have more space to add visuals to the report.
DAX round, rounddown, floor, trunc, mround, ceiling, roundup and more
Learn ways you can use DAX to round numbers for Power BI reports using round, rounddown, floor, trunc, mround, ceiling, roundup and iso.ceiling.
DAX LOOKUPVALUE and DAX RELATED Usage in Power BI
Learn how and when to use the DAX functions RELATED and LOOKUPVALUE in Power BI to perform similar VLOOKUP capabilities in Excel.
Convert Integer Date Fields with Power Query in Power BI Reports
In this article we look at how to incrementally refresh data for Power BI when the data doesn't contain real date fields.
Combine Files in Power BI with Column Name or Column Count Changes
In this article we will look at how to combine files in Power BI when column names or the number of columns can change at any time.
Create a Power BI Grouping Report
In this article we look at creating a Power BI grouping report based on data that is not separated into different columns and how this can be done.