MSBI Tutor

Outbound Access Protection (OAP) is a workspace-level network security and governance feature that blocks outbound traffic from a workspace by default and lets you allow only the destinations you explicitly trust. With this preview, you can now extend OAP to semantic models. Power BI reports aren't part of this preview yet; report support is coming in a separate announcement soon. Outbound data movement from semantic models Semantic model connections can cross workspace boundaries and can pull data from cloud and on-premises sources, including destinations that fall outside your organization's data boundary. Composite semantic models (models combining tables from multiple sources) can also send data from one source to another, when pushing filter values to a table in DirectQuery mode, as depicted in the diagram example. The relationship between Table A and Table B might have been created unintentionally. The query does not have to return meaningful results. The point is that va...

Semantic model settings pane (Preview) The semantic model settings experience has been refreshed. The redesigned settings pane, aligned with the modern Fabric look and feel is now available.  Figure: The new semantic model settings pane, opened in context next to the workspace. Why it matters The settings page has served its purpose well, but it requires navigating away from whatever you were doing. The new settings pane keeps you in context—your workspace, items, and scroll position stay right where you left them. It opens instantly, with no page load and no navigation away from your model. When you’re done, select anywhere outside the pane to close it. Equally important, the settings pane is designed for long lists of settings that fit poorly with long scrollable pages. Related sections are now grouped into collapsible regions, making navigation easier. The search feature also saves time. If you can't find the refresh history instantly, type ‘re’ in the search box and pick View R...

Execute DAX Queries REST API (Preview) This new API lets you run DAX queries against Power BI semantic models and receive results in Apache Arrow IPC format. It is the same API that you already use in DAX Query View in Power BI Desktop and in the Power BI service. Now you can integrate as a public REST API into your custom Power BI solutions. Why a new API? Unlike the existing Execute Queries API, which returns results in JSON format, the new Execute DAX Queries API relies on Apache Arrow IPC. The results are in columnar binary format and support native data-type fidelity. There are no fixed row limits, and you can submit multiple DAX EVALUATE statements in a single request. The new API is only available on Power BI Premium and Microsoft Fabric capacities, and any caller must be able to process binary Arrow streams. Arrow libraries are available for Python, C#, Java, JavaScript, and many other languages, making integration straightforward across most platforms and toolchains. Getting s...

Welcome to the May Power BI update! Power BI continues to evolve with updates that make it easier to explore data, generate insights, and build more polished reports. This month’s release brings improvements across Copilot and AI experiences, reporting and modeling enhancements, new data connectivity flows, and updates to visualizations—helping you move faster from data to decisions.  Contents Copilot and AI Explore Improvements Copilot summary shortcuts Copilot Narrative visual now supports embedding in customer applications (Preview) New Copilot Tooling Format (Preview) Reporting Visual calculations and custom totals (Generally Available) Custom totals: None and Average (Generally Available) Set as landing page (Generally Available) Default format string locale for dates and numbers (Generally Available) Translytical task flows: optional parameters and default values (Generally Available) Input slicer numeric column support (Generally available) Matrix auto-expand for embedded vi...