Tips

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…

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…

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…

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…

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,…

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…

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…

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…

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…

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…