Power BI

Fabric GPS - Microsoft Fabric Roadmap Tracker

Full Disclosure, I work at Microsoft, but this isn't built in an official Microsoft capacity. Ok, that's handled. This is how I keep track o…

Creating functions for the like for like DAX pattern

Create a DAX model-independent user-defined function (UDF) to easily apply the like-for-like pattern to your data. Article and download: htt…

Why choose a Data Warehouse for Gold instead of a Lakehouse?

I sometimes come across architectures in Fabric where people use a data warehouse for the Gold layer, while relying on a Lakehouse for the B…

ExtractLabel: Schema-driven unstructured data extraction with Fabric AI Functions

Most enterprise data lives in free text – tickets, contracts, feedback, clinical notes, and more. It holds critical information but doesn�…

fabric-cicd v0.3.0 just shipped - check out the latest updates!

Hey fabric‑cicd community! We’ve just shipped a new fabric‑cicd release , bringing a solid mix of new capabilities, stability improvem…

A complete set of Microsoft Fabric icons for Solution Architects

Since I couldn't find any up-to-date, usable Microsoft Fabric icons in the official repositories, I spent a few hours extracting and organiz…

Prank Your Power BI Users this April Fools!

I think a good sense of humour is a greatly under-appreciated asset in the corporate world. The right joke at the right time can help everyo…

Creating functions for the like-for-like DAX pattern

This article offers a comprehensive guide to changing the like-for-like pattern into model-independent functions to enhance flexibility and …

Focus Range in Power BI | Make Analyzing easier and fun!

Need to improve your Power BI skills? https://datatraining.io/powerbidesigntransformation Need a Power BI expert? https://datatraining.io/…

Post that shows to simplify Microsoft Fabric CI/CD with a new Azure DevOps Extension

Over the past months I’ve been exploring ways to make Microsoft Fabric deployments easier to manage in CI/CD workflows. Along the way, I h…

Built-in pipeline failure alert now available

I was just checking out the schedule view of our pipeline and noticed this: https://preview.redd.it/jymgcoo9rzng1.png?width=1202&format=png&…

Built a Power BI PBIR design analyzer in VS Code – curious what people think

I keep seeing the a lot of post about "Rate my first report/dashboard." I'm currently working on the VS Code extension to help with Power BI…

I built an open source CLI tool to refresh Fabric semantic models from the terminal

I got tired of clicking through the Power BI portal just to refresh a model, so I built frefresh — an interactive terminal tool that lets …

Did you know about this? 🤩 Sharepoint Shortcuts!!

📢 Become a member: https://guyinacu.be/membership ******************* Want to take your Power BI skills to the next level? We have tra…

Power BI Desktop instability: Anyone else pushing more architecture upstream to SQL?

Has anyone else been dealing with severe reliability issues in Power BI? I can't count how many times the desktop app has crashed during dev…

A Closer Look At Preview-Only Steps In Fabric Dataflows

I have been spending a lot of time recently investigating the new performance-related features that have rolled out in Fabric Dataflows over…

Where is the training?

Every Power BI course I have ever seen is about drag and drop to create charts. But for dealing with models after they're published, everyon…

Is there ever a time where “Both” makes sense in a data model relationship?

Hello, Ive been in the process of building out a data model for my business group. I have several dimension tables with one to many relation…

First Independent dashboard

Switched to data analytics not that long ago and this is the first dashboard I've prepared fully independent as evident in the naming scheme…

My firm uses PowerBI in a unique way that I don't see mentioned often

An FP&A team rolled out a massive Power BI app with dozens of reports, showcasing a uniquely ambitious approach to enterprise BI.

First dashboard, can i get some honest criticism?

Intent: Present to leadership about software defects and status in our org. Audience can be high level directors or managers (each of which …

Microsoft Fabric–related Azure DevOps extension

https://preview.redd.it/4gk0qhvfwkng1.jpg?width=2545&format=pjpg&auto=webp&s=7445e514eb1fda8d7d0fbe1e06ea5f968ad3aca8 Excited to share a new…

What are "dumb tricks" that you would never use in prod?

A new Power BI analyst asks about clever tricks you would never use in production — educational but not production-worthy.

Is it possible to have an hybrid model with Tables Import Mode + Direct query? Want entries from users commentaries to feed live to my reports

Context: - my company has a semantic model with all tables with import mode. - we have a commentary platform and users would like to see com…

FOOTBALL PROJECT #8: New API!!

Part 8 of Curbal's football project in Power BI: connecting to a new API for live match data.

NEW! Filtering with KPI card. What do you think? 🚀

Tutorial on the new KPI card filtering feature in Power BI, enabling direct filtering from KPI visuals.

Large PBI semantic model

An organization struggles with performance on a 40GB+ Power BI dataset with billions of rows and over 1,000 monthly users.

My first end-to-end Data Analytics project: Smart City Energy Dashboard

An aspiring data analyst builds a complete Smart City Energy Dashboard as a portfolio project to go beyond just creating visualizations.

Storytelling with AI and HTML

An approach to data analysis with AI and HTML without sharing raw data - just column names. Interesting for those who want to work with AI i…

Powering secure private network streaming to Fabric with Eventstream connectors (Preview)

Fabric Eventstream connectors now support secure streaming from private networks for real-time data ingestion (preview).

Get value from what you are already paying for! Fabric vs Purview Licensing Explained

Clarification on the confusing licensing structure of Microsoft Fabric and Microsoft Purview, helping you get full value from what you alrea…

Building a Data Pipeline Using VSCode and Claude Out of Thin Air

Using VS Code, Copilot and AI to build a complete data pipeline from scratch — from raw data to a star schema — with minimal manual codi…

Monitoring tab sucks. Is there some alternative?

I'd like to do some querying on the monitoring data. Like "for a specific pipeline, what percentage of runs took more than 15 minutes to fin…

Not Pl300. Give me time and I can build it.

A Power BI user demonstrates that without PL-300 certification, you can build full-fledged reports for an entire organization using YouTube …

Notebook development outside of Fabric portal

I have been working all day trying to develop a notebook outside of the Fabric portal and it is one problem after another. I have VS code an…

Passed the DP-700 (Microsoft Fabric Data Engineer Associate) today with a score of 820

After failing twice, passed the DP-700 (Fabric Data Engineer) exam with a score of 820. Two months of focused study paid off.

Which VSCode Extension?

Confusion about which VS Code extension to use for Fabric development. The community helps in choosing the right tooling.

Power BI + Deneb visuals — very slow load time (~20s). Any optimization tips?

Power BI reports with Deneb visuals load slowly (20+ seconds). The community shares optimization tips for better performance with custom Veg…

Most Medallion Architectures in Microsoft Fabric Are Overbuilt

Most Medallion architectures (Bronze/Silver/Gold) in Fabric are unnecessarily complex. A critical look at when this approach truly adds valu…

Update to required permissions for Semantic Models in Fabric Data Agents

Changes to permissions for semantic models in Fabric Data Agents: custom rights for creators and users.

SQLBI+ updates in March 2026

SQLBI+ releases a new course on Visual Calculations in DAX, aimed at experienced DAX developers.

DAX was a hot topic in 1974

A fun piece of history: a Finnish magazine from 1974 already mentioned DAX as a hot topic — albeit in a completely different context.

I built a tool for visualising Semantic Models

ModelViz is a web tool for visualizing complex semantic models in Power BI. Useful for maintaining an overview of large data models.

Power BI Developers in Guatemala

A discussion about the state of Power BI and BI development in Guatemala and Central America. Shows that BI adoption is unevenly distributed…

I Built a Finance Business Performance Template - Feedback Welcome

A finance template for Power BI to track business performance across departments. A useful starting point for FP&A teams wanting to quickly …

A little slicer rant

Frustration about the new slicer visuals in Power BI missing basic features like multi-select. A common complaint in the Power BI community.

How does vague prompts affect Copilot? 🤔

Automating conditional formatting: A DAX measure that generates consistent pastel RGB colors based on text strings.

A clever DAX solution for automatic conditional formatting with pastel colors based on text values. Generates RGB colors without manual rule…

Real estate with Synoptic Panel by OKVIZ

Demonstrates the OKVIZ Synoptic Panel for a real estate use case with interactive floor plans in Power BI.

How to ingest Excel files (multiple sheets) from SharePoint into Fabric Lakehouse Delta tables efficiently?

Hi everyone, I’m new to Microsoft Fabric and we have a new use case at work. My manager asked me to research the best way to handle this, …