BenMakesDataEasy

Follower of Jesus | #SQLServer | Python | Machine Learning | Building an app for #PowerBI | | Helping make data easier to work with

[BenMakesDataEasy @data_ben]

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!

[John Kerski @JKerski]

pql-test now supports the Open Data Contract Standard (ODCS). It translates data contracts into PQL.Assert tests to validate semantic model freshness, schema changes, & calculation integrity. As AI agents become analytics consumers, data contracts matter.
https://t.co/eXXLoMOrwy

[𝘎𝘪𝘭𝘣𝘦𝘳𝘵 #FourMoo @GilbertQue]

Using the new #MicrosoftFabric Pipeline activities means it is now possible to use Fabric APIs without having to code the APIs and then run other Business APIs all within a single pipeline. https://t.co/DlCcmn29B2

[Kurt Buhler @kurtbuhler]

Claude dashboards are now GA as Claude data. Definitely some interesting and welcome improvements:

- certified metrics definitions: while still far from semantic modelling it's good to see steps toward metrics
- query caching
- integration with design systems
- version control

[John Kerski @JKerski]

Great discussion Shabnam Watson, Khaled Chowdhury, Leon Gordon, Nikola Ilic, Michael Carlo, and Reza Rad on the future of Power BI. Best takeaway: get involved in the community. 👇

https://t.co/SaNHdyG4N5

[KratosBI @KratosBi]

Fabric Fridays #147 - Fabric Apps - Just Claude It https://t.co/9Ng1Qb7uTI

[𝘎𝘪𝘭𝘣𝘦𝘳𝘵 #FourMoo @GilbertQue]

It is great to see having connectors available for different tasks in #microsoftFabric Apps. https://t.co/QcbN9Jo2Jv

[John Kerski @JKerski]

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: https://t.co/4q6AWPPPrs

[John Kerski @JKerski]

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.

https://t.co/opzQjUCm9I

[John Kerski @JKerski]

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.

https://t.co/CEbAlY1EMX

[Marco Russo @marcorus]

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.

https://t.co/EV9bMme0Cs

#dax #powerbi #ai

[Marco Russo @marcorus]

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 includes seven "concept" 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: https://t.co/xgmk3vRiiz
If you haven't enrolled yet, there's a launch offer on the course and on the bundle: https://t.co/QXs75tTdaA

[Nikola Ilic @DataMozart]

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

[John Kerski @JKerski]

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.

https://t.co/fC8fIEEums

[Marco Russo @marcorus]

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.
https://t.co/B0b3Pc6t0V

#DAX #PowerBI

https://t.co/Ru2qIF60mu

[John Kerski @JKerski]

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.
https://t.co/o63jJKhC4o

[𝘎𝘪𝘭𝘣𝘦𝘳𝘵 #FourMoo @GilbertQue]

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.
https://t.co/F6YS9PHSvC

[John Kerski @JKerski]

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.

https://t.co/eheGRwvi6z

[Kurt Buhler @kurtbuhler]

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.

[KratosBI @KratosBi]

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

https://t.co/vUNkohl5sN