Category: Tips

September 18, 2019
How to Create a Collection for Workstations

This might seem like an odd blog post to write. Why not simply search for all workstations with “Windows 7%” and “Windows 10%” in your query? Once you have this…

September 11, 2019
Power BI Slicer

In this blog post, I discuss in brief, the Power BI Slicer, sharing some of my experiences while working on Enhansoft Reporting’s new Microsoft Office Power BI dashboard. The main…

September 4, 2019
Power BI Drillthrough Filters and How to Change Them

Power BI slicers can help you filter results by only showing a subset of the data, but did you know that Power BI has another method to filter data? This…

August 28, 2019
How to Create Power BI Templates

Hi everyone! As promised, in my How to Create Power BI Parameters blog post, this post shows you how to create a Power BI template. Why is a Power BI…

August 21, 2019
No Rows – What It Is and Why You Should Use It

Instead of showing empty report sections because a query produced no results, I wanted to add some text to explain the outcome. I turned to an option called, No Rows,…

August 14, 2019
How to Create Power BI Parameters

Hi everyone! This blog post is for anyone who wants to learn more about Power BI parameters. This is my first blog post for Enhansoft, so let me give you…

August 7, 2019
How Old Are Our Computers?

Let’s be frank. There are many different ways to determine the age of a computer. I’m a System Center Configuration Manager (SCCM) guy, so my go-to solution always involves SCCM…

July 24, 2019
Setting Up Security for SCCM Power BI Reports

What do I mean by, “Setting up security for SCCM Power BI reports?” First, in order to create and run Power BI reports, you need to access the SQL Server…

July 17, 2019
Why Is It Important to Use Supported SQL Server Views with SCCM Reporting?

While I was at the Midwest Management Summit at the Mall of America (MMSMOA) in May, the topic of supported SQL Server views came up. Someone mentioned an easy way…

July 10, 2019
RBA and Non-RBA Queries: When is Slower Actually Faster?

Up until now, my experience working with SCCM’s Role-Based Administration (RBA) queries showed them to be slower than the normal SQL Server views. My thoughts changed, however, when I recently…