Browsed by
Category: PowerShell

Two Servers, One Script, Zero Surprises: Updating Power BI Report Server Safely

Two Servers, One Script, Zero Surprises: Updating Power BI Report Server Safely

Updating Power BI Report Server directly in production can be risky and painful to roll back. This post introduces a safer workflow using a dedicated test server and an automated sync script that mirrors your reports and data sources before any upgrade. Learn how this setup prevents downtime, simplifies testing, and makes Report Server updates predictable instead of stressful.

Exporting to Excel from PowerShell without having Excel installed

Exporting to Excel from PowerShell without having Excel installed

TLDR In case you don’t have time reading my writing about PowerShell and the coding process and just would like to have a script up and running feel free to jump right to the end of the blog post where the final scripts are provided. What’s this all about? As a BI/Analytics Practitioner my most common tool for communicating data to business users is Excel. I have been working to build a modern analytics infrastructure leveraging OLAP cubes for a…

Read More Read More