Wow! It's been awhile : )

Homegrown Power BI back-up strategy with GitHub....hmmmmm..bronze architecture.....low tech but tinkering is fun : )

Have at it everyone!

Fabric Fridays #147 - Fabric Apps - Just Claude It x.com/i/broadcasts/2…

It is great to see having connectors available for different tasks in #microsoftFabric Apps. community.fabric.microsoft.com/blog/fbc_fabri…

Support Power Query Lint by subscribing! Unlock 70+ additional linting rules, TMDL linting, full API access for CI/CD, and help fund open-source tools like PQL.Assert, pql-test, and fab-test. Learn more: pqlint.com/pricing

Over the past weekend, I posted a video on testing Paginated Reports with fab-test, an open-source tool from Client First Technologies. Catch best practice issues on your desktop, in CI/CD pipelines, or with AI agents.

youtu.be/cliuMzDKreQ?si…

I've got a new article on securing API keys in Microsoft Fabric Gen2 Dataflows using Azure Key Vault.

I wish Azure Key Vault were a first-class artifact in Fabric, but until then, this approach may work for you.

red-gate.com/simple-talk/da…

We optimized a DAX measure ourselves and asked AI to do the same. Neither version was faster on every query.

Then AI refined our version: the slowest query went from 4,396 ms to 1,538 ms.

It also wrote more equivalence tests than we ever had the patience to write.
s

#dax #powerbi #ai

DAX with AI: Scenarios is complete!

The video course includes ten business scenarios: currency conversion, comparable-store sales, budget vs. forecast, shared-cost allocation, inventory from sparse snapshots, financial statements, workforce analytics, and more. The training also " lessons that are shared across several scenarios.

We announced it in September for November 30, and we're proud to release it four weeks early.

If you already purchased the video course, log in to your SQLBI account: the whole training is ready for you!

You don't need to watch it from start to finish (but you can if you want to): Pick the scenario closest to your next project, check the concepts it lists, and start there.

The details are in my blog post: sqlbi.com/blog/marco/202…
If you haven't enrolled yet, there's a launch offer on the course and on the bundle: sqlbi.com/p/dax-with-ai-…

Look what finally made it into our hands! 📚🤩

Analytics Engineering with Microsoft Fabric and Power BI is officially a real, physical book!
@ShbWatson

#MicrosoftFabric #PowerBI #AnalyticsEngineering #OReilly #MicrosoftData

New video posted: fab-test rdl for Power BI Paginated Reports.

Learn how to validate Paginated Reports for common issues, risks, and best-practice violations. Includes a walkthrough of the command, rule checks, and how to provide feedback.

youtu.be/cliuMzDKreQ

DAXBench v2 is online.
On Nov 4, Maxim Anatsko and I will go through the results and answer your questions live, here on X and on YouTube.

16:00 CET / 10:00 ET / 07:00 PT

Reply with your questions and set a reminder below.
daxbench.com

#DAX #PowerBI
u

PQL.Assert 0.8.0 is now available!

We've added 18 new functions for semantic model testing in Power BI and Analysis Services, including null/blank validation, uniqueness checks, business rules, and data freshness assertions. Learn more in the comments.
pqlint.com/pql-assert

It appears there now is an NPM package for #PowerBI Visuals which allows you to use your AI Agent to create custom visuals in your #MicrosoftFabric App! Read all the details below.
community.fabric.microsoft.com/blog/fbc_fabri…

Learn how to automate fab-test playwright report validation for Power BI using GitHub Actions and scale testing with Playwright Workspaces in Azure App Testing.

Catch broken visuals before your users do.

youtu.be/4nmxyXGAO7c

How do you write and manage skills? This article by @SQLGene and @VdVoordeR walk through an introduction about creating, managing, and using skills with agents.

Everything we build our lives on matters.

The apostles and prophets laid the foundation, but Jesus Christ is the cornerstone. Without Him, nothing stands.

Ephesians 2:20 ESV

bible.com/bible/59/eph.2…

PBIP is now fully supported by Microsoft! Learn what it is and how it opens new opportunities for change tracking, source control, and AI-assisted Power BI development. youtu.be/VzlF0BVXf44

I've spent the last week taking my time to explore Claude Dashboards. Here's an in-depth overview of what it is, how to use it, and some thoughts on pros/cons and scenarios where you might use it in this unplugged video.

youtu.be/4FI7DaEIa7A

One topic came up again and again at Community Summit North America: AI for Power BI.

If you're interested in becoming an AI-enabled Power BI developer, we've put together a free video series to help you get started.
youtube.com/playlist?list=…

If I see a blog post from @SQLGene , it's a must-read. Check out his latest article on CI/CD for Power BI development. I'm not sure pewter is the right color choice for SharePoint. I'd lean more toward a bluish-green patina. 😄 tabulareditor.com/blog/building-…