Power BI Archives - TechyGeeksHome

How to Create a Power BI Report using Configuration Manager Data for Devices Pending a Reboot

Creating a query for Power BI from the System Center Configuration Manager (SCCM) database to identify devices pending a reboot involves several steps. Below is a detailed approach, including the SQL query to extract the relevant data. 1. Understand the SCCM Database Structure The SCCM database contains several tables and views. Key tables/views for this query include: 2. Query to …

System Center / Microsoft

Reporting on Office 365 Channels with SQL Query

by Andrew Armstrong - Leave a Comment

If you’re responsible for managing Office 365 deployments within your organization, having visibility into which channels your devices are using is crucial for effective administration and maintenance. With the help of SQL queries, you can extract pertinent information from Configuration Manager data, allowing you to generate insightful reports or visualize data using tools like Power BI. In this blog post, …

Microsoft / Guide

Scheduled Refresh for Power BI Reports

by Andrew Armstrong - Leave a Comment

Power BI is a powerful business analytics service that provides rich interactive visualizations, reports, and dashboards to help organizations gain insights from their data. One of the key features of Power BI is the ability to create reports that automatically refresh on a scheduled basis. In this blog post, we will discuss how to run scheduled refresh for Power BI …

Microsoft / Guide

How to Automatically Remove Spotify using SCCM

by Andrew Armstrong - 2 Comments.

How to automatically uninstall Spotify installations using System Center Configuration Manager (SCCM).

Microsoft / Guide

Power BI – Refresh data every working hour

by Andrew Armstrong - Leave a Comment

If you are using Power BI and a personal gateway, you may want to ensure that your report data is updated regularly during working hours. Power BI is an excellent tool that can be utilised in many ways including the power bi jira combination as an effective solution for specialists dealing with numerous administrative tasks. To learn more about Power BI and …