Tag: Microsoft Fabric

Part 1: Fix Excel – Optimization for Financial Modeling a Modernization Guide

January 21, 2026

As financial models grow larger and more critical, performance, stability, and governance become just as important as analytical accuracy. This series provides a complete blueprint for optimizing and modernizing Excel‑based financial modeling. It begins with high‑impact Excel optimization techniques—such as Power Query transformations, Data Model loading, formula simplification, static value conversion, workbook hygiene, and .xlsb … More Part 1: Fix Excel – Optimization for Financial Modeling a Modernization Guide

Smooth Migration From Power BI Premium to Microsoft Fabric: A Step-by-Step Checklist

September 10, 2025

Planning a Microsoft Fabric migration? This step-by-step guide covers everything you need to know about migrating from Power BI Premium to Fabric, including a comprehensive Fabric migration checklist, best practices, and solutions to common migration issues. Learn how to optimize your data analytics migration, ensure proper Fabric capacity planning, and leverage robust training for a smooth transition. Discover strategies for Azure Fabric migration, Power BI migration, and effective change management to avoid pitfalls and maximize your business intelligence transformation. … More Smooth Migration From Power BI Premium to Microsoft Fabric: A Step-by-Step Checklist

Setting Up OneLake Shortcuts in Azure Data Lake Storage

September 8, 2025

This guide details configuring a OneLake shortcut in Microsoft Fabric to connect to an Azure Data Lake Storage Gen2 account protected by a Virtual Network (VNet). It outlines authentication methods, DNS setup, and firewall permissions, providing step-by-step instructions for both production and development environments. Key security considerations and troubleshooting tips are included. … More Setting Up OneLake Shortcuts in Azure Data Lake Storage