Power BI Merge Queries and Append Queries
In this tip we will cover how to use merge and append in Power BI to add additional data to a dataset that can then be used in reports and visuals.
I have a passion for crafting Business Intelligence Solutions for my user groups. My experience includes almost 15 years of SQL Server involvement with the last 12 years focused specifically on Business Intelligence, SharePoint, OLAP, SSRS, and Decision Support solutions. Currently, I am a Business Intelligence Architect in the healthcare industry, and I also teach database and analytics classes for Kennesaw State University, Southern New Hampshire University, and Reinhardt University. My education includes an MBA and an undergraduate in Accounting (yes I am a reformed accountant!), both from Kennesaw State University. I enjoy every day by trying to grow my faith and spend precious time with my family. I have been happily married to my wife of over 20 years, and we have two teenagers one who we home school with the help of a University Model School, Cornerstone Prep in Acworth, GA (cornerstoneprep.org). Our other child is a Construction Management major at KSU's Southern Poly / Marietta campus. We are a soccer and Cross Country (XC) family who play, coach, and referee soccer or run for fun most every day. For several years, our family has volunteered (and played with the dogs and cats) at Etowah Valley Humane Society in Cartersville, GA.
- MSSQLTips Awards: Champion (100+tips) - 2016 | Author of the Year - 2015 | Author Contender - 2014, 2016-2021
How to Format Indicators in SSRS
Learn how to use and format indicators in a SQL Server Reporting Services report with several examples and step by step instructions.
Power BI Mobile Features
Learn how to create rich mobile interfaces using new Power BI development features.
Power BI Deployment Pipelines
In this article we look at how to deploy dashboards and reports from development to test to production using the Power BI Deployment Pipeline.
SSRS Reusable Code Blocks
In this article we look at SSRS code you can use in all of your reports to handle divide by zero issues, setting color schemes, using special characters, automatic exports and more.
Power BI Tooltips Enhancements
In this article we look at how to build custom pop-up tooltips that can be used in Power BI reports to give users more information.
Power BI Personalization
In this article we look at how to use the personalization feature for Power BI reports to match an individuals specific needs without having to duplicate the report.
Power BI Workspace Permissions and Roles
In this article learn about workspace permissions and roles when working with Power BI with a walkthrough of how to set this up.
Power BI Data Source (PBIDS) Files
Learn how to configure and use Power BI Data Source files for SQL Server, text files and web sites with step by step instructions and code samples.
Power BI: What I wish I knew when I started?
In this article we look at several tips I would like to share about Power BI that I wish I knew when I started working with Power BI.
Power BI Table Based Row Level Security
We look at how to control what data users can and cannot see in a Power BI report by utilizing a database table to control what a user can access.
Power BI Q&A Linguistic Schema
In this tip we look at how to modify the linguistics data that is used for a Power BI report.
Power BI Advanced Q&A
In this tip we look at how to use Power BI Q and A visualization to make reports and data access more intuitive for the users.
Power BI Conditional Formatting for Matrix and Table Visuals
In this article we look at different ways to create conditional formatting for a Power BI report for matrix and table visuals including color scale, rules based and field value.
Power BI Filter Pane
In this tip we look at a new feature in Power BI that allows users to filter data in Power BI reports using the new Filter Pane.
Power BI Row Level Security
In this tip we look at how to setup row level security when building Power BI reports to limit data access based on a users role.
Power BI Performance Analyzer
In this tip we look at the Power BI performance analyzer to get insight into the performance of Power BI reports.
What I wish I knew when I started working with SSAS
In this tip we cover some of the various SSAS tips that I wish I knew when I started working with SSAS. I hope you find these tips useful so you can get the most out of SQL Server Analysis Services.
SSRS: What I wish I knew when I started?
In this article Scott Murray covers some lessons learned over the years when working with SQL Server Reporting Services that he wish he knew when he started with SSRS.
Power BI Personal Bookmarks
In this tip we learn how to setup and use Power BI personal bookmarks.
Power BI Key Influencers Visual
Learn how to create a key influencer visual using Power BI and understand how this can be used.
Power BI Embedded Example
The process of embedding a Power BI object within an internal or external site has been evolving rapidly and in this tip we cover how this can be done internally and externally.
Power BI Drill Through Example
Learn how to create drill through functionality for your Power BI reports.
SSRS Report Builder with DAX Query Support
In this tip we look at how you can use DAX formulas within your SQL Server Reporting Services Report Builder reports.