Power BI

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

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 […]

Reporting on Office 365 Channels with SQL Query

Reporting on Office 365 Channels with SQL Query

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 […]

Scheduled Refresh for Power BI Reports

Scheduled Refresh for Power BI Reports

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 […]

Power BI – Refresh data every working hour

Power BI – Refresh data every working hour

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 […]

Scroll to top