Power BI September 2025 Feature Summary
The Power BI September 2025 Feature Summary introduces updates for users and coincides with FabCon Vienna! This release introduces several key enhancements, including, updates to Copilot and AI capabilities such as the standalone Copilot default-on experience, and important changes to default visuals like the Bing Maps Visual icon. Dive into the details to discover how these innovations can elevate your Power BI experience. Contents Events and Announcements Get certified in Microsoft Fabric Power BI DataViz World Championships – happening live at FabCon Vienna! Copilot and AI Standalone Copilot to default-on Auto-selection of Copilot workspaces Save Explorations to pro workspaces Find Power BI reports in M365 Copilot search improvements Prep data for AI coming soon to the Power BI service Reporting Enhanced DAX Time Intelligence (Preview) Performance analyzer available when editing a report in the web Translytical Task Flows are now enabled by default in Power BI Modeling Editing semantic models in the Power BI Service (Generally Available) Live editing Direct Lake semantic models with Power BI Desktop (Generally Available) TMDL view (Generally Available) Download PBIX of XMLA altered semantic models Fabric Notebooks for Power BI: Best Practices Analyzer and Memory Analyzer (Generally Available) Direct Lake on OneLake + import in web modeling (Preview) Direct Lake on OneLake + import in Desktop DAX User Defined Functions (Preview) Refresh data or schema options in Power BI Desktop Power BI content shared in Teams now opens in a separate window Mobile NFC tag support in Power BI Mobile (Generally Available) Other New Tenant Setting for Set alert button visibility Visualizations ADWISE Advanced Column v 2.0 Zebra BI Tables: Calculated Reports in One Click and Brand Images Word Cloud by Powerviz Drill Down Combo Bar PRO by ZoomCharts CAGR Arrows Now in Zebra BI Charts Closing Version number: v: 2.147.909.0 Date published: 09/15/2025 Events and Announcements Get certified in Microsoft Fabric Join the thousands of other Fabric users who’ve achieved over 50,000 certifications collectively for the Fabric Analytics Engineers and Fabric Data Engineers roles. To celebrate FabCon Vienna, we are offering the entire Fabric community a 50% discount on exams DP-600, DP-700, DP-900, and PL-300. Request your voucher. Power BI DataViz World Championships – happening live at FabCon Vienna! Four finalists are taking the stage at FabCon to compete for the title of world champion! FabCon Vienna Power BI Dataviz World Championships – and the winner is... Congratulations to Paulo Grijó! Read more about the finals and all four finalists. Copilot and AI Standalone Copilot to default-on The standalone Copilot experience for Power BI, also known as chat with your data—is a full-screen, chat-based AI experience that finds data and answers questions about any report, semantic model, or Fabric data agent you have access to. The standalone Copilot experience will be enabled by default for all tenants where Copilot has already been turned on. If you would like to opt out, If your tenant admin has enabled this setting: Users can use Copilot and other features powered by Azure OpenAI—this setting will be automatically enabled in September: Users can access a standalone, cross-item Power BI Copilot experience (preview). We understand that some organizations are still preparing their data for AI and configuring what Copilot can access. You can opt out, here’s how: Turn the setting on in the admin portal, then immediately turn it off. This action tells us that you prefer to enable the standalone Copilot later, and we’ll skip the automatic default-on for your tenant. Auto-selection of Copilot workspaces If you don’t have access to a Fabric Copilot Capacity (FCC), you can still use the standalone Copilot experience. However, you’ll need to manually select a Copilot workspace for billing and usage tracking. This step has caused confusion for many business users, as workspace names, eligibility rules, and billing details are often unfamiliar. Beginning in late September, Copilot will automatically assign a workspace to each user, allowing them to access their environment without additional steps. You will still have full control to change their selection at any time, but the automatic selection will clear a roadblock and make it easier to start getting insights from Copilot. How auto-selection works Smart distribution: We generate a partially randomized list of workspaces, weighted toward those with more available capacity. This helps balance usage and avoids overloading any single capacity. Eligibility check: We’ll pick go down that list and pick a workspace tied to a capacity that meets Copilot requirements (in short, F2 or higher, in a supported region, enabled for use with Copilot). Persistence: Once selected, the workspace stays set across sessions. Fallbacks: If the workspace is later disabled for Copilot, we’ll automatically reassign a new one and alert the user. If an FCC becomes available, it will always override the auto-selected workspace. User control: A dismissible notification will let users know which workspace was chosen, with a direct option to change it. mber_2025_Feature_Summary You can also update it anytime via More > Manage workspace in the standalone Copilot experience. Why this matters This update clears friction for business users who want to use Copilot but don’t know (or need to know) the intricacies of capacities and workspace settings. By auto-selecting a workspace, we help them get straight to the insights they care about—while still giving admins and power users the flexibility to make changes as needed. Save Explorations to pro workspaces Previously, you could only save Explorations to Premium workspaces. Now, you can also save them for Pro workspaces as well. This makes it easier to save and share insights gained during your exploration. Find Power BI reports in M365 In the July 2025 Power BI Feature Summary, we announced the extension of the Power BI and M365 integration to further improve Power BI item discovery and search relevancy in M365 Copilot experiences & Office search. This expansion will empower consumers to locate their Power BI reports and data directly from M365 environments where they already work. Since then, we’ve made significant progress; users can now find Power BI reports by searching for a variety of report content in both Microsoft 365 Search and Copilot. Now, searching for a report title, description, chart title, or other contextual details within the report will display relevant Power BI items in M365, simplifying the process of finding reporting resources for daily data-driven decisions. Search for Power BI items in the M365 Copilot Search Search for Power BI items in the M365 Copilot Chat To learn more about how to share Power BI data with M365 for your organization, refer to the Share data with your Microsoft 365 services documentation. Copilot search improvements Copilot report descriptions make it easier to identify which report can answer your question without needing to open each one for verification. When the report author hasn’t added an item description, Copilot will provide a descriptive caption in Copilot search lists. Search prefers items that have been Prepped for AI. When content creators update the Prepped for AI setting to indicate that a semantic model is ready for use with Copilot, search is now boosting that prepped content (both the model, and all reports that use it). Content that’s ready for Copilot will be preferred in Copilot search over equally relevant Certified & Promoted content. In addition, we’ve sped up the delay in applying the prepped status of the model to the report from 24 hours to under 1 hour (but usually just a few minutes) in most cases. Hints for item types and workspaces, Copilot search returns results that are semantically like your question’s topic, which can be helpful when you don’t quite remember the report’s name. But often we remember other information that could help narrow the search. Copilot can now recognize the key concepts of workspaces and item types, which you can use to guide search. If you’re looking for a semantic model you created ages ago to model effective advertising spend, you might ask: ‘Find semantic models with fields about campaigns, ROI, and impressions'. Or, if you want to prefer content in a particular location, you might say: ‘Summarize quarterly sales, from the workspace East Coast Only’. This won’t act as a strict filter, so if you have a workspace called ‘Excluding East Coast’, you might see results from that workspace because the workspace names are similar. Copilot search responses will now prefer to surface just reports and data agents when the user doesn’t specify. Copilot can still use the report’s semantic model to answer the user's question, but in this way, we’re focusing on items that users are more likely to recognize. Updates to support filter pass-through, you may have already noticed updates in how verified answers show up in our search lists. These changes are purposeful and support Copilot in honoring filter context. For example, when a question about tourism on O’ahu is submitted, it is useful if search indicates that someone has already verified the answer to a similar inquiry. If information is needed for a different island, and that selection is available as a filter in a commonly used report, Copilot can be directed to use that specific report. In the following example, the verified answer is used as a starting point but filtered to directly answer my original question. You can find the filters applied to the visualization. When you use Copilot to search, you'll now see recommendations for what to do next, such as summarizing the report or providing an overview of the key metrics. Learn more about these features and how Copilot search works in the Find content with Power BI Copilot search documentation. Prep data for AI coming soon to the Power BI service In the coming weeks you will be able to prepare your data for AI directly in the Power BI service. Making it easier to keep your semantic models Copilot-ready without switching tools — and it unlocks additional model types you can prepare, including Direct Lake models and more. With prep data for AI features available in the service, you will be able to: Select a Copilot schema Set up and manage Verified Answers Add AI instructions To use these features: In the Power BI service, select the semantic model you want to prep. On the model page, select the Prep data for AI button in the ribbon. When you’re ready, don’t forget to update the model setting so users in your organization can start using Copilot with confidence. Reporting Enhanced DAX Time Intelligence (Preview) A brand new, calendar-based approach to time intelligence in Power BI has arrived! With this update, you can now define custom calendars—such as fiscal years or 4-5-4 retail calendars—directly in your data model. This gives you precise control over how your data maps over time, enabling more accurate and flexible analysis. What’s more, it allows you to do week-based calculations as well! Basic example using a Gregorian calendar How to use calendars to perform a total month-to-date calculation on a Gregorian calendar: To get started, simply turn on the 'Enhanced DAX Time Intelligence' feature in preview settings. Select Calendar options from the context menu on your date table. Create a calendar by associating columns in your date table into categories. Example: The Gregorian Calendar below maps the Year, Quarter, Month, Month of Year and Date categories to primary and associated columns (Columns can be named as desired). Perform calculations based on your calendar. Example: If you have a calendar called ‘Gregorian Calendar’ defined in your model, you can use TOTALMTD to calculate a month-to-date total sales value based on that: Sales MTD = TOTALMTD ( [Total Sales], 'Gregorian Calendar' ) In addition to expanding existing functions with support for calendars, we have also added brand new functions that allow you to do week-based calculations as well, such as TOTALWTD, PREVIOUSWEEK and more. Show your result in a visual. Example: This chart shows the Total Sales and Sales MTD value we calculated previously. Working with fiscal calendars Many calendars, particularly fiscal calendars, are shifted Gregorian calendars, in which the year does not being on January 1 st , but for example on July 1 st . Microsoft is an example of a company that uses a shifted fiscal calendar. In this case, a date table would include columns for the fiscal periods, such as fiscal year, fiscal quarter and fiscal month: Now, you can define a Fiscal Calendar: endar You can use the calendar in our calculations, for example, this calculates the SAMEPERIODLASTYEAR value using the Fiscal Calendar: Sales Same Period Last Fiscal Year = CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR( 'Fiscal Calendar' ) ) This can then be visualized as follows: Week-based calculations As mentioned, you can now also perform week-based calculations, including 454 and other patterns. After making sure your data table contains week information, associate the relevant categories in your calendar as done below for a 454 calendar: Next, create your DAX calculation, for example, a week-to-date calculation can be made using TOTALWTD: Sales WTD 454 = TOTALWTD ( [Total Sales], 'RETAIL-454' ) The column chart shows the actual and the week-to-date sales value based on our RETAIL-454 calendar. There is much more to learn about this feature as it allows for a lot of advanced scenarios. Learn more about this preview in our time intelligence documentation and try it out in your next report and let us know what you think! Performance analyzer available when editing a report in the web Performance analyzer is now available in the web report editing experience and provide information on visual load times. Load times update as you interact with the report. Copy the DAX query from any visual to troubleshoot even further. Previously accessible in Power BI Desktop, this feature now allows users to observe report performance after publication. To learn more, refer to the Use Performance Analyzer to examine report element performance in Power BI Desktop documentation. Translytical Task Flows are now enabled by default in Power BI As a refresher, Translytical task flows, released in May 2025, marked a major evolution in Power BI by allowing users to act on insights instantly without leaving the report. Powered by Fabric User data functions, Translytical task flows allow users to automate tasks such as updating records, dynamic notifications, and even triggering workflows across other systems. To learn more about Translytical task flows, refer to the Understand translytical task flows documentation. Modeling Editing semantic models in the Power BI Service (Generally Available) This milestone unlocks end-to-end Power BI authoring directly in the browser, bringing core modeling parity between the web and Desktop experiences. Yes, that means Mac users can now model in Power BI, no Desktop required! What’s Supported? Create from scratch in the web - You can create net new import semantic models and reports directly in the browser! Navigate to the ‘Create’ page and select ‘Get data’. Choose from over 100 supported connectors to bring in your data, shape it with Power Query, build your semantic model, and design your report. Edit existing semantic models - The Power BI service now offers advanced modeling capabilities, including: Adding new import tables to your model Transforming import tables using the full Power Query editor Refreshing schema and data Managing relationships Writing and editing DAX measures, calculated columns, calculated tables, and calculation groups Editing properties in the properties pane Defining and assigning row-level security roles This release enables core modeling features in both Power BI Desktop and the web, allowing you to build and manage models easily from anywhere. To learn more, refer to the Edit semantic models in the Power BI service documentation, or the Deep Dive into Editing Semantic Models in the Power BI Service (Generally Available) blog post. Live editing Direct Lake semantic models with Power BI Desktop (Generally Available) This capability allows you to use the familiar Power BI Desktop interface to edit Direct Lake semantic models. All processing occurs in your Fabric workspace, directly against OneLake data, using the Power BI Analysis Services engine instead of your local machine. With live edit, every change you make, whether creating new measures, adding calculation groups, defining relationships, running DAX queries, and more, is applied directly to the semantic model in Fabric, ensuring a seamless, scalable modeling experience. Getting started is easy You can begin in Power BI Desktop or from the web: Start from Desktop Open the ‘OneLake data hub’ in Power BI Desktop. Select your Direct Lake semantic model. From the ‘Connect’ button drop-down, select ‘Edit’. Start from the web: In the web experience, select ‘Edit in Desktop’ for the Direct Lake semantic model you have opened. This will launch Power BI Desktop with the semantic model ready for editing. To learn more, refer to the Direct Lake in Power BI Desktop documentation, or the blog post. TMDL view (Generally Available) TMDL view introduces a modern code-first editing experience for Power BI semantic models using the Tabular Model Definition Language (TMDL). A user-oriented modeling language designed to enhance transparency, governance, and efficiency in the development of semantic models. With TMDL view, you can easily make batch updates using simple find-and-replace operations or leverage your preferred generative AI tool to create or modify TMDL code at scale. General availability introduces several notable enhancements: Full code highlighting including DAX and M (Power Query) Execution status in the script tabs For more information about TMDL view and full list of capabilities, please refer to our Work with TMDL view in Power BI Desktop (preview) documentation. Download PBIX of XMLA altered semantic models A key goal of the TMDL view work was to ensure Power BI Desktop can reliably handle any semantic model configuration. If the model is valid in Analysis Services in a Fabric workspace, it can be opened and edited in Power BI Desktop without crashing. Semantic model metadata not accessible through the user interface - such as multiple table partitions - can still be edited using TMDL view. Previously, users could use the XMLA endpoint with external tools to make semantic model changes - such as creating multiple partitions - that were supported by Fabric but not by Power BI Desktop. This mismatch often caused Power BI Desktop to crash, which is why downloads were blocked for XMLA altered semantic models. Now that TMDL view is generally available, we’ve removed this limitation. You can now download PBIX files for semantic models modified through the XMLA endpoint, and open and edit them in Power BI Desktop. This update does not mean that all semantic models are now downloadable as PBIX files. For example, semantic models with incremental refresh partitions are still not supported for download, this will be addressed in a future update. For more details on PBIX download limitations, please refer to our Limitations when downloading a report .pbix file documentation. This feature is currently rolling out and may not be fully available in all regions or for all users yet. We appreciate your patience as we complete the deployment over the coming weeks. To learn more, refer to the Open and edit any semantic model with Power BI tools blog post. Fabric Notebooks for Power BI: Best Practices Analyzer and Memory Analyzer (Generally Available) These one-click experiences make it easy to use Fabric Notebooks and Semantic Link to analyze your semantic models directly on the web. Best Practice Analyzer evaluates models using more than 60 rules across five categories: performance, DAX expressions, error prevention, maintenance, and formatting. It provides guidance on design and performance based on these criteria. Memory Analyzer provides detailed memory and storage statistics for tables, columns, hierarchies, partitions, and relationships, helping you identify optimization opportunities. We would like to give a special shoutout to the Power BI community members whose contributions laid the foundation for these tools: Daniel Otykier – creator of Best Practice Analyzer in Tabular Editor Marco Russo – developer of VertiPaq Analyzer Michael Kovalsky – builder of semantic link labs powering these notebooks Explore the Power BI Community Notebooks Gallery to discover and share notebooks that enhance data analysis and reporting with the Power BI Community. Learn more about using notebooks with your Power BI semantic models including details on this feature and its limitations in the Use notebooks with a semantic model documentation. Direct Lake on OneLake + import in web modeling (Preview) Semantic models edited in web modeling now have full flexibility of both Direct Lake on OneLake and import table storage modes. Open a semantic model with either Direct Lake tables or import tables and add in additional tables from either storage mode. Choose Get Data to add in import tables from any of the 100s of connectors supported. Choose OneLake catalog and add in Direct Lake tables from any of the Fabric data sources you have access to, including Lakehouses, Warehouses, Mirrored databases, Mirrored Azure Databricks catalogs, and SQL databases in Fabric. Summary Once in import storage mode you can transform the table further in Power Query and add in calculated columns to get your reporting where it needs to be. Hierarchies added to import tables also can be used in Analyze in Excel. To learn more, refer to the Direct Lake overview documentation. Direct Lake on OneLake + import in Desktop Power BI Desktop can also live edit semantic models with both Direct Lake and import tables. Edit relationships, add measures, and adjust column and table properties right in Power BI Desktop. To learn more, refer to the Direct Lake overview documentation. DAX User Defined Functions (Preview) Power BI has long supported custom functions in Power Query, however now DAX User Defined Functions (UDFs) provide similar capabilities. DAX UDFs allow you to define custom functions with parameters, just like you would define functions or methods in programming. Instead of copy-pasting chunks of logic across multiple measures, you can now write your logic once and reuse it everywhere. Complex problems can be encapsulated by multiple reusable functions. Functions can even refer to other functions! This way, your logic becomes easier to write, understand, maintain and debug. Whether you are working on complex models or just want cleaner, more maintainable code, DAX UDFs are for you. Up to this point, the reusability of DAX logic was limited to calculation groups. DAX UDFs, however, unlike calculation groups, can be parameterized. Getting started with DAX UDFs To get started, simply turn on the ‘DAX User Defined Functions’ feature in the preview settings. You can define DAX UDFs in multiple ways, including the DAX Query View and TMDL view. Defining and using a function Defining a function is straightforward as we have introduced a new FUNCTION keyword. The general structure for defining a function is: /// [function description] FUNCTION <FunctionName> = ( [parameter name] : [parameter type] ) => <body> For example, here is a DAX query that defines and evaluates an extremely simple function that applies a 10% tax to an amount. DEFINE /// AddTax returns the amount including tax FUNCTION AddTax = (amount) => amount * 1.1 EVALUATE { AddTax(11) } // Return 11 After adding the function to the model, you can then call the function from other places where you can use DAX, such as measures: Parameters Just like built-in functions, DAX UDFs can take zero or more parameters. You can also provide the type of the parameter, so your functions are much more resilient. For example, to identify that our AddTax function expects a numerical value, we could write. DEFINE /// AddTax returns the amount including tax FUNCTION AddTax = (amount: numeric) => amount * 1.1 Parameters can not only take scalar values but also accept tables and even expressions. Type checking To make DAX and TMDL/TMSL more consistent, we have introduced a set of new functions to do type checking and updated the DATATABLE, CONVERT and EXTERNALMEASURE functions have been updated to work with all synonyms as well. For example, we now have added ISSTRING, which is an alternative to, ISTEXT and ISNUMERIC which is a complement to ISNUMBER. A complete list is available in our documentation. Managing DAX UDFs Functions are shown in the model explorer: In DAX Query View, we even added quick queries, so it’s even easier to define and evaluate existing functions or write a brand new one. The possibilities are endless DAX UDFs open a whole new spectrum of options, and this blog cannot do it justice. We encourage you to enable the preview today and try it out for yourself. Read more in the Power BI DAX User Data Functions documentation. Please let us know what you think. We are looking forward to seeing all the creative uses of UDFs! Refresh data or schema options in Power BI Desktop When you select ‘Refresh’ in Power BI Desktop, it always performs a schema sync first, followed by a data refresh. While this behavior is convenient in most cases, there are scenarios where you may want to refresh the data without updating the model schema, even if the data source has changed its schema. For example, in Direct Lake semantic models, the underlying Lakehouse table might have changed (e.g., a new column added). You may want the latest data but prefer not to bring new columns into the model. With this month's update, you now have more control over the refresh operation. You can choose to: Sync schema only – Updates the semantic model to reflect the data source structure (e.g., column type changes or new columns). Refresh data only – Loads fresh data while preserving the current schema in your semantic model. These options are also available when you refresh tables individually in the data pane: This added flexibility helps you manage your models refresh operations more intentionally, based on your specific needs. For more information about Power BI Desktop refresh, refer to the Data refresh in Power BI documentation. Power BI content shared in Teams now opens in a separate window In this month's update, when you open a Power BI item which was shared with you in Teams chat or channel, it now opens in separate window—so your chat and other Teams apps stay exactly where you left them. Previously, opening an item from a Power BI preview card would replace your Teams chat, making multitasking difficult. With this update, items shared in a chat open in a separate window, while your original chat remains visible in a collapsible side panel. You are now able to access data, maintain ongoing conversations, and utilize additional Teams applications simultaneously. Figure - A user selects 'Open' on a Power BI report preview card within a Teams chat. The report launches in a separate Teams window, while the original chat remains accessible in a collapsible side pane. To learn more about Power BI preview cards in Teams, refer to the Link preview cards in Microsoft Teams chats and channels documentation. Mobile NFC tag support in Power BI Mobile (Generally Available) Imagine being able to access your important data just by tapping your device on a small tag. That’s the power of NFC (Near Field Communication) tags. NFC Tag Support is now generally available in the Power BI Mobile app on supported devices! This feature allows you to register and read Power BI items such as reports, scorecards, dashboards, or even a set of items like an app or workspace on NFC tags directly from the app. With NFC you can create a seamless connection between your data and the physical world. For example, a retail manager could quickly access inventory data by tapping their phone on an NFC tag placed on a storage shelf. This feature is especially useful for frontline workers who need quick access to data while managing retail floors, inventory, or manufacturing processes. Getting started is easy: open the Power BI Mobile app, navigate to the item you want to register, press the Register to NFC button in the 3 dots menu, and follow the prompts to link it to an NFC tag. Once you’ve registered your desired item to the tag, anyone with the Power BI Mobile app can get to the item simply by tapping the tag with their device, whether the app is open or not. If the user doesn’t have permission to access the item, they’ll be taken to the request access flow. NFC tags are affordable, flexible, durable, and reliable, and can easily be reused. To learn more about NFC support in Power BI mobile, refer to the Connect data to physical locations with NFC tags documentation. Other New Tenant Setting for Set alert button visibility A new tenant setting, all Power BI users can see ‘Set alert’ button to create Fabric Activator alerts, is rolling out this week. This setting will give admins more control over which users can view the Set alert button, which allows users to create Fabric Activator alerts on their visuals, sending real-time notifications based on predefined data conditions. When enabled, all Power BI users will see the ‘Set alert’ button in reports. When the setting is turned off, the button will only be visible to users with tenant-level Fabric access, which was the group of users who could see the button prior to this change. Regardless of whether the setting is turned on or off, only users with permission to create Fabric items can set up Fabric Activator alerts. The benefit of turning this setting on is that it allows users for whom Fabric was enabled for only specific capacities to also set alerts, unlocking the power of real-time alerting for more Power BI users. This setting is currently disabled and will be turned on by default the week of October 13th. Visualizations ADWISE Advanced Column v 2.0 Advanced Column is easy to use column chart for comparing one or more values with clearly interpretable difference lines. It is best suited for comparison of values between time periods, categories or quantities. This visual presents the following features: Chart types - stacked, clustered and nested/chimney charts in one visual. Difference lines – lines to clearly show difference above compared columns with values in specific shapes, all configurable (percentage/absolute difference, colors, borders, rounded corners, lines share starts/ends). Top N selection Built in – Easily display key data by selecting the Top N columns or Top N segments within each column + the "rest" part of the data. Total Column - It is not necessary to display separate KPIs for totals, as the Total column is already included in the chart. User controls – Enable/disable viewer change of Top selections (how many to show, highest/lowest) and Total Column calculation. Enable and Add Icons – Icons make charts easier to read by visually representing column categories, you can add icons directly in the visual using the built-in icon picker. And other formatting - Axis Y break, thousand and decimal separator, interaction with other visuals, empty data screen, animations, gradient background, shadows, transparency. Try from AppSource. Zebra BI Tables: Calculated Reports in One Click and Brand Images The latest update to Zebra BI Tables introduces two powerful features that streamline report building and enhance data storytelling: row calculations from the data model and brand images in rows. Check out the demo video: Zebra BI May 2025 Update: One Click P&L and Brand Logos in Zebra BI Tables With the new zero-click reporting functionality, users can now define calculation logic (such as invert, result, skip) directly in the Power BI data model. Simply add a column to your dataset, define the logic with symbols (“=” (Result), “/” (Skip), “-” (Invert)), and with a single drag and drop add it to Zebra BI Tables. The column values will automatically be applied as calculations on the visual, eliminating the need for additional manual setup. It makes the creation of reports like P&Ls, balance sheets, inventory tracking, SaaS metrics, or sales dashboards dramatically faster and more accurate. Zebra BI Tables now also supports adding brand images instead of row labels. Especially valuable for consumer goods and retail companies, this feature makes reports more intuitive and engaging. By instantly recognizing brand logos, end users grasp insights faster and spend less time searching for context. These updates contribute to: Massive time savings. Error reduction. Standardized reporting across teams. Simplify your reporting with Zebra BI Tables and share your feedback. Word Cloud by Powerviz The new Word Cloud by Powerviz is available, an advanced visual which empowers you to create some of the most high-quality and creative word art in the Power BI. Key Features: Word Styling: Make your word clouds pop with personalized text styles. It offers font styling, direction & text editing features. Color Options: Choose from 30+ color palettes, including color-blind safe options. Shapes: Create eye-catching word clouds by selecting or uploading images. Exclude: Easily remove unnecessary words and symbols from the text to produce a clean and focused word cloud. Ranking: Filter out Top/Bottom N Words. Conditional Formatting: Easily spot words with dynamic rules. Lasso/Reverse Lasso: Select or deselect multiple words with ease. Grid View: Switch to an interactive table with sort, filter, and search features. Show Condition: Dynamically show or hide the visual based on conditions. Ideal for marketing, education, market research, and presentations—use it for sentiment analysis, SEO keywords, brainstorming, surveys, and engaging communication. Try Word Cloud visual for FREE from AppSource Check out all features of the visual: Demo_file Step-by-step instructions: Documentation YouTube Video: Video_Link Learn more about visuals: https://powerviz.ai/ Follow Powerviz: https://lnkd.in/gN_9Sa6U Drill Down Combo Bar PRO by ZoomCharts What makes Drill Down Combo Bar PRO the best custom visual for visualizing categorical data? It’s all about the drill downs – in Combo Bar PRO, you can create a hierarchy of up to nine category fields, and users can easily drill down by clicking directly on data. Deeper, more focused insights, but only when the user needs them. The visual is designed to provide top-notch user experience: the slick and intuitive on-chart interactions, the smooth animations, the seamless cross-filtering with other visuals, and full touch support all make Combo Bar PRO a crucial addition to your next report. And the best part? Combo Bar PRO supports up to 25 series, and each series can be visualized as bars, lines or areas. With a wide variety of customization options, you can create the perfect chart for your use case. We also recently published a guide on how to create different types of stacked charts with Combo & Combo Bar PRO, including stacked bar, stacked & clustered bar, bar & line, nested bar chart and more. For a more details, refer to our blog - Power BI Stacked Column Charts: A Full Guide! Get Drill Down Combo Bar PRO CAGR Arrows Now in Zebra BI Charts Compare multi-year trends across business units, products, or regions — instantly. The Compound Annual Growth Rate (CAGR) is a critical metric for visualizing growth trends in financial analysis, strategic planning, and performance comparison. Now available in Zebra BI Charts for Power BI, CAGR arrows make it easier than ever to communicate multi-year trends directly within your reports. They are especially useful in dashboards that track long-term results, helping users highlight growth patterns and shifts over time. When used in small multiples, CAGR arrows allow immediate comparison of performance across regions, product lines, or business units — all while maintaining a shared Y-axis for IBCS-compliant reporting. Each CAGR label includes a color-coded action dot — green for growth, red for negative — with the size scaled to reflect magnitude, offering an intuitive visual cue for trend strength. To simplify reporting even further, Zebra BI Charts automatically calculates the CAGR based on your underlying data. CAGR provides a smoothed view of performance over time, helping teams refine growth targets, align KPIs, and deliver executive ready insights with clarity and impact. To learn more, refer to Introducing CAGR arrows in Zebra BI Charts. Closing This concludes this month’s update. We hope the information provided in this update is useful. If you installed Power BI Desktop from the Microsoft Store, please leave us a review. As always, keep voting on Ideas to help us determine what to build next. We are looking forward to hearing from you!Power BI October 2025 Feature Summary
This month's update brings exciting opportunities for learning and community engagement, including the upcoming Fabric Data Days and the return of FabCon in Atlanta next spring. Notably, Power BI is making strides in mapping capabilities by transitioning from Bing Maps to Azure Maps, ensuring users have access to the latest features and support. Dive into the details to stay informed about what's new and what's ahead for Power BI. Contents Events & Announcements Fabric Data Days are Coming! FabCon is back from March 16-20, 2026, in Atlanta, GA General Bing Map deprecation plan & Update in Power BI Copilot and AI Copilot to write DAX queries in DAX query view (Generally Available) Reporting Button slicer (Generally Available) Visual calculations are now supported in embed for your customers (Preview) Automatically expand table columns to fill available space Introducing the new Power BI Controller in Power BI in PowerPoint (Preview) Performance analyzer in web to see the load times of visuals Data connectivity Export Query Results (Preview) Other Power BI Desktop is now supported on ARM Visualizations Sankey Chart by Powerviz Your Timeline Slicer: Reimagining Date Filtering for Modern Dashboards Drill Down Scatter PRO by ZoomCharts Multiple Sparklines Performance Bar by JTA Financial Reporting Matrix v8.2 BI Pixie by DataChant - Measure the Effectiveness of Your BI Assets in 6 Dimensions from Adoption to Security Events & Announcements Fabric Data Days are Coming! Take your Power BI skills to the next level and join us for 2 months of learning, contests, live sessions, discount exam vouchers and community connection. Sign up for our live session series to stay connected – it all kicks off on November 4 th . FabCon is back from March 16-20, 2026, in Atlanta, GA Join us for the ultimate Power BI, Microsoft Fabric SQL, Real-Time Intelligence, AI, and Databases community-led event. The third annual FabCon Americas will feature sessions from your favorite Microsoft and community speakers, keynotes, more opportunities to Ask the Experts for 1:1 support, an engaging community lounge with opportunities to network and connect with your peers, a dedicated partner pre-day, a packed expo hall, Power Hour, Data Viz World Championship, and a can’t-miss attendee party at the Georgia Aquarium. Register with code FABCOMM to save $200. General Bing Map deprecation plan & Update in Power BI To ensure a seamless experience and stay ahead of upcoming Microsoft’s plan to retire Bing Maps for Enterprise, Power BI is proactively transitioning from Bing Maps to Azure Maps. By making this change early, Power BI users will benefit from enhanced mapping capabilities and long-term support. We encourage customers to begin updating their reports to Azure Maps visuals to stay future ready. Power BI Desktop and Web (Edit- mode) Earlier, we shared plans to remove the Bing Maps icon from the Visualization pane. After reconsideration, we’ve decided to keep the icon visible for now to ensure continuity and minimize disruption. Please note that the Bing Maps visual is still slated for deprecation, and we’re currently discussing the timeline. Any existing Bing Maps already in your reports will still be available. In preparation for the upcoming change, upgrade to Azure Maps unless: You have team members who would consume the report in China, Korea, or government clouds. You're physically located in China or Korea (regardless of where your home tenant is located). You're part of a government cloud. We're working to support Azure Maps in these unsupported regions. If you and all report users are in a supported region, you're encouraged to start using Azure Maps now. Learn how to upgrade to Azure Maps. To see the list of supported regions, see Azure Maps service geographic scope. For more information about Azure Maps, see Get started with Azure Maps Power BI visual. Power BI Report Builder The migration of paginated reports map visuals from Bing Maps to Azure Maps has begun. This migration will occur in two phases: first, migrating to Azure Maps in PBIRB, followed by migration to Azure Maps for paginated reports in the service. The initial phase is complete. Beginning with the September release of PBIRB, users can create map visuals powered by Azure Maps by default. However, paginated reports published in the service will continue to use Bing Maps until phase two is completed. Phase two is expected to be completed by mid-November. Paginated reports authors can revert to Bing Maps for authoring in PBIRB until both phases are complete. To enable this, users must set the ‘RevertToBingMaps’ registry key located in the ‘Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Power BI Report Builder’ folder to 1. If the ‘Microsoft Power BI Report Builder’ folder does not exist, it should be manually created before setting the registry key. Copilot and AI Copilot to write DAX queries in DAX query view (Generally Available) This innovative capability empowers users to leverage Copilot assistance directly within both the web and Desktop Power BI experiences, making DAX query creation easier and more efficient than ever before. Getting started is simple. In Power BI Desktop or Power BI web modeling, open the DAX query view and select the Copilot button. Describe the insights you are seeking, and Copilot generates the corresponding DAX query. Conversationally edit the DAX query with Copilot, run it as you go, and keep it when you are ready. The following screenshot shows Copilot helping to write a DAX query from the prompt ‘How are we tracking towards our targeted deliveries for each month?’ in DAX query view of Power BI Desktop. The DAX query results show by month the number of deliveries made, the target, attainment %, and variance to target. The next screenshot demonstrates how to write a DAX query to answer the user prompt ‘Can you indicate which month we were over target or under target on deliveries?’ in DAX query view of Power BI web modeling. The DAX query results show by month the number of deliveries made, the target, variance to target, and the status of each month as over or under target. Copilot is grounded in the semantic model, and AI instructions set on the model by Prep for AI. This includes verified answers by understanding the fields used and filters applied. Semantic model tables, columns, descriptions, display folders, hierarchy information, relationships, and measures are all known already to Copilot when creating DAX queries. Copilot to help write DAX queries is used in DAX query view, and in chat with your data experiences when a DAX query is returned as well as data agents when a semantic model is included. To learn more, refer to the Write DAX queries with Copilot documentation, and try it out today! Reporting Button slicer (Generally Available) Along with this release, we’ve added a few exciting enhancements to make your experience even better, including Cross-highlighting, Auto grid, and more. Cross-highlighting Like the Chiclet slicer, the Button Slicer now supports cross-highlighting to help you uncover deeper insights. This means the slicer can interact dynamically with other visuals on your report page by emphasizing relevant values and dimming unrelated ones. For example: If you select North America in a column chart, the Button Slicer will: Highlight buttons like Canada and United States (since they belong to North America). Dim all other countries to indicate they are outside the selection but keep them visible. To use this feature, simply drag a field into this new field, well called ‘Highlight label’ in the Build visual pane. You can now start interacting with now by simply selecting a value on a visual. For example, in the below example if you click on District L1-04 in the scatter chart, you will see the DM of the district L1-04 highlighted while other values are dimmed in the button slicer. Auto grid With the new Auto grid option turned on, your slicer layout becomes smarter. When enabled (and it is by default), the arrangement of rows and columns automatically adjusts based on a defined maximum limit, ensuring a clean and responsive design without manual effort. For example, following is the screenshot with Rows set to 5 and Columns set to 3 and Auto grid on: Auto grid With the new Auto grid option turned on, your slicer layout becomes smarter. When enabled (and it is by default), the arrangement of rows and columns automatically adjusts based on a defined maximum limit, ensuring a clean and responsive design without manual effort. For example, following is the screenshot with Rows set to 5 and Columns set to 3 and Auto grid on: Following is the screenshot with Auto grid Off: In addition to these updates, we’ve introduced several accessibility improvements to make Button Slicer more user-friendly and inclusive. To learn more about these enhancements and how to use them effectively, refer to the Create a button slicer (preview) documentation. Visual calculations are now supported in embed for your customers (Preview) Visual calculations are now supported in Power BI Embedded—specifically in the Embed for your customers scenario. This powerful enhancement brings even more flexibility and intelligence to your embedded analytics solutions. With visual calculations, users, developers and ISVs can now define custom calculations directly within visuals, without needing to modify the underlying data model or write complex DAX. This means faster iteration, more dynamic insights, and a smoother experience for end users. You can also hide/unhide fields on visual and set visual-level format strings. Automatically expand table columns to fill available space We’ve added a new option to table formatting that makes your visuals look cleaner and more balanced—automatically. With ‘Grow to fit’, any extra space in the visual is evenly distributed across existing columns when the total column width is smaller than the visual container. No more manual resizing to fill the gap. If your table isn't using the full visual width, you can manually resize columns or use Auto-size width, but now there's an improved solution. For example, this table doesn't fully utilize the available space: Navigate to the format pane under Column headers > Options, toggle Auto-size width to ‘On’, and set ‘Resize behavior’ to ‘Grow to fit’. Instantly, your table expands to make full use of the available space. The additional available space will be distributed across the columns: It’s a subtle upgrade that makes your data layouts cleaner, more balanced, and easier to read. Note that this will not interfere with any adjustments you make to column widths: once a column width is manually adjusted, it won’t be automatically expanded. Introducing the new Power BI Controller in Power BI in PowerPoint (Preview) This feature was developed in direct response to feedback from our user community and is designed to provide an efficient tool for managing multiple Power BI add-ins within PowerPoint presentations. Users can embed interactive reports and visuals into PowerPoint, supporting data-driven presentations across organizations. As adoption has grown, many of you expressed the need for a centralized mechanism to manage and update several Power BI add-ins across multiple slides. You told us that you are using Power BI add-in for PowerPoint to create data-centric presentations, which you are updating every week or month, and that going over all the add-ins in the presentation and repeating the same operation is time consuming. The Power BI Controller addresses this need by allowing users to execute bulk operations from a single interface. The Power BI Controller is a task pane add-in that serves as a central command center for all Power BI add-ins within a presentation. To get this add-in go to ‘Add-ins’ in PowerPoint ribbon and search for ‘Microsoft Power BI Controller’. Select ‘Add’ to add-in to your ribbon. Once you select it, a new panel will open with the list of commands that you can apply. Pick the command you wish to run and click ‘Apply’. This will trigger the discovery phase in which the controller will look for all Power BI content in the presentation and next the selected command will be executed on the discovered Power BI add-ins. To learn more, refer to View and Present live Power BI Data in PowerPoint. Performance analyzer in web to see the load times of visuals In September, we announced the availability of a performance analyzer pane on the web to see the load times of the visuals in your report where your users are going to be viewing it. Unfortunately, the rollout was delayed. This functionality will be available to your tenant in the next few weeks. To learn more about this new capability while editing a report in web, refer to the Use Performance Analyzer to examine report performance documentation. Data connectivity Export Query Results (Preview) Export Query Results in Power BI Desktop unlocks seamless data portability and collaboration across Microsoft Fabric. This feature empowers analysts to take transformed, cleaned data from Power Query and export it directly to trusted destinations - such as Dataflows Gen2, Lakehouses, and other cloud stores - without relying on complex workarounds or third-party tools. By meeting users where they work (Power BI Desktop) it reduces duplication of effort, accelerates data sharing, and drives interoperability across Fabric workloads. To enable this feature, select the Preview feature settings in Power BI Desktop. Users can select export query results from the PQ ribbon, Select an online destination, And export their queries to this destination, where they can choose to modify the Dataflow. The result is improved data gravity in OneLake, streamlined refresh and monitoring capabilities, and a minimal-click experience that supports both new and existing destinations. Ultimately, this feature bridges the gap between desktop analytics and enterprise-scale data integration, enabling organizations to maximize the value of their data investments. To learn more about how to use this feature: Export Query Results in Power BI Desktop | Microsoft Learn. Other Power BI Desktop is now supported on ARM Power BI Desktop is now supported on Windows on ARM PCs that have the 2025-09 Cumulative Update installed (KB5065789). Adding ARM support to Power BI Desktop brings powerful data analytics capabilities to a broader range of hardware—unlocking faster performance, improved battery life, and seamless experiences on modern, energy-efficient devices. Why ARM? As more users adopt ARM-powered laptops and tablets for their portability and efficiency, it’s essential that Power BI keeps pace. ARM support ensures smoother operation, better resource utilization, and a future-ready foundation for data professionals working across diverse environments. Whether you're building dashboards on the go or analyzing data from anywhere, Power BI Desktop on ARM makes it easier than ever. Visualizations Sankey Chart by Powerviz The Powerviz Sankey Chart is a dynamic flow diagram that visualizes the proportional movement of data, resources, or processes across categories or stages. With weighted connections and flexible layouts, it helps users uncover insights within complex systems. Key Features Chart Orientation: Switch seamlessly between vertical and horizontal orientation. Node Customizations: Control node appearance, spacing, visibility, and interactions for optimal clarity. Multi-Level Support: Add multiple levels to visualize layered, hierarchical flows. Data Colors: Access 30+ color palettes, including colour-blind-safe options. Fill Patterns: Highlight nodes with patterns or upload your own. Conditional Formatting: Highlight outliers with based on measures or categories rules. Smart Labels: Display data and header labels for enhanced readability. Hide Null Nodes: Instantly remove nodes with null or blank data. Image Labels: Add image URLs to show visuals inside or outside the nodes. Import/Export: Save and reuse themes easily. Templates: Use built-in templates or design your own. Other features included are Sorting, Ranking, Show Condition, Grid View and more. Business Use Cases Customer Journey Mapping, Expense Breakdown, Supply Chain Flow. Try Sankey Chart visual for FREE from AppSource Check out all features of the visual: Demo_file Step-by-step instructions: Documentation YouTube Video: Video_Link Learn more about visuals: https://powerviz.ai/ Follow Powerviz: https://lnkd.in/gN_9Sa6U Your Timeline Slicer: Reimagining Date Filtering for Modern Dashboards What problem are we solving? Dashboard real estate is precious, but traditional timeline slicers often consume too much space while lacking the flexibility today's data professionals need. After experiencing firsthand the limitations and occasional bugs of existing solutions, we built Your Timeline Slicer from the ground up to deliver what the Power BI community has been asking for. Why Your Timeline Slicer changes the game Our visual combines the familiar timeline functionality you know with breakthrough space-saving design - reclaiming up to 60% more dashboard space through ultra-compact mode. Beyond size, we have intelligent features that make reporting effortless: dynamic ‘Current Period’ and ‘Latest Available’ filtering that automatically focuses on what matters most, extensive customization options to match any brand or style, and rock-solid performance. Whether you're building executive summaries, financial dashboards, or mobile-first reports, Your Timeline Slicer adapts to your workflow - not the other way around. Ready to experience the difference? Download Your Timeline Slicer from AppSource and discover how smart date filtering can transform your dashboards. Based On Website Drill Down Scatter PRO by ZoomCharts What if exploring complex data was as easy as scrolling a smartphone app? You could make smarter and more interactive reports that allow more people (managers, C-suite, and other stakeholders) to take part in data analysis themselves and quickly find the insights they need for data-driven decisions. When designing our Drill Down Scatter PRO, we focused on three things: Incredible user experience: Freeform panning. Click to drill down. Scroll or pinch to zoom in. Multiple ways to select data. Scatter PRO makes it easy for anyone to navigate even the most complex data. On-chart Drill Down: Have hundreds or even thousands of markers? No problem – you can simplify your chart by using multiple category fields and combine smaller data points into large markers. Simply click on it to drill down and see more detailed insights on-demand. Customization: Scatter PRO offers all the necessary tools to create the perfect scatter plot for your report. Regression lines, marker, label, legend customization, tooltip content fields, reference lines and areas, and even shaded areas at your selected coordinates! Read more in our blog article. Get Drill Down Scatter PRO Multiple Sparklines With the Multiple Sparklines visual, you can design an Income Statement that is both insightful and visually compelling. 1st column displays Profit and Loss as a waterfall chart. 2nd column shows each item as a percentage of Revenue (common-size analysis). The 3rd column presents the past five-year trend. 4th column compares each item with the previous year. The 5th column benchmarks result against two major competitors. For a step-by-step tutorial on how to create this type of Income Statement, visit: Income Statement in Power BI Following is another example of an Income Statement Download this visual from APPSOURCE For more information visit https://www.excelnaccess.com/sparklines/ or contact [email protected] Performance Bar by JTA Take your Power BI dashboards to the next level with the Performance Bar by JTA, a clean visual for tracking progress and status briefly. Categories are displayed as streamlined horizontal bars with an optional markers and value label, making comparisons effortless. With simple customization to match your theme - and an optional total bar - it delivers a clear, modern way to tell your performance story. Key Features Bar customization: Configure bar height, colors, borders, and background to match your report theme. Flexible labelling: Show or hide individual labels and choose their position for clear, uncluttered reading. Adjustable scale: Change the scale to emphasize what matters most. Marker styling: Personalize circle markers (size, color, border) for highlights and targets. Marker styling: Personalize circle markers (size, color, border) for highlights and targets. Total Bar: Optionally display a summary bar for an at-a-glance overall view. Configurable tooltips: Define exactly which fields appear and where tooltips show up. Subtle animation: Bring bars to life with a clean growth animation. Resources Explore more here. Also, if you want to download it, you can find the visual package on the AppSource. Financial Reporting Matrix v8.2 More control, customization, and clarity The Financial Reporting Matrix just got even better! With version 8.2.0.0, we’ve introduced powerful new features, expanded customization options, and refined the user experience to give report creators unprecedented control over their layouts, formatting, and interactivity. New in v8.2 RowHeaderParent() function – Reference parent rows in calculations and formatting. Invert Sign Factor – Quickly reverse value signs for reporting preferences. Row options in Conditional Formatting – make rules based on Inverted sign, allow drilling, and more. Comments everywhere – Add and format comments on row and column headers, and export to Excel with comments. Custom expansion icons – Change shape, color, size, and indentation. Pin Columns – Keep important columns visible when scrolling. Improvements Column header names showing in stepped layout. Hide empty rows with rendered measures in rows. JSON-based row options recognition. Smoother horizontal scroll for formula editing. Row subtotals fix for ‘In rows’ measure placement. Rename your Applied Steps. Change column expansion icon size. Get the latest version from AppSource BI Pixie by DataChant - Measure the Effectiveness of Your BI Assets in 6 Dimensions from Adoption to Security Since its launch 2024, BI Pixie has evolved from its initial adoption and engagement measurement offering an all-encompassing intelligence suite for organizations that want to maximize their return on investment in Power BI. BI Pixie now offers insights in six key dimensions: Adoption, Engagement, User Satisfaction, Business Outcome, Performance and Security. Here are the recent updates and new capabilities in BI Pixie. With its unique instrumentation technology, BI Pixie captures detailed auditing information, providing a comprehensive view of your BI audience and analytic assets. Designed to ensure your data stays in your organization and scale to tens of thousands of reports and users, BI Pixie can be deployed in your Azure tenant or Power Platform environment in minutes. Leverage the capabilities of BI Pixie to drive user adoption, reduce attrition, boost your data governance and optimize the impact of your BI initiatives with our unprecedented auditing and real-time detection of data leaks due to faulty implementations of Row-Level Security (RLS). Discover more by exploring BI Pixie Dashboard on Microsoft AppSource, and reach out for a free subscription. Closing This concludes this month’s update. We hope the information provided in this update is useful. If you installed Power BI Desktop from the Microsoft Store, please leave us a review. As always, keep voting on Ideas to help us determine what to build next. We are looking forward to hearing from you!Update to the Power BI Embedded Analytics Accelerators Program
Over a year ago we announced the availability of embedded analytics accelerators developed by our partners. These accelerators significantly reduce time-to-market for delivering self-service analytics solutions integrated into multi-tenant, customer-facing web applications. They also enhance the Power BI Embedded user experience by providing additional functionality. At the #FabCon 2025 last week, we celebrated the success of these partners and showcased the continued evolution of their accelerator offerings. Today, we are excited to announce several key expansions to the Embedded Analytics Solution Accelerators Partner Program: New Partner Accelerator: We’re pleased to introduce: Entelexos developed by Carlo consulting. This new accelerator provides tenant-specific white labeling. It also empowers users to create paginated, table-formatted reports directly from a Power BI semantic model perspective. The resulting paginated report can be used to download unrestricted amount of data directly from the model. Watch their demo video here. New and Enhanced Capabilities from Existing Partners EmbedFast by MAQ Software EmbedFast has received major updates, including: A fully supported front-end experience as part of the accelerator The ability to download up to 1 million rows of data from a visual to Excel, on-demand or scheduled A semantic model editing experience with AI-assisted DAX expression building New AI-powered chat functionality for generating insights and ad-hoc visualizations Watch their demo video here. Reporting Hub by Reporting Hub Inc Reporting Hub highlighted a customer success story at the conference - a deployment completed by the customer within hours as a white-labeled analytics module for their accounting solution. In addition to features like tenant-specific authentication, white labeling, and multi-language support, Reporting Hub also announced: Upcoming AI product integration New APIs for scalable deployments and process automation Strategic partnerships for industry-specific accelerator solutions in Healthcare, Automotive, Accounting/Finance, and HR Watch their demo video here. EmbeDash by iLink Digital EmbeDash has been enhanced to include the following capabilities: The option to integrate its frontend as an iFrame in an existing web application The ability for an end user to schedule report printouts Tenant-specific white labeling and authentication Watch their demo video here. Learn More Explore the following resources to dive deeper into these partner accelerators: Embedded analytics solution accelerators from Microsoft partners - overview that includes an architectural diagram and links to each offering on the Azure Marketplace. Microsoft Partner Showcase - Embedded Analytics Solution Accelerators - Interview recordings with partner representatives who demonstrate their solutions. Stay tuned to the Partner Showcase site for more video content highlighting the latest updates to our accelerators.
Power BI August 2024 Feature Summary
Welcome to the August 2024 update. Here are a few, select highlights of the many we have for Power BI. You can now ask Copilot questions against your semantic model. Updated Save and Upload to OneDrive Flow in Power BI and Narrative visual with Copilot is available in SaaS embed. There is much more to explore, please continue to read on! European Fabric Community Conference Join us at Europe’s first Fabric Community Conference, the ultimate Power BI, Fabric, SQL & AI learning event in Stockholm, Sweden from September 24 -27, 2024. With 120 sessions, daily keynotes, 10 pre-conference workshops, an expo hall with community lounge, and “ask the expert” area, the conference offers a rich learning experience you don’t want to miss. This is a unique opportunity to meet the Microsoft teams building these products, customers betting their business on them, and partners at the forefront of deployment and adoption. Register today using code MSCUST for an exclusive discount! Attention Power BI users! If you are accessing Power BI on a web browser version older than Chrome 94, Edge 94, Safari 16.4, Firefox 93, or equivalent, you need upgrade your web browser to a newer version by August 31, 2024. Using an outdated browser version after this date, may prevent you from accessing features in Power BI. Version number: v: 2.132.908.0 Date published: 8/19/24 Contents Copilot and AI Ask Copilot questions against your semantic model (preview) We are pleased to announce that you can now ask Copilot for data from your entire semantic model in Desktop! Just tell Copilot what you’re looking for, and Copilot will query your model to answer your question with a visual. To use this new capability, you need to have the Preview feature for “Copilot chat pane in report view” turned on. If you already have done this there is nothing else that you to need to utilize this new capability. To find out more about how this feature works and the types of questions that are supported check out our previous blog post and documentation page. Reporting Visual level format strings (preview) Visual level format strings are here, providing you with more options to configure formatting. Originally built for visual calculations, the core ability that visual-level format strings provide is the ability to format visual calculations. Since visual calculations are not in the model, you could not format them, unless you were using them in data labels or in specific parts of the new card and new slicer visuals. With visual level format strings, you can! Visual level format strings, however, are useful even without using visual calculations. With the introduction of visual-level format strings, Power BI now has three levels for format strings: Model. You can set a format string for columns and measures in the model. Anywhere you use that column or measure the format string will be applied, unless it’s overridden by a visual or element level format string. Visual. This is what we’re introducing today. You can set format strings on any column, measure or visual calculation that is on your visual, even if they already had a format string. In that case the model level format string will be overridden, and the visual level format string is used. Element. You can set a format string for data labels and for specific elements of the new card and the new slicer visuals. This level will be expanded to include much more in the future. Any format string you set here will override the format string set on the visual and model level. These levels are hierarchical, with the model level being the lowest level and the element level the highest. A format string defined on a column, measure or visual calculation on a higher-level override what was defined on a lower level. Since visual calculations are not in the model, they cannot have a format string set on the model level but can on the visual or element level. Measures and columns can have format strings on all three levels: Level Impacts Available for Measures, columns Visual calculations ELEMENT Selected element of the selected visual X X Visual Selected visual X X Model All visuals, all pages, all reports on the same model X The image below summarizes this and shows that higher level format strings override lower-level format strings: Let’s look at an example using a measure. I have a Profit measure in my model, which is set to a decimal number format. To do this, you might have set the formatting for this measure using the ribbon: Alternatively, you could have made the same selections in the properties pane for the measure in the model view or entered the following custom formatting code: If you put this measure on a visual it now returns a decimal number, as expected: However, on a particular visual you want that measure to be formatted as a whole number. You can now do that by setting the format code on the visual level by opening the format pane for that visual and the Data format options found there under General: Now that same measure shows as a whole number, but just on that visual: On top of that, you might want to use a scientific notation for that measure but only in the data label on a particular visual. No problem, you set the format code on the data label for that measure: So now the total shows in scientific notation, but only in the data label and not in other places (such as the tooltip as shown below). Notice how the element level format is used in the data label but the visual or model level format string is still used for the other elements in the same visual. For visual calculations the same principle applies but of course without the model level. For example, if you have a visual calculation that returns a percentage, you can now format it as such using the Data Format options in the General on the visual in the format pane: The ability to set visual level format strings makes it much easier to get the exact formatting you need for your visualizations. However, this is only the first iteration of the visual level format strings. We are planning to add the settings you’re used to for the model level format strings to the visual level soon. Since visual level format strings are introduced as part of the visual calculations preview, you will need to turn on the visual calculations preview to use them. To do that, go to Options and Settings > Options > Preview features. Select Visual calculations and select OK. Visual calculations and visual level format strings are enabled after Power BI Desktop is restarted. Please refer to our docs to read more about format strings or visual calculations. Dynamic per recipient subscriptions (Generally Available) We are excited to announce the general availability of Dynamic per recipient subscriptions for Power BI and paginated reports. Dynamic per recipient subscriptions is designed to simplify distributing a personalized copy of a report to each recipient of an email subscription. You define which view of the report an individual receives by specifying which filters are applied to their version of the report. The feature is now available in Sov. Clouds as well. Create a dynamic per recipient with a simple drag and drop experience. First, subscribe to the report by selecting “Subscribe to report”, then “Create Subscriptions”. Select “Dynamic per recipient” subscription. Connect to data that has recipient email, names or report parameters. Then, select and filter data that you want in your subscription. You probably only want to send emails conditionally. To do that, you can filter the data in the “Filter” pane. You can select the recipient email addresses and the email subject from the dataset that you connected to by selecting “Get Data”. You can then map your data to the subscription. Then schedule the subscription and save it. The subscriptions will be triggered based on the schedule that you have set up. Personalized reports can be sent to up to a thousand recipients! Learn more about Dynamic per recipient subscriptions for Power BI reports, and paginated reports. Deliver subscriptions to OneDrive and SharePoint (Generally Available) Do you have reports that are too large to be delivered by email? Do you have reports that are eating into your email in just a few weeks, or do you need you to move it to a different location? You can now deliver Power BI and paginated report subscriptions to OneDrive or SharePoint. With this capability, you can schedule and send full report attachments to a OneDrive or SharePoint location. Learn more about how to deliver report subscriptions to OneDrive or SharePoint. Updated Save and Upload to OneDrive Flow in Power BI Beginning the first week of August, desktop users should see a preview switch starting in SU8 to turn on the updated Save and Upload to OneDrive experience in Power BI. To enable this, navigate to the Preview features section of Options in Power BI. Users will then need to select “Saving to OneDrive and SharePoint uploads the file in the background”. With these updates, we’ve improved the experience of uploading new Power BI files to OneDrive, and easily upload new changes in the background. Preview switch that needs to be selected. For uploading new files, after navigating to the correct location in the OneDrive file picker and saving, a dialog box appears while the file is being uploaded. The option to cancel the upload is there if needed. This dialog will only show up the first time a new file is uploaded to OneDrive. Dialog for saving a new file to OneDrive. When new changes are saved to a file uploaded to OneDrive, the top of the toolbar indicates that the new changes are also being uploaded to OneDrive. Additional changes being uploaded in the background to the existing file. If you click on the title bar flyout in the toolbar, you can also now access more information about the file. Clicking “View your file in OneDrive” will provide a direct link to where the file is stored in OneDrive. Drop down including the link to the file in OneDrive. Data limit We are introducing the data limit capability to help you manage performance issues. This feature allows you to set the maximum data load for a single session per visual displaying only the rows of data in an ascending order by default. To use this feature: Go to the 'Filters on this visual' menu in the filter pane. Click on the data limit menu to open a new filter card. Set your desired data limit value. The filter card features include: Removing, locking, or clearing filters. Hiding or showing filters. Expanding or collapsing filter cards. Applying filters. Renaming and reordering filters. Report consumers can see any data limits applied to a visual in the filter visual header, even if the filter pane is hidden. Visuals, shapes and line enhancements Over the past few months, we have been fine-tuning the visual elements of your reports, including columns, bars, ribbons, and lines. We have given you the ability to craft these Cartesians with precision. However, we noticed that the legends and tooltips were not quite accurate. With the latest update, the legend and tooltip icons will now automatically and accurately reflect per-series formatting settings, such as border colors, shapes, and line styles. This makes it easier to match series to their visual representations. Additionally, we have added consistency to how per-series formatting is applied to line charts, column/bar charts, scatter charts, and other Cartesian formatting options for common items like error bars and anomalies. Check out the Reporting demos here: Modeling DAX query view in the web Write DAX queries on your published semantic models with DAX query view in the web. DAX query view, already available in Power BI Desktop, is now also available when you are in the workspace. Look for Write DAX queries on your published semantic model. Right-click on the semantic model and choose Write DAX queries. Click on the semantic model to open the details page, then click Write DAX queries at the top of the page. This will launch DAX query view in the web, where you can write DAX queries, use quick queries to have DAX queries written for you on tables, columns, or measures, or use Fabric Copilot to not only write DAX queries but explain DAX queries, functions, or topics. DAX queries work on semantic models in import, DirectQuery, and Direct Lake storage mode. Write permission, that is permission to make changes to the semantic model, is currently needed to write DAX queries in the web. And, the workspace setting, User can edit data models in the Power BI service (preview), needs to be enabled. DAX query view in the web includes DAX query view’s way to author measures. Define measures with references, edit any of them, and try out changes across multiple measures by running the DAX query, then update the model with all the changes in a single click of a button. DAX query view in web brings this functionality for the first time to semantic models in Direct Lake mode! If you do not have write permission, you can still live connect to the semantic model in Power BI Desktop and run DAX queries there. Try out DAX query view in web today and learn more about how DAX queries can help you in Power BI and Fabric. Deep dive into DAX query view in web DAX queries Work with DAX query view Deep dive into DAX query view and writing DAX queries Write DAX queries with Copilot Deep dive into DAX query view with Copilot Overview of Copilot for Power BI Direct Lake Check out a Modeling demo here: Embedded Analytics Narrative visual with Copilot available in SaaS embed We are excited to announce that the Narrative visual with Copilot is available for user owns data scenarios (SaaS) and secure embed. This means when a user embeds a report containing the narrative visual in a solution where users must sign in – they will now be able to the visual refresh with their data. The first step on our Copilot embed journey! When you embed a Power BI report in an application in the "embed for your organization" scenario, it allows organizations to integrate rich, interactive data visualizations seamlessly into their internal tools and workflows. Now this solution supports the Copilot visual. A sales team might want to embed a Power BI report in their internal CRM application to streamline their workflow. By integrating sales performance dashboards directly into the CRM, team members can easily monitor key metrics like monthly sales targets, pipeline status, and individual performance, without switching between different tools. This integration enables quicker access to actionable insights, helping the team make informed decisions, identify trends, and react swiftly to market changes, all within the secure environment of their organization's data infrastructure. Supported Scenarios: Embed a report in a secure portal or website Power BI. User owns data: A user embeds a report containing the narrative visual in a solution where users must sign in. They need a license to do so. This action is also known as embed for your organization. It includes when users want to embed visuals in solutions like PowerPoint as well. Unsupported Scenario: App owns data: A customer embeds a narrative visual on a website where users visit, and don't need to sign in. Also known as embed for your customer's application. To get this set up, there are a few steps to follow - so make sure to check out the documentation. Embed a Power BI report with a Copilot narrative visual - Power BI | Microsoft Learn You will need to Edit your Microsoft Entra app permissions to enable the embedded scenario to work. From here you’ll need to add the MLModel.Execute.All permission. Once you do that, your visual should work in your embedded experiences where users still sign in. Check out the documentation for additional details. Check out an Embedded Analytics demo here: Visualizations Editor’s pick of the quarter Icon Map Pro hi-chart Reporting Studio Water Cup Performance Flow - xViz Sunburst by Powerviz Zebra BI Tables 7.0 Enlighten Storyteller Inforiver Writeback Matrix Drill Down Pie PRO (Filter) by ZoomCharts (microsoft.com) Spiral Plot By Office Solution Polar Scatter Plot By Office Solution Hanging Rootogram Chart for Power BI Bar Chart Run Time Convertible Scatter Plot Circular Dendrogram Chart for Power BI Barley Trellis Plot By Office Solution Connected Scatter Plot Chart For Power BI Dot Plot Chart by Office Solution Voronoi Diagram By Office Solution Fish Bone Chart for Power BI Icon Array Chart for Power BI New visuals in AppSource Image Skyline StackedTrends Visual Bubble Diagram Chord Diagram Non-Ribbon Chord Diagram Filter by Powerviz Powerviz Filter is an advanced Power BI slicer (Free Visual) that applies a page-level filter to the data. It stands out for its user-friendly design and customization flexibility, with developer-friendly wizard. Key Features: Hierarchy Control: Support multiple hierarchies with expand/collapse and by-level formatting Ragged Hierarchy Support: Hide BLANK category/values, or both, and display child as parent. Keep selected items at Top: enable this to show your selected items at top. Display Mode: Seamlessly switch between pop-up/canvas modes. Default Selection: Select default categories/values that automatically get filtered on refresh. Selection Mode: Single-select, multiple-select, or select-all with only single-selection. Image: Add images alongside the filter. HTML Links/Base-64 URLs Support. Title-Bar Options: Search Bar, Clear Icon, Ranking, Filter, Sorting, Expand/Collapse. Conditional Formatting: Highlight font and row background color based on specific rules. Template: Choose from professionally created light/dark templates, and easily customize them using the Global styling option. Other features included are Import/Export Themes, Interactivity, Filter Style, and more. Business Use-Cases: Sales Analysis, Marketing Performance tracking, Financial Monitoring 🔗 Try Filter Visual for FREE from AppSource 📊 Check out all features of the visual: Demo_file 📃 Step-by-step instructions: Documentation 💡 YouTube Video: Video_Link 📍 Learn more about visuals: https://powerviz.ai/ ✅ Follow Powerviz: https://lnkd.in/gN_9Sa6U Pie of Pie by JTA Slice to Spice: Transform your Pie Chart by Clicking! Dive deeper with a click, creating a new pie! Pie of Pie by JTA - a Data Scientist's Visualization Tool Slice, Click, Reveal: Explore Deeper Insights with Our Interactive Pie Chart Visual for Power BI! Overview A Power BI custom visual that enables the creation of a hierarchical representation within a Pie Chart. With a simple click, you can effortlessly delve into detailed categories, offering a seamless and visually intuitive way to unveil multi-level insights in a single view. Experience the convenience of interactive data analysis, where each slice of the initial pie chart acts as a gateway to deeper layers of information. Whether you're dissecting population demographics, dissecting sales performance, or analysing product distribution, Pie of Pie offers a seamless and visually intuitive solution. Key Features: Interactive hierarchical representation within a Pie Chart: Dive into detailed categories with ease, exploring multi-level insights seamlessly. Effortlessly explore multi-level insights with a single click: Click on a slice to reveal deeper layers of information, enhancing your data analysis experience. Customizable colours, labels, and legend: Tailor the visual to match your branding or personal preferences, ensuring clarity and consistency in your reports. Choose where to display always both pies and just show the second upon click: Optimize your visual presentation by selecting the most suitable display mode for your data storytelling needs. Animate the visual: Bring your data to life with smooth animations, captivating your audience and enhancing engagement with your insights. Personalize the spacing: Fine-tune the spacing between elements to achieve the perfect balance of aesthetics and readability in your visualizations. Download Pie of Pie by JTA for free: AppSource Try Pie of Pie by JTA: Demo Youtube video: Youtube Learn more about us: JTA The Data Scientists Drill Down Pie PRO by ZoomCharts Everyone knows what a pie chart is – for centuries, it has been the most popular way to visualize data. But what makes Drill Down Pie PRO special is the incredible amount of flexibility it offers to creators. Enjoy a wide range of customization features (colors, fonts, legends, labels, and more), create up to nine levels of drill down hierarchy, and declutter the chart with an interactive ‘Others’ slice that users can expand with just a click. What’s more, this visual can be more than just a pie chart – it can be an interactive navigation tool for the entire report. When the user selects a slice or drills down, it will cross-filter other visuals on the report, instantly revealing focused insights. Create faster, more intuitive, and more insightful reports with ZoomCharts! Main Features: On-chart drill down Cross-chart filtering Up to 9 levels of hierarchy Adjustable ‘Others’ slice Color, label, and legend customization Custom tooltip fields Touch support 🌐 Get Drill Down Pie PRO on AppSource Product Page | Documentation | Follow ZoomCharts on LinkedIn Hierarchical Bar Chart Hierarchical bar chart displays hierarchical data (different fields having parent/child relationship) in the form a bar/column chart with +/- signs to view/hide details or child elements. A new feature was added to the visual in Jun 24 whereby the users can display CAGR between the 2 values by clicking the bars one after another (after turning on “CAGR” from format pane). This visual has the following key features. 1) Expand/ Collapse bars using (+/-) buttons 2) Show variance between bars 3) Show CAGR between bars 4) Drag the bars for custom sorting 5) Click on legends to drill down/up to any level 6) Show targets Watch a demo of these features in short video below https://www.youtube.com/watch?v=kOcs5RNY-Zs Download this visual from APPSOURCE Download demo file from APPSOURCE For more information visit https://www.excelnaccess.com/hierarchical-barchart/ or contact [email protected] Deneb: Declarative Visualization in Power BI Deneb is a free and open-source certified custom visual that allows developers to create their own highly bespoke data visualizations directly inside Power BI using the declarative JSON syntax of the Vega or Vega-Lite languages. This is like the approaches used for creating R and Python visuals in Power BI, with the following additional benefits: Everything in-visual—no additional dependencies on local libraries or gateways for your end-users when publishing reports. Microsoft certified runtime—any visual you create receives the same benefits of a certified custom visual, meaning your design will work anywhere Power BI works, including Publish to Web, mobile, PowerPoint, and PDF exports. Performance—your designs are rendered directly inside Power BI rather than being delegated to another location, keeping data inside your workbook and typically resulting in faster render times for end-users. Interactivity—You can integrate Power BI's interactivity features (tooltips, Drillthrough, cross-filtering, and cross-highlighting with some additional setup. 📢Our latest version brings many of our top requested new features to the development experience, including: Dark mode—toggle between the traditional light theme and dark theme to reduce eye strain. Commenting—you can now add comments to your JSON for documentation and debugging purposes. Auto-completion improvements—suggestions will now be recommended based on the details in the Vega and Vega-Lite schemas. Inline language documentation (for Vega-Lite)—the documentation the Vega team makes available for Vega-Lite in its language schema is now available when you hover your mouse over an appropriate location in your JSON. This will help you discover more language features within Deneb itself, and any hyperlinks will navigate you to the correct location on the Vega-Lite documentation site for further reading. Auto unit formatting—a new format type that applies the same logic as Power BI format numbers in K, M, Bn, etc., with less effort than the existing Power BI value formatter. Advanced cross-filtering (for Vega)—new expression functions to help generate cross-filtering of report items based on a filter against the original dataset sent to Deneb before any transformations may have been applied. We have many other enhancements in this release, and you can find out more about how these can help you and your readers by: Visting the Change Log on Deneb’s website Checking out our YouTube spotlight videos on key new features Downloading Deneb from AppSource Getting inspired by examples from our community or the sample workbook Following Deneb Other Paginated Reports: Sharing of reports connecting to Get Data data sources made easy We announced the ability to create paginated reports from Power BI Report Builder by connecting to over 100 data sources with the Get Data experience. You can learn more about Connect paginated reports to data sources using Power Query (Preview) - Power BI | Microsoft Learn. You no longer need to share the shareable cloud connection. You only need to share the report and ensure that those consuming the report have access to view the report. This update will be rolling out in the coming weeks. Fabric Sticker Challenge Winners Announced! The Fabric Community Sticker Challenge launched August 1-23 and winners are in! All Fabric Community members were invited to create unique stickers showcasing their enthusiasm and creativity under the following categories: Community Enthusiasm, Inspirational, “Inside Joke” for developers and data, and Super Users. To see winning designs, check out our Community News. Thank you all who participated in this challenge; it was great to see so much involvement! Fabric Influencers Spotlight Check out our latest initiative, the Fabric Influencers Spotlight. Each month, we’ll be highlighting some of the great blog, videos presentations and other contributions submitted by members of Microsoft MVP & Fabric Super User communities that cover the Fabric Platform, Data Engineering & Data Science in Fabric, Data Warehousing, Power BI, Real-Time Intelligence, Data Integration, Fabric Administration & Governance, Databases and Learning. That is all for this month! We hope that you enjoy the update! If you installed Power BI Desktop from the Microsoft Store, please leave us a review. As always, keep voting on Ideas to help us determine what to build next. We are looking forward to hearing from you!Accelerating Embedded Analytics for Your Application
We are delighted to announce the availability of embedded analytics accelerators developed by our partners. These accelerators significantly shorten the time-to-market for self-service analytics experiences that are integrated into customer-facing applications. Power BI supports multiple embedding scenarios, offering rich functionality. The "Embedding for your customers" scenario offers the highest degree of authentication and authorization flexibility for Independent Software Vendors (ISVs). This scenario enables ISVs to keep their existing end-user authentication provider while facilitating customized access control for Power BI items and a highly scalable multitenant implementation. However, leveraging this flexibility involves writing code to utilize the comprehensive Power BI APIs, both to develop the desired front-end user experiences and to create the back-end modules that supports these experiences. Designed for ISVs and enterprises with similar needs, the new partner accelerators deliver a personalized user experience straight out of the box while simplifying the implementation process. They either eliminate the need for coding or significantly reduce the coding effort by providing back-end and admin modules, allowing for a focus on the custom implementation of the application's front-end embedded analytics experiences. These accelerators can be easily purchased and self-deployed from the Azure Marketplace into your Azure environment, making use of your Microsoft Fabric service tenant with Power BI workload. Developed by our partners following product group best practices and guidance, these accelerators offer scalable multitenancy and a comprehensive range of ready-to-use functionalities, customization and integration options designed to meet a variety of customer needs. Find out the details about these accelerators from our partners by exploring the following resources: Embedded analytics solution accelerators from Microsoft partners - An overview and schematic architecture, including links to the accelerators' Azure Marketplace offerings. Microsoft Partner Showcase - Embedded Analytics Solution Accelerators - Interview recordings that describe each accelerator and the associated partner program. If you are attending the Microsoft Fabric Community Conference, we invite you to join us for the session: "Accelerate Fabric Embedded Analytics for Your Applications." In this session, we will delve into and discuss the details of the accelerators and the program that facilitated our collaboration with these partners.Power BI Embedded with Microsoft Fabric
With the release of Microsoft Fabric, ISVs and application developers using Power BI embedded can now leverage new capabilities of Microsoft Fabric, all while maintaining their Power BI embedded solutions and using the Power BI REST APIs. In this post, we’ll discuss the value of Microsoft Fabric for embedded solutions and give you all the details on how to get started with Microsoft Fabric and Power BI embedded. About Microsoft Fabric Microsoft Fabric is an end-to-end, unified analytics platform that brings together all the data and analytics tools that organizations need. Fabric integrates technologies like Azure Data Factory, Azure Synapse Analytics, and Power BI into a single unified product, empowering data and business professionals alike to unlock the potential of their data and lay the foundation for the era of AI. Read the full release update here. About Power BI embedded Power BI embedded analytics allows you to embed your Power BI items such as reports, dashboards and tiles, in a web application or in a website. You can: Deliver compelling data experiences for your end users, enabling them to take action based on insights from your solutions data. Quickly and easily provide exceptional customer-facing reports, dashboards, and analytics in your own apps by using and branding Power BI as your own. Capacity and SKUs updates for Power BI embedded analytics Until today, Power BI embedded analytics offered two publishing solutions, each with different SKUs. Power BI Embedded - an Azure offering aimed at ISVs and developers, using A SKUs Power BI Premium - a Microsoft Office offering that includes embedding Power BI, geared toward enterprises looking for a complete BI solution, using EM or P SKUs With the introduction of Microsoft Fabric, we're excited to inform you that embedding Power BI is now also available with all the new Microsoft Fabric capacities. Power BI embedded with Microsoft Fabric Capacities (F SKUs) Microsoft Fabric capacities allow you to create and share Fabric content and leverage Fabric for your applications. Microsoft Fabric provides all the capabilities required for a developer to extract insights from data and present it to the business user, whether it is within Fabric or embedded in external applications. Microsoft Fabric capacities come in a wide range of SKUs, each with different resource tiers for memory and computing power, so you can find the SKU that best fits your application needs. Embedding Power BI artifacts is supported with the whole range of F SKUs. Read more about the different available licenses here. Just like the familiar A SKUs, F SKUs can be used for as long as you want without any commitment. Pricing is regional and billing is made on a per second basis with a minimum of one minute. Some additional capabilities with F SKUs include: Pay as you go with no time commitment. You can scale your capacity up or down using the Azure portal. You can pause and resume your capacity as needed. Fabric capacities also offer a lower entry level, which can be ideal for ISVs and smaller organizations looking to explore Microsoft Fabric and embedded analytics with Power BI. Meanwhile, the higher-level F SKUs allow free users to view Shared Power BI items in any workspace that has such a capacity assigned to it. During the preview of Microsoft Fabric, you can also enjoy the Microsoft Fabric (Preview) trial, which includes access to the Fabric product experiences and the resources to create and host Fabric items. The Fabric Trial is available for 60 days and can be upgraded to a Fabric capacity once the trial runs out. Once your workspace is upgraded to a trial capacity, you can embed any Power BI item in the workspace just like you could with an A or P SKU previously. Power BI embedded with A SKUs Power BI embedded continues to work smoothly with A SKUs, regardless of whether Microsoft Fabric has been enabled in the organization or not. This means that you can freely explore Microsoft Fabric in other workspaces, while maintaining your existing A SKU assigned workspaces used for embedding. However, keep in mind that A SKUs do not support Microsoft Fabric. If you wish to create Fabric items in an A SKU workspace, you will be prompted to migrate the workspace to a Fabric capacity or Fabric Trial. Additionally, you will not be able to reassign workspaces with Fabric capacities or a Fabric Trial that include Fabric items to an A SKU. Git Integration Another exciting release with Microsoft Fabric is git integration, which enables developers to integrate their development processes, tools, and best practices straight into Microsoft Fabric workspaces. For Power BI embedded users, this introduces a whole new way to easily manage and control versions of embedded reports. You’ll be able work in Power BI desktop to develop your Power BI reports and datasets, and check in your changes to git to collaborate and manage your Power BI content as you do with your app’s code. From there you can sync the content back to your Fabric workspace to ensure everything stays up to date. Read the full release update here. Get started with Microsoft Fabric Microsoft Fabric is currently in preview. Try out everything Fabric has to offer by signing up for the free trial—no credit card information required. Everyone who signs up gets a fixed Fabric trial capacity, which may be used for any feature or capability from integrating data to creating machine learning models. Existing Power BI Premium customers can simply turn on Fabric through the Power BI admin portal. After July 1, 2023, Fabric will be enabled for all Power BI tenants. Sign up for the free trial. For more information read Fabric trial docs. Other resources If you want to learn more about Microsoft Fabric, consider: Signing up for the Microsoft Fabric free trial Visiting the Microsoft Fabric website Reading the more in-depth Fabric experience announcement blogs: Data Factory experience in Fabric blog Synapse Data Engineering experience in Fabric blog Synapse Data Science experience in Fabric blog Synapse Data Warehousing experience in Fabric blog Synapse Real-Time Analytics experience in Fabric blog Power BI announcement blog Data Activator experience in Fabric blog Administration and governance in Fabric blog OneLake in Fabric blog Microsoft 365 data integration in Fabric blog Dataverse and Microsoft Fabric integration blog Exploring the Fabric technical documentation Reading the free e-book on getting started with Fabric Exploring Fabric through the Guided Tour Watching the free Fabric webinar series Joining the Fabric community to post your questions, share your feedback, and learn from others Visiting Microsoft Fabric Ideas to submit suggestions for improvements and vote on your peers’ ideas To learn more about Power BI embedded, consider: Exploring the Power BI Embedded Playground Power BI embedded analytics overview - Power BI | Microsoft Learn GitHub - microsoft/PowerBI-Developer-Samples: A collection of Power BI samples for developer use.Create Power BI reports in Jupyter Notebooks
Introducing a Game-Changing Update to the Power BI and Jupyter Notebook Library: Create Compelling Power BI Reports Directly in Your Notebook! In today's world where data is everywhere, we understand the importance of easy-to-use data visualization and analysis in gaining insights and making informed decisions. That's why we are excited to announce the latest update to the Power BI and Jupyter Notebook library, which empowers users to create powerful reports based on their data directly in their notebooks, without leaving their workflow. With this new update, users can gain insights instantly without the hassle of switching between tools or dealing with cumbersome data exports. Create a Power BI report in a Jupyter Notebook The updated Power BI Client for Jupyter is available on PyPI. The open-sourced Python package, as well as the complete documentation and demos can be found on GitHub. How to create a report in a Jupyter Notebook The process is simple. Start by installing powerbiclient using pip, and then import into your notebook the relevant models from the package, pandas for working with DataFrames, and any other modules you need for your data processing. from powerbiclient import QuickVisualize, get_dataset_config, Report from powerbiclient.authentication import DeviceCodeLoginAuthentication import pandas as pd Then, create a pandas DataFrame from your data, perform any necessary preprocessing, and authenticate to Power BI using our provided authentication class. With your DataFrame and authentication in place, you can now create a Power BI report instance, which will auto-generate a Power BI report from your data within seconds. # Create a Power BI report from your data PBI_visualize = QuickVisualize(get_dataset_config(df), auth=device_auth) # Render the new report PBI_visualize The generated report will include interactive and visually appealing visualizations, allowing you to easily tell the story of your data in a compelling way. You can customize the report further by editing the visuals and saving them as needed, or selecting different fields to take part in the data visualizations. Edit the auto-generated report Next steps Once you’re happy with your report, you can keep it in the notebook, or manually save the generated reports to share them with your team or organization in Power BI for wider consumption. This allows for seamless collaboration and empowers you to fully utilize the capabilities of Power BI for data analysis and visualization. The saved report can also be loaded in the notebook or in any other notebooks using the existing Power BI and Jupyter library. With this latest update to the Power BI Jupyter Notebook library, you can now unlock the true potential of your data analysis workflow. Gain insights instantly without hassle, and create visually stunning reports right in your notebook where your data is. Try it out today and revolutionize your data visualization workflow with Power BI in Jupyter Notebook!
Empower your application users to quickly explore their data with the new Power BI Embedding capabilities
We’re excited to announce a new form of Power BI embedded analytics that enables you to embed an interactive data exploration and report creation experience in your applications. With this solution, you’ll be able to provide your users a similar experience to our integrations in Dynamics 365 and SharePoint. By using this new set of Power BI client APIs, your application can pass in data source information, and Power BI will automatically generate a dataset and report for your users to explore, modify, and if they choose, save to a workspace in their Power BI tenant. To set this up, you’ll need to create a configuration object to store information about your data source and customize the report that’s initially created. As part of this, you’ll be able to pick how you want to connect your app’s data to Power BI. You can either pass an array of data directly to Power BI, or you can use a Power Query connector by passing in a mashup document. Passing in the data directly is a very easy way to get started. It’s aimed at smaller amounts of data, up to 16MB in size, and doesn’t require you to develop your own connector. Since you’re passing in the data directly, it’s not refreshable in the future, so more suited towards enabling your users to explore their data to answer a point in time question. You’ll pass in data as rows using a simple format, for example: const data: IDataTable = [ { "name": "Table", "rows": [ ["Product1", "20", "2022"], ["Product2", "35", "2021"], ] } ] In addition to name and dataType, you can specify default aggregation on columns by providing an optional property aggregateFunction for each column. The number for supported aggregate functions are based on the AggregateFunction Enum type. You can see the full details of how to use this configuration option in "Create a dataset without a data source" section of our documentation. On the other hand, by using a data connector, you’ll be able to enable your users to create refreshable, reusable reports and datasets. This route requires you to create a Power Query connector or expose your data through one of our existing data connectors, but users will be able to visualize much more data and return to their reports in the future to see the latest data. We currently support anonymous data connections or authenticating with AAD tokens, and in the future, we’ll enable support for other authentication methods. To use this method, you’ll just need to pass in a mashup document and the data model configurations, for example: const datasetCreateConfig: IDatasetCreateConfiguration = { "modelName": "temp model", "locale": "en_US", "mashupDocument": "section Section1; shared Table = let Source = Csv.Document(Web.Contents(\"https://yourdomain.com/sample.csv\"),[Delimiter=\",\", QuoteStyle=QuoteStyle.None]), #\"Promoted Headers\" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]) in #\"Promoted Headers\";", "dataSourceConnection": { "credentialType": CredentialType.Anonymous, // =1 "dataCacheMode": DataCacheMode.Import // =1 } } You can see the full details of how to use this configuration option in "Create a dataset with your existing data source" section of our documentation. This new embedding option is a form of SaaS embedding, so your app users will need to sign into their own Power BI account to generate the report and dataset. This means it’s free for you to include in your application. While your users will need to sign up for Power BI, if they don’t already have an account, they’ll only need to have a free license to explore their data and save it into their personal workspace. We hope this new embedding option gives you more flexibility when integrating with Power BI and an easy option to start offering data exploration and report creation capabilities to your users. To see full details, be sure to check out our API documentation and detailed tutorial. And of course, let us know if you have any feedback or questions in the comments!
Building Multi-language Reports for Power BI in 2023
It just got easier to create multi-language reports for Power BI. This is the result of several new enhancements to Power BI which simplify the process of localization and adding support for secondary languages. First, Power BI recently added an essential function in DAX named USERCULTURE which provides the ability to write measures which implement report label translations dynamically. Second, there are many properties for report visuals and shapes that can now be bound to measures which implement dynamic translations. Third, Power BI recently introduced a powerful, new feature named Field Parameters which offer a much better foundation for implementing data translations. I am happy to announce we've just released new guidance for building multi-language reports that embraces these new Power BI enhancements. This guidance has been designed to teach content creators using Power BI Desktop the skills required to add translations and multi-languages support to PBIX project files. You just need to learn a few key concepts about how Power BI translations work and you need to learn how to automate repetitive tasks that would take forever to complete manually. Once you understand how all the pieces fit together, you’ll be able to build multi-language reports for Power BI using a strategy that is reliable, predictable and scalable. We understand that people have different learning styles. Some people like to read technical articles. Some like to watch videos. Others learn by doing such as working through a challenging set of hands-on lab exercises. That's why we have created three different ways for you to learn the skills you need to build multi-language reports. Building Multi-language Reports in Power BI (Guidance document) Hands-on Lab: Building Multi-language Reports for Power BI Building Multi-language Reports for Power BI in 2023 (YouTube Video Playlist) We also published a live demo of a multi-language report which supports 12 secondary languages so you can see for yourself what is possible. There will also be a live Power BI Dev Camp session on this topic running this week on Thursday, January 26th as 2:00 PM EST. You can find more info about this week's Power BI Dev Camp session here.Dataset refresh cancellation is now available in Power BI Premium
We are excited to share that cancelling an in-progress dataset refresh in Power BI Premium, Power BI Premium Per User, and Power BI Embedded just got significantly easier. A top-20 idea on Power BI Ideas (we do listen and appreciate your feedback), we acknowledge that this capability couldn’t have come soon enough for our customers. In the past, cancelling an ongoing refresh was an unreliable process that required external tools. Earlier this year, we released the Enhanced refresh with Power BI REST API, that – in addition to XMLA based refreshes – allows refresh cancellation. However, it requires the refresh operation to be triggered by the API. Today, users can cancel an ongoing scheduled or on-demand refresh using a contextual button in the Power BI service. Earlier limitations that constrained cancellation no longer apply. To begin using this feature in your Premium workspace, no actions are required. Please note that for datasets created as part of Datamarts, the refresh operation is governed in the Datamarts details page. Refer to Data refresh in Power BI for more information on this capability.
