Power BI Weekly

Issue 362

16th June 2026

Welcome to the 362nd edition of Power BI Weekly! The headline from the Power BI/Fabric team is that org apps now support audiences and have reached general availability, letting you carve a single app into tailored experiences for different groups instead of maintaining near-identical copies (a long-standing request, and a welcome one). Also in preview, Kay Unkroth has announced simplified Oracle connectivity. Power BI Desktop now comes with the Oracle driver built in, and the service can connect straight to cloud-hosted Oracle, so you no longer have to install a separate driver or set up a gateway.

On the community side, Phil Seamark explains why the RLS bitmap default just quadrupled from 128K to 512K rows, diving deep into the caching the engine does to keep row-level security fast (and why you can be caught out by growing tables in your model). And Kurt Buhler reflects on lessons from Anthropic's agentic self-service BI rollout: unlike code, a business question usually has one right answer, so reliable AI analytics still rests on clean data, solid semantic models and curated metadata.

Data Prep

  • Simplified Oracle connectivity in Power BI (Preview) Power BI’s upcoming preview removes the need for separate provider installations and data gateways, offering seamless connectivity to Oracle databases including cloud-hosted options like Autonomous Database.
  • AI is Only as Smart as Your Model The article emphasizes that robust data quality is crucial for effective AI outcomes, arguing that a strong data foundation-supported by an optimized semantic layer-is more important than ever as AI integrates deeply into analytics experiences.
  • Power Query Remove Duplicates Keeps the WRONG Record (Here's the fix) Power Query's "Remove Duplicates" feature can silently keep the wrong record when processing large datasets due to lazy evaluation, but wrapping the sort step in Table.Buffer() ensures you always retain the latest entry.
  • Combining Multiple Excel Files in Power Query Using Claude The video demonstrates how Claude in Excel can assist with merging multiple Excel files using Power Query, testing its effectiveness across simple to complex data structures while highlighting best practices and limitations.

Data Modeling

  • There Is More Than One Way to Query Your Data: Have You Tried DAX? DAX queries let you extract precise data slices from Power BI semantic models into Excel or other tools, offering built‑in business logic measures and automatic relationship handling without manual joins.
  • Rebuilding My First Fabric App (WITHOUT AI ❌🤖) Edward Charles rebuilds his first Microsoft Fabric App manually without AI assistance, detailing each step from creating an empty data app to publishing the final Fabric DataGrid, and sharing resources for learning TypeScript, React, SQL, and Power BI.
  • In Power BI, Is the Semantic Model Now the Real Product? The semantic model in Power BI is emerging as the core product, influencing governance, reuse, scalability, and delivery of business value within modern BI workflows.

Report Authoring and Interactivity

Deployment, Security and Operations

  • Power BI Large Semantic Model Storage Format: Do You Need It? Power BI’s large semantic model storage format lets models exceed 1GB by persisting data on Azure Premium Files Storage, reducing refresh failures and enabling advanced XMLA write operations, but requires Premium licenses and careful management of eviction latency.
  • Fabric Apps – náhrada Power BI reportů? Fabric Apps offer a new type of web application running directly on Azure Fabric, eliminating external hosting and leveraging Entra ID authentication and workspace governance through OneLake, with potential for both operational apps that allow data writing and data apps as visual dashboards powered by DAX queries.
  • Org apps with audiences for Power BI and Fabric (Generally Available) The general availability of org apps in Power BI and Fabric now includes audiences, a highly requested feature that enhances data sharing and collaboration within organizations.
  • Why the RLS bitmap default just went up 4x The Power BI engine has raised the RLS bitmap default threshold from 128,000 to 512,000 rows, allowing row-level security filters to be cached as larger bitmaps and reducing query performance degradation for models exceeding that size.
  • No Code, No Tools: Documentation for Power BI & Fabric Using Fabric Skills and Github Copilot This video demonstrates how GitHub Copilot combined with Fabric Skills automates Power BI and Fabric object documentation, reducing manual effort by teaching AI full context of the Fabric environment.

General

Get Power BI Weekly in your inbox every Tuesday

Sign up to receive the email every week and keep on top of all the announcements.

Don't forget to confirm your subscription. We have a double opt-in sign up process to prevent spam.

We will never provide your details to any third parties. We don't spam.

Power BI Weekly Logo