Power BI

External Article

How to use the Power BI Desktop Bridge to automate tasks in Power BI Desktop and GitHub Copilot

  • Article

Microsoft continues to blur the line between low-code visual tools and code-first development for Power BI, recently launching a set of official Fabric AI Skills and the Power BI Desktop Bridge preview feature. Together, they allow AI agents to install command-line tools, inspect a running Power BI Desktop process, update a report or model in the Power BI project format (PBIP), and reload the report so that changes appear immediately.

2026-08-28

Technical Article

Never ship a broken semantic model again: how to build automated tests in Power BI with user-defined functions

  • Article

User-defined functions (UDFs) in Power BI let you build reusable, automated tests for your semantic models — so you catch broken measures, duplicate rows, and faulty relationships before they reach your reports. This article walks through how to use UDFs alongside PQL.Assert to standardize testing across your team, and how to automate those tests with Power Automate or a Fabric Notebook.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-06-29

SQLServerCentral Article

What Power BI DirectQuery does to your SQL Server (and how to fix it)

  • Article

Power BI DirectQuery can quietly overwhelm your SQL Server. Unlike Import mode, DirectQuery sends live T-SQL for every visual interaction, multiplying queries and placing heavy analytical load on the database. This article explains how to identify the worst offending DirectQuery queries, why the generated SQL is often inefficient, and what you can do from the database side, including indexing, Query Store, and reporting views, to improve performance. It also outlines practical changes on the Power BI side and when DirectQuery is simply the wrong architectural choice.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(6)

You rated this post out of 5. Change rating

2026-04-20

5,174 reads

Technical Article

Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()

  • Stairway Step

Business Intelligence Architect, Data Analyst, CPA, and author Bill Pearson introduces a subseries surrounding the DAX Text Functions, including LEFT(), RIGHT(), MID(), REPLACE(), and SUBSTITUTE() and breaks out the operational groups of functions involved. Next, he introduces the “Extract and Modify” group of text functions as the focus of this Level. Finally, he identifies and examines each functional member of the “Extract and Modify

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-02-04

1,659 reads

Blogs

A New Word: Dorgone

By

dorgone– adj. wondering if you could slip away from an event or group conversation...

Tell It Once: Setting Up Claude With Skills and MCP Servers

By

Many of us use AI the same way every single day. Open a tab....

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

By

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

Read the latest Blogs

Forums

Hyperscale Replicas II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas II

Practical Reporting Queries with CROSS APPLY (Part 3)

By Imran2629

Comments posted to this topic are about the item Practical Reporting Queries with CROSS...

Your Favorite Quotes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Your Favorite Quotes

Visit the forum

Question of the Day

Hyperscale Replicas II

How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?

See possible answers