report server
3213 TopicsInput Slicer Filtering Rule Stops Working After Publishing to Report Server
Hi everyone, I have a question regarding the "Input slicer" visual in Power BI. I created an input slicer in Power BI Desktop and set the filtering rule to "Does not contain any". It worked perfectly in Desktop during my local tests, filtering data as expected. However, after publishing this report to our on-premises Power BI Report Server, the input slicer's behavior seems to have changed: The operator dropdown button is missing: The dropdown button that allows me to switch between operators (e.g., "contains", "does not contain") in Desktop is no longer visible on the server. Filtering logic appears different: When I enter a value, it seems to apply an exact match logic instead. Only when I type the complete and exact value can it filter the data. The "does not contain any" rule I originally set no longer seems to work. Has anyone else encountered this issue? What could be the possible causes? Is this due to limited support for the input slicer visual in certain Report Server versions, or could it be that I missed some important step before publishing? Just to add more details to this issue: I recently upgraded our Power BI Report Server from the September 2025 version to the May 2026 version (version 15.0.1121.120) I'd really appreciate any insights or suggestions! Thanks in advance.43Views0likes2CommentsPower BI Report Server January 2026 Feature Summary
Welcome to January 2026 Power BI Report Server feature summary! These updates bring new capabilities and enhancements across Reporting and Visualizations, maintaining our commitment to delivering powerful, flexible, and enterprise-ready reporting solutions. For more information on how to find your report server product key, refer to the documentation. Visualizations features This release includes a variety of new and updated visuals from Microsoft partners and the broader community. These visuals enable richer storytelling, advanced exploration, and more engaging report experiences. Activity Gauge by Powerviz Decomposition Tree โ All Expanding Dynamic chart legends in Zebra BI Charts Drill Down Bubble PRO by ZoomCharts Power Gantt Chart by Nova Silva Turn any image into data insights with Synoptic Panel by OKVIZ 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 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 Reporting features This release also includes several reporting enhancements to improve layout behavior, visual styling, and interaction options to help you build polished, intuitive, and modern reports. Automatically expand matrix columns to fill available space Card visual (Generally Available) Enhancing Image visuals with styling, states, and more Button slicer (Generally Available) Automatically expand table columns to fill available space Performance analyzer available when editing a report in the web This concludes the feature summary for January 2026. Please follow this blog for updates on upcoming releases. As a reminder, Power BI Report Server releases occur in January, May, and September. Thank you for using Power BI Report Server!8.5KViews0likes1CommentInstall and configure Power BI Report Server
Join us for the next #FREE #ONLINE session of the ๐๐๐ซ๐ฌ๐ข๐๐ง ๐๐จ๐ฐ๐๐ซ ๐๐ ๐๐ฌ๐๐ซ ๐๐ซ๐จ๐ฎ๐ฉ with a great speaker, Arman Falah ๐๐ค๐ฅ๐๐: Install and configure Power BI Report Server ๐๐๐๐ฉ๐๐ฃ๐ ๐ก๐๐ฃ๐ (๐๐ ๐๐๐๐ข๐จ): https://bit.ly/3PiP4LB ๐๐๐ญ๐: ๐9-๐๐๐ฒ-๐๐๐๐ ๐๐ข๐ฆ๐: ๐ฒ:๐ฌ๐ฌ ๐ฃ๐ ๐๐๐ฆ๐ง ๐๐๐ง๐จ๐๐๐ฃ ๐๐ฝ๐๐๐- ๐๐๐๐ง๐ค๐จ๐ค๐๐ฉ ๐พ๐ค๐ข๐ข๐ช๐ฃ๐๐ฉ๐ฎ: https://bit.ly/3IAg7xT ๐๐๐ฃ๐ ๐๐๐๐ฃ: https://bit.ly/32tGkif ๐๐๐ก๐๐๐ง๐๐ข ๐พ๐๐๐ฃ๐ฃ๐๐ก: https://t.me/PersianPBIUG ๐๐ค๐ช๐๐ช๐๐: https://bit.ly/3hk20RL We speak in #Farsi in this session.105Views0likes0CommentsDynamic Subscription Sent Default Page instead of Report Page selected
Hi, My Power BI dashboard Dynamic Subscription is not working this month where it sent Default Page instead of Report Page selected. This is a monthly subscription and it is working fine last month. The subscription email received is with correct filter set but not the page selected, for example I set Page 2 but it give me Page 1 (the page I at when I saved and published). I have "Set as landing page" unchecked. Try recreate a new Dynamic subscription - not working. Try recreate a new Standard subscription - working. I google and cannot find a solution. Anyone with the same issue and found a solution? By the way the "Include my changes" is missing for me, I not sure is my admin set that or PBI recent updates removed that. Thanks in advance for any help~202Views4likes3CommentsPower BI Desktop Snowflake Refresh Fails: โCannot Convert Null to Textโ While Service Still Works
Hi all, Iโm seeing a sudden Power BI Desktop refresh failure with Snowflake-backed Power Query tables. Has anyone else seen this with recent Power BI Desktop / Snowflake connector builds? Is there a known regression or recommended workaround? Power BI Desktop version: 2.155.756.0 Install type: Microsoft Store app Connector: native Snowflake connector Pattern: Snowflake queries fail in Desktop, but the same SQL runs successfully in Snowflake and the dataset/report still refreshes in Power BI Service. Representative M pattern: let Source = Value.NativeQuery( Snowflake.Databases( "<snowflake_account>", "<warehouse>", [Implementation="2.0"] ){[Name="<database>"]}[Data], "<native SQL query against a Snowflake view>", null, [EnableFolding=true] ) in Source Desktop refresh error: cannot convert the value null to type Text. Things already tried: Restarted machine Uninstalled/reinstalled Power BI Desktop Cleared/re-authenticated data source credentials Removed [Implementation="2.0"] Removed [EnableFolding=true] Replaced select * with explicit column casts Tested multiple Snowflake queries/tables4.9KViews17likes15CommentsPower 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. 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. _AI_preparation_settings_in_Power_BI_service_showcasing_the_opt 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. er_2025_Feature_Summary 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: 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. 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. _on_functions_to_evaluate_define_and 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!19KViews0likes0CommentsPower BI November 2025 Feature Summary
The November 2025 Power BI feature update brings several important announcements and enhancements across the platform. Key highlights include the deprecation of R and Python visuals in the Embed for your customers solution, significant updates to Copilot and AI capabilitiesโsuch as the standalone Copilot in Power BI mobile apps (Preview) and improvements to Verified Answersโand new options for reporting, modeling, and data connectivity. Users will also notice advancements in visualizations, with features like automatically expanding matrix columns and a generally available Card visual, as well as expanded support for Spark and Impala connectors and enhancements to image visuals and the OneLake Catalog. This summary provides an overview of these impactful changes to help you leverage the latest innovations in Power BI. Contents Events and Announcements Fabric Data Days is on now! FabCon is back from March 16-20, 2026, in Atlanta, GA Copilot and AI Ask anything, anywhere with Standalone Copilot in Power BI mobile apps (Preview) Updates to the standalone Copilot in Power BI Improvements to Verified Answers Remote Power BI Model Context Protocol Server for chat with your Data (Preview) Reporting Automatically expand matrix columns to fill available space Card visual (Generally Available) Enhancing Image visuals with styling, states, and more OneLake Catalog now supports user data functions for Translytical task flows (Preview) App Copilot (Preview) Modeling Power BI Modeling MCP Server (Preview) Semantic Model Version History (Generally Available) TMDL Visual Studio Code Extension (Generally Available) Data connectivity Spark and Impala Connectors (Generally Available) Visualizations Activity Gauge by Powerviz Decomposition Tree โ All Expanding Dynamic chart legends in Zebra BI Charts Drill Down Bubble PRO by ZoomCharts Power BI Theme Generator Power Gantt Chart by Nova Silva Turn any image into data insights with Synoptic Panel by OKVIZ Announcing deprecation of R and Python visuals in Embed for your customers solution https://youtu.be/pRFeQWzUhn0 Events and Announcements Fabric Data Days is on now! Take your Power BI skills to the next level with live learning sessions, QuickViz challenges, discount vouchers for exam PL-300 and DP-600, and community connection. See whatโs happening this week. 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. Copilot and AI Ask anything, anywhere with Standalone Copilot in Power BI mobile apps (Preview) In the coming app release, we are enabling a new standalone Copilot experience straight from your mobile homepage. A complete chat experience that allows you to ask any question about your data and get instance insights from Copilot, anytime, anywhere. This experience will be available in the app stores in the upcoming weeks. To start chatting with your data, use the new Copilot button on your home page. This will open a chat experience where you can type or dictate (IOS only) your question and Copilot will take it from there. When you ask about a metric or a KPI, most chances that Copilot will generate a visual for you in addition to answering your question with text. Tap on the visual to open a pane and interact with the generated visual. Tap on the citation or reference to learn what content Copilot used for grounding its answer. You can also open the report from there as well. If you want to share insight discovered in the chat with others, select the โShareโ button from the visual pane, or the copy from the chat. The iOS apps (iPhone and iPad) also support dictation โ so you can use voice interaction to ask Copilot questions. Use the mic icon in the chat box and Copilot will start listening, waiting for your questions. With this new standalone Copilot experience, you can now easily get quick answers and stay on top of things by chatting with your data directly from your mobile. Updates to the standalone Copilot in Power BI The standalone Copilot in Power BI, also known as โchat with your dataโ, is now even easier to use. Previously, Copilot asked users to choose from a list of possible data sources before answering questions. Now, it handles that step automatically: if it finds a strong match, it selects it in the background and goes straight to the answer. When more context is needed, Copilot will ask simple clarifying questions to find the right source. Although the additional reasoning may require a few more seconds, obtaining an accurate response from a reliable source justifies the brief wait. Additionally, in response to search questions like โFind reports about salesโ, youโll now see a much simpler text-based list of items. New entry points right from the home page By late November, youโll be able to access Copilot right on your home page, making it easier than ever to find what youโre looking for or ask ad hoc questions about your data! Simply type your question and hit enter. If you preferred the old home page, no problem. Switch back using the layout drop-down. New suggested prompts for recently opened items - Copilot now offers helpful prompt suggestions related to recently opened items to help users get started. Improved experience attaching items to your question - Want to add a report, or other items, to your question? Items are now sorted by recency and easily filtered by item type in a slick new design that aligns with other Copilot experiences across Microsoft. Experiment with all the new updates and let us know what you think! Improvements to the Report Copilot Weโve upgraded the Report Copilot experience in Power BI, making it easier than ever to create, edit, and refine beautiful, data-rich reports with the help of AI. With this update, Copilot in Power BI not only helps you create entire report pages in seconds but now also gives you more control, flexibility, and visual intelligence than ever before. The new Report Copilot experience is available now in the Power BI service and Power BI Desktop. Smarter, More Capable Visual Creation The new Copilot understands your data and intent more deeply than ever. Just tell it what you want to create, and watch your ideas come to life instantly. Better visual recommendations: Copilot now selects the most appropriate visuals for your data automatically. Expanded Visual Library: Copilot supports a wider range of visuals, giving you more options to present insights into exactly how you envision them. Improved context awareness: When you describe what you want to see, Copilot now understands more nuanced instructions, producing more accurate and insightful results. To learn more about creating and modifying reports with Copilot, refer to the Create reports in the Power BI service with Copilot documentation. Improvements to Verified Answers This update enhances how verified answers inherit the state of your visual, expands filtering flexibility, and delivers more reliable results. Whatโs New? Verified answers now inherit and reflect the entire visual state: Previously, verified answers only captured filter states active at the time of creation. With this update, they now inherit the entire visual state, including slicers. This change directly addresses one of the most common pieces of feedback we received. Report slicers impacting the visual are being inherited and shown in the verified answer. In addition to slicers, we will support additional visual states: Slicer selections Field parameter choices Cross filters and cross highlights Drill-through filters Expanded Filtering Capabilities for Authors: There is now more flexibility when configuring verified answers. The limit for predefined filter permutations has increased from 3 to 10, enabling more complex and nuanced configurations. From a consumption perspective, we see that most prompt requests naturally use between one and three filters. โShow total sales for the region 1 in Q1โ. โWhat is the usage of Product 1 in Country 1 during Month 1โ. โShow average satisfaction scores by City 1 and segment 1โ. Still, some business questions require deeper combinations of filters, and this expanded limit ensures verified answers can handle even the most detailed reporting scenarios. Improved Filtering Reliability: What are more filters, if they arenโt applied consistently? Weโve made substantial improvements under the hood to how we match user prompts in Copilot to verified answers and the appropriate filters. Verified Answers now interpret and apply filters more accurately, reducing mismatches between what users ask and whatโs displayed, and ensuring filters are included when they should be. New card visual support: We have enabled the highly requested new card visual that you can now set as verified answers, the new card visual and Azure maps will be supported in Verified Answers creation and consumption. Why it Matters: These updates make verified answers feel native to your Copilot consumption experiences, seamlessly adapting to slicers, filters, interactions, and drill-through actions that users have come to expect from their visuals. Consumers will get answers that truly reflect the context of their analysis. The result, faster, more accurate insights, and a smoother path from question to confidence, and better grounding for the rest of your Copilot experience to learn from. For more info on how these updates work, refer to the Prepare Your Data for AI - Verified Answers documentation. Remote Power BI Model Context Protocol Server for chat with your Data (Preview) Available soon, the remote Model Context Protocol (MCP) server for Power BI provides agents and MCP clients with tools to enable you to chat with your data, remotely, all authenticated with Microsoft Entra ID. This means youโll be able to create powerful, custom agents on top of data that lives in your semantic models. The server has three tools that give your agents the ability to reason over your data, and respond to a userโs prompts: Get Semantic Model Schema: This tool provides the agent with the structure of the semantic model. Generate Query: This tool uses Copilot in Power BI to generate a DAX query based on the userโs input and best practices. The agent can then iterate on this query if it chooses or simply proceeds with the provided query. Execute Query: This tool gives the agent a powerful mechanism to query the semantic model to respond to any question a user asks. These tools can be implemented by any application that hosts an MCP client, such as Visual Studio Code. Other, non-Microsoft MCP clients can be supported with Service Principal authentication, backed by Azure Entra ID. The remote MCP Server for Power BI enables you to easily build the next generation of agents on top of the data your organization has already invested so heavily in. For more information on the remote MCP server for Power BI, for more information, refer to the documentation. Reporting Automatically expand matrix columns to fill available space Last month, tables got the Grow to fit option expanding columns to fill the available space. This month, we are enabling the same option on the matrix visual. As a reminder: with the Grow to fit option, any extra space in the visual is evenly distributed across existing columns when the total column width is smaller than the visual container, which eliminates the need to do manual resizing to fill the gaps. If your matrix isnโt using the full visual width, you can manually resize columns or use the new โGrow to fitโ option. For example, this matrix 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 matrix expands to make full use of the available space. The additional available space will be distributed across the columns: In last monthโs release we also had an overenthusiastic horizontal scrollbar when using this option. This has now been corrected. The horizontal scrollbar should not show unless there isnโt enough space to fit the content. Learn more about Grow to fit in the table and matrix documentation. Card visual (Generally Available) The new Card visual brings a modern and visually engaging way to highlight key metrics in your reports, now with full support for hero images and a consistent formatting control experience across visuals for an intuitive experience. Whether youโre highlighting a product, showcasing a team, or featuring a brand logo, the new hero image feature empowers you to create visually rich reports going far beyond simple data points. The Card visual also introduces a dynamic collage layout, letting you highlight one section while the other two share the remaining space. Try adding the new Card visual to your next report and experience the difference for yourself. For more details and step-by-step instructions, check out the official documentation at Create a (new) card visual in Power BI documentation. Enhancing Image visuals with styling, states, and more Weโre excited to introduce enhancements to the Image visual, bringing it closer to the level of interactivity and design flexibility youโve come to expect. Create more engaging experiences by customizing image visuals based on user interaction states such as default, hover, and pressed states of images. Alongside state customization, weโve added formatting options to give you full control over the look and feel of your image visuals. Such as background, border, and shape. These enhancements make it easier than ever to integrate images seamlessly into your report layout. Weโve also expanded the sources, fit and effects section, with more options for image source, including upload, URL, or from a data field. You no longer need to delete the visual to update its image. With the latest update, you can easily change the image source or swap the image itself, making edits faster and more flexible. We hope these updates to the Image visual inspire you to get creative with your report designs. Whether adding a splash of branding, building intuitive navigation, or simply making your reports more engaging, the new features give you the flexibility to do it all. To learn more about the image visual, visit our documentation: Create an Image Visual in Power BI. OneLake Catalog now supports user data functions for Translytical task flows (Preview) The Fabric user data function selection experience for Translytical task flows has been improved. You can now use the OneLake catalog to discover and select the user data function that you want your action button to invoke. With the OneLake Catalog you can: Browse all available User data functions in one place. Search by keyword for quick access. View details like owner, location and sensitivity label Filter by My Functions or Endorsed in your org for confidence and governance. This new experience is available when selecting the function for Data function actions. Select a button, open the format pane, enable Action, and under Data function select the fx button. Learn more about Translytical task flows in Power BI and how Fabric user data functions can take your report beyond just showing data at Understand translytical task flows. App Copilot (Preview) Your app users now can chat with your curated data within the context of an app. An app-scoped Copilot means users can search for reports within an app, ask questions, and receive answers based on the reports in that app. App Copilot is a separate complement to report-scoped Copilot already available on each report viewed in an app. To learn more, refer to the Power BI app Copilot: AI scoped to the curated content in an app (Preview) blog post. Modeling Power BI Modeling MCP Server (Preview) The Model Context Protocol (MCP) is an open standard that enables AI agents to securely connect with tools and services. The Power BI Modeling MCP Server brings Power BI semantic modeling capabilities to your AI agents through a local MCP server. This allows developers and AI applications to interact with Power BI models in entirely new ways, from using natural language to execute modeling changes to autonomous AI agentic development workflows. Capabilities Build and modify semantic models with natural language: Create or update tables, columns, measures, relationships and much more simply by describing what you need. Perform bulk modeling operations at scale: Rename, refactor, translate, or document hundreds of model objects in seconds. Apply modeling best practices: Easily evaluate and implement modeling best practices. Leverage agentic workflows: Work with Power BI Project files and TMDL code, enabling AI agents to autonomously plan and execute complex modeling tasks. Query and validate DAX expressions: Run DAX queries or validate measures directly through AI-driven workflows. Start by installing the Power BI Modeling MCP Server Visual Studio Code extension to enable Power BI semantic modeling capabilities in GitHub Copilot. Whether youโre using GitHub Copilot or another AI-powered assistant, the Power BI Modeling MCP Server unlocks a new era of intelligent, automated, and high-efficiency semantic model development. For additional information and to provide feedback, refer to Power BI Modeling MCP on GitHub. Semantic Model Version History (Generally Available) With version history, you can confidently make changes to your semantic modelsโwhether youโre editing in the web or live editing Direct Lake semantic models in Desktopโknowing you can restore earlier versions and recover from critical mistakes. Versions are automatically captured in an Office-like history pane for your live edited semantic models, making it easy to select and restore any previous version. Power BI captures up to five versions for each semantic model that supports version history. Versions are saved automatically when you: Open a semantic model in Editing mode on the web or open a Direct Lake model for live editing in Desktop. Publish or upload a .pbix file. Restore a previous version. You can also manually save a version (with an optional description) from the File menu while editing on the web. Learn more about this capability including limitations in the Use semantic model version history (preview) documentation. TMDL Visual Studio Code Extension (Generally Available) This update brings DAX semantic highlighting support within TMDL documents alongside other enhanced authoring features like Power Query semantic highlighting, breadcrumb navigation, code actions, code formatting, localization, and numerous bug fixes. You can find more details about this latest release in the changelog. The TMDL extension is essential for anyone working with TMDL documents in Power BI Projects (PBIP). It brings modern code experiences to semantic modeling, enabling scalable development of semantic models with the efficiency, flexibility, and AI-powered workflows that todayโs data teams expect. Get the TMDL Extension from the Visual Studio Marketplace to enhance your semantic modeling-as-code experience and accelerate your semantic model development today! Screenshot of VSCode Marketplace Feature Highlights DAX support: Improved readability of DAX code within TMDL documents including semantic highlighting, real-time diagnostics, and autocomplete. Power Query support: Autocomplete, diagnostics, syntax highlighting, hover and formatting. Localization: Hover descriptions and code action messages are now displayed in the userโs preferred language, aligning with Visual Studio Code language settings. Code actions: Quick fix and refactoring TMDL code such as duplicated lineage tag or misspelled property. Code navigation: Easily navigate TMDL document objects in a hierarchical view. Code format: Automatically organize TMDL code for enhanced readability and consistency. We value your input and encourage you to share it using vscode-tmdl GitHub repository. Data connectivity Spark and Impala Connectors (Generally Available) Weโre thrilled to announce that Implementation 2.0 for the Spark and Impala Connectors is now generally available, powered by the open-source Arrow Database Connectivity (ADBC) driver. This update delivers faster, more secure connectivity for Power BI Desktop, making it easier to analyze and visualize large datasets. How does this improve your Power BI experience? Performance boost: Reduced overhead with no serialization or copying. Security improvements: Memory safety and garbage collection aligned with SDL standards. Seamless integration: Works across Fabric experiences and Power BI Desktop for unified data access. Beginning November 2025, specify [Implementation="2.0"] in your connection settings to utilize these improvements: Spark: ApacheSpark.Tables("http://server.cloudapp.azure.com:10001/cliservice", 2, [BatchSize=null, HierarchicalNavigation=true, Implementation="2.0"]) Impala: Impala.Database("server.cloudapp.azure.com", [Implementation="2.0"]) For further details, please refer to the Spark Connector and Impala Connector documentation. Visualizations Activity Gauge by Powerviz The Activity Gauge is an advanced visual used to measure the progress against a set target or Goal for multiple categories. It is typically presented in the form of a radial bar chart/Gauge, displaying a range of values or percentages. This visual is commonly used for project management, performance tracking, and monitoring Key Performance Indicators (KPIs). Key Features: Gauge Customization: Shape, style, and add icons for a unique design. Targets: Choose from options or use a custom field to set a target. Data Colors: Offers 7 schemes and 30+ color palettes. Smart Labels: Add data and leaf labels that auto-adjust inside or outside the shape for better readability. Center Circle: Customize center circle with text, icons, measures, and images. Interactive Mouseover: Hover for Interactive Info Display. Fill Patterns: Highlight gauges with patterns or upload your own. Conditional Formattingโฏโ Create rules based on measure or category rules. Other features included are ranking, annotation, grid view, show condition, and accessibility support. Business Use Cases: Project Management: Track task progress for efficient project oversight. Financial Dashboard: Gain instant insights into key financial metrics. Try Activity Gauge 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 Decomposition Tree โ All Expanding Decomposition tree All Expanding Visual now allows you to add a legend field. This creates additional column chart beside each node showing breakdown from another dimension. This is depicted in image below. The visual below analyzes the revenue of two largest consumer good companies Unilever and P&G by products. We add region field in the legends section to show additional breakdown of Revenue by Region. The data used is fictitious and used for analysis purposes only. The visual also allows you to add images to nodes. Check out the video on Decomposition Tree All Expanding - Power BI custom visual, demonstrating all the features of this custom visual. Download this visual from APPSOURCE Download demo file from APPSOURCE For more information visit https://www.excelnaccess.com/decomposition-tree/ or contact [email protected] Dynamic chart legends in Zebra BI Charts Which version of the plan am I looking at? - Finance teams ask this daily when switching between budgets, forecasts, and plans. Static chart labels in Power BI waste hours every week and lead to confusion, misinterpretation, and reporting errors. The new dynamic chart legends in Zebra BI Charts for Power BI remove that guesswork by automatically adapting chart legends to the selected filter or scenario, so you can always trust what you see. See the full update How it helps - In FP&A, Actuals are often compared against multiple baselines. Waterfall charts are ideal for this, but static legends stay fixed even when scenarios change. Real-world use cases Comparing forecast versions: Before, every scenario looked the same: โPlanโ. Now, legends show AC 2024 vs Revised Forecast Q3, eliminating ambiguity. Year-over-year analysis: Previously, reports displayed AC [Year] regardless of selection. Now, legends update from AC 2024 vs PY 2023 to AC 2025 vs PY 2024. Regional reporting: Legends now reflect the active region: AC vs EMEA Budget or AC vs Americas Budget, without manual checks. Together with dynamic titles and dynamic column headers, Zebra BI delivers a fully responsive, accurate, and effortless reporting experience in Power BI. Explore Zebra BI for Power BI Drill Down Bubble PRO by ZoomCharts Say hello to the latest visual by ZoomCharts! With Bubble PRO, you can create visually impressive and user-friendly bubble charts that make complex data simple to explore. What sets Bubble PRO apart from other visuals is the user experience. UI interactions are made as intuitive as possible: freely pan the chart, pinch or scroll to zoom in, click on a marker to drill down, and quickly make single or bulk selections. Coupled with smooth UI animations, seamless cross-filtering and full touch support, you can design more interactive and insightful reports. Main features Drill Down:โฏCreate a multi-level hierarchy; and click to drill down. Data-driven Formatting: Apply custom marker colors, shapes, or images directly from data. Trendlines:โฏShow a linear or polynomial regression line that dynamically recalculates whenever the chart changes. Thresholds:โฏDisplay up to 4 reference lines or areas on each axis. Area Shading:โฏHighlight up to 8 custom areas with rectangles or ellipses. We also have other news: you can now sign up to the free Developer License and use Bubble and 20+ other ZoomCharts visuals in Power BI Desktop for a year! Get Bubble PRO on AppSource Power BI Theme Generator In September 2023, our BIBB Report Theme Generator for Power BI was spotlighted on the Power BI blog. Since then, we've rebuilt and expanded it to help teams standardize look-and-feel, meet accessibility baselines, and export production-ready JSON themes in seconds. The generator streamlines brand color, typography, and visual style setupโmaking it easy for BI teams to deliver consistent, on-brand reports while reducing manual rework. What's new: a smarter color engine with contrast checks, gradients creation, AI powered themes creation, preset brand colors, apply theme through Fabric, select font, live preview on your own report, and advanced BI.ST mode for power users, while keeping the simplicity of one-click JSON export. Common use cases include (1) rolling out or updating corporate brand themes across workspaces, (2) accelerating new report builds with vetted defaults, and (3) improving report readability and accessibility with contrast-safe palettes. Learn more and see all features on our product page below. Links Find the simplest yet most powerful Power BI Theme Generator All features & documentation Power Gantt Chart by Nova Silva Weโre thrilled to introduce one of the most requested features in Power Gantt: task dependencies! With our latest release, you can now add Finish-to-Start (FS) dependencies between tasksโvisually represented as arrows connecting one taskโs finish to anotherโs start. This powerful enhancement brings true project scheduling capability to Power BI. By visualizing dependencies, teams can better understand task sequences, identify bottlenecks, and manage timelines more effectively. Adding dependencies is simpleโjust define them in your dataset, and Power Gantt does the rest. Arrows will automatically appear on your Gantt chart, making relationships between tasks clear and actionable. Whether youโre managing product launches, construction schedules, or complex workflows, FS dependencies make your Power Gantt chart smarter, more dynamic, and easier to interpret. Start using dependencies today and take your project tracking to the next level! Try the Power Gantt Chart for FREE now on your own project data by downloading it from the AppSource. Questions or remarks? Visit us at: Power Gantt Chart for Power BI. Turn any image into data insights with Synoptic Panel by OKVIZ With Synoptic Panel, you can transform any SVG image into an interactive visual directly in your report. Perfect for floor plans, organizational charts, technical layouts, or geographical maps, it lets you integrate your data with images your audience already knows. A dynamic dashboard, where users can naturally explore insights by clicking on shapes and areas. This makes complex information easier to understand and more engaging to navigate. Key features include: Flexible image loading: use local files embedded in reports, remote URLs, or My Storage, our secure hosting service. Multi-level navigation: drill down into building floors or geographical regions, with automatic hierarchy creation when using remote configurations. Dynamic switching: change maps through slicers or bookmarks. Map Editor and Label Designer: fine-tune data binding, arrange and customize labels directly in the visual. Advanced coloring: apply conditional formatting and color rules to build heatmaps or highlight key areas. Map search: quickly locate maps or areas for faster access. Integrated security: safely host and distribute maps while keeping control of access. Full customization: adapt interactions, appearance, and data binding to your reporting needs. Explore real-world use cases and try Synoptic Panel for free! General Announcing deprecation of R and Python visuals in Embed for your customers solution We are announcing an important change for Power BI customers who use Embed for your customers with R or Python visuals. As part of our ongoing commitment to provide a secure, scalable, and robust analytics platform, we continually evaluate our feature set to ensure alignment with industry standards, customer needs, and platform performance. Whatโs Changing? Starting May 2026, Power BI will end support for the ability to embed reports and dashboards containing R or Python visuals using Power BIโs Embed for your customers solution (also known as app owns data) and Publish to web scenarios. Embed for your customers typically involves a custom app which manages authentication directly, and for which app users do not need Power BI licenses. This change does not impact customers leveraging secure embeddings to SharePoint, Website or Portal. Embed for your organization (also known as user owns data) scenarios are also not impacted. Timeline for Deprecation Announcement & Guidance: Effective immediately, customers are notified of the upcoming deprecation. Deprecation Date: Official support for embedding R and Python visuals in PaaS scenarios will end on 05/01/2026. Post-Deprecation: After this date, any embedded Power BI reports or dashboards containing R or Python visuals will still load, but the R or Python charts will display as blank. Reports without these visuals will continue to function as expected. Recommended Actions for Customers Review all embedded Power BI reports and dashboards to identify usage of R or Python visuals. Plan to update or redesign any affected reports using alternative Power BI visuals or DAX-based analytics. Consider leveraging Fabric Notebooks for more sophisticated or technical visualizations. Consult the Power BI & Fabric documentation for guidance on using alternative visuals effectively. Support and Resources We understand that this change may require updates to your existing solutions. Please reach out via the Power BI community forums or through your Microsoft account representative for personalized guidance. 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!25KViews0likes0CommentsPower BI Report Server Service Issue
Users complain about reports are not opening and giving error "Unable to load Data Model". When we connect to the machine we checked Memory & CPU both were fine & we thought that there might be a Service issue so we restarted the service but receive the following error then we tried to change the service user to admin any applied changes in the Report Server configuration still we received the following error System.InvalidOperationException: Cannot start service PowerBIReportServer on computer 'Server'. ---> System.ComponentModel.Win32Exception: The service did not respond to the start or control request in a timely fashion --- End of inner exception stack trace --- at System.ServiceProcess.ServiceController.Start(String[] args) at ReportServicesConfigUI.Panels.ConfigurationPanelWithErrors.StartOrStopServiceTask(Boolean start, String serviceName)โ2.5KViews0likes1CommentSequence contains more than one element June update 2.155.756.0 & SAP BW Direct query
Hi we are currently experiencing this issue on June update of Pbi - error message: Sequence contains more than one element. Data source SAP business app server, direct query. All reports are not working. Also unable to create new ones. Any idea what went wrong? On SAP side there were no changes. Feedback Type: Frown (Error) Timestamp: 2026-06-15T13:34:11.4197245Z Local Time: 2026-06-15T15:34:11.4197245+02:00 Session ID: 02a75b59-23ab-4021-b050-d811b24249da Release: June 2026 Product Version: 2.155.756.0 (26.06)+7f1da5803bfe48beff98093405280405ddb467dd (x64) Stack Trace: System.InvalidOperationException at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source) at Microsoft.PowerBI.Modeling.Engine.DataModel.Utilities.DataModelExtensions.GetCubeDataSourceType(INamedExpression namedExpression) at Microsoft.PowerBI.Modeling.Engine.Query.ModelingMashupDocumentGenerator.BuildQuery(IQueryableObject obj, IModelingQueryBuilder queryBuilder, IEnumerable`1 queryGroups, TwoWayDictionary`2 modelObjectNameToRuntimeIdMap) at Microsoft.PowerBI.Modeling.Engine.Query.ModelingMashupDocumentGenerator.BuildQueries(IDataModel dataModel, IModelingMashupDocumentBuilder mDocumentBuilder, TwoWayDictionary`2 modelObjectNameToRuntimeIdMap) at Microsoft.PowerBI.Modeling.Engine.Query.ModelingMashupDocumentGenerator.GenerateQueriesFromModel(IDataModel dataModel, IModelingMashupDocumentBuilder mDocumentBuilder, TwoWayDictionary`2 modelObjectNameToRuntimeIdMap) at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingQueriesGenerator.GenerateRestorationInputFromModel(IDataModel dataModel, IMashupDiscoveryService mashupDiscoveryService) at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingQueriesGenerator.GenerateAndRestoreQueriesFromModel(Report report, IDataModel dataModel, Boolean restoreQueriesToReport) at Microsoft.PowerBI.Client.Windows.Services.ReportFactory.<SetAnalysisServicesDatabaseToReport>d__1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.PowerBIPackagingService.<Open>d__9.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.BiPackageOperationHandler.<LoadArtifact>d__27.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.CurrentArtifactManager.<>c__DisplayClass58_0.<<ExecuteAndHandleFileOpenErrors>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBITelemetryServiceExtensions.<EmitStandardizedClientReportingEventWithDebugEvent>d__7`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.CurrentArtifactManager.<ExecuteAndHandleFileOpenErrors>d__58.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.CurrentArtifactManager.<>c__DisplayClass37_0.<<OpenArtifactAndSetAsCurrent>b__1>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.<>c__DisplayClass19_0`1.<<BlockUIAndRun>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion[T](Task`1 task) at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.BlockUIAndRun[T](Func`1 asyncMethod, PowerBIProgress progress, String activityId) at Microsoft.PowerBI.Client.Windows.Services.CurrentArtifactManager.OpenArtifactAndSetAsCurrent(IPowerBIWindowService windowService, IPowerBIArtifact artifactToOpen, IExceptionHandler exceptionHandler, Nullable`1 entryPoint, ReloadFileOptions reloadFileOptions) at Microsoft.PowerBI.Client.CommandLineFileService.TryOpenOrCreateReport(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, Boolean forceCreate) at Microsoft.PowerBI.Client.AppReportFlow.<OpenExistingReport>d__50.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.PowerBI.Client.AppReportFlow.<OpenExistingReport>d__50.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.AppReportFlow.<ContinueLoadWithMainWindow>d__43.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.AppModule.<>c__DisplayClass4_2.<<Run>b__4>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.MainWindow.<<ActivateMainWindow>b__41_1>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext() PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.155.756.0","ModuleName":"Microsoft.PowerBI.Modeling.Engine.dll","Component":"Microsoft.PowerBI.Modeling.Engine.DataModel.Utilities.DataModelExtensions","Error":"System.InvalidOperationException","MethodDef":"GetCubeDataSourceType","ErrorOffset":"32","ErrorCode":""} OS Version: Microsoft Windows NT 10.0.26200.0 (x64 cs-CZ) CLR Version: 4.8 or later [Release Number = 533509] Peak Virtual Memory: 85.8 GB Private Memory: 296 MB Peak Working Set: 425 MB IE Version: 11.1882.26100.0 User ID: 8076080c-4640-48db-9342-e6360ebde53c Workbook Package Info: 1* - cs-CZ, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False. Telemetry Enabled: True Model Default Mode: Empty Model Version: PowerBI_V3 Disabled Preview Features: PBI_DatabricksAdbcVersionEnabled PBI_googleBigQueryAdbcVersionEnabled PBI_UseRedshiftODBCV2 PQ_UseBaseViewXmlForSharePoint PBI_snowflakeLegacyOdbcVersionEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_b2bExternalDatasetSharing PBI_scorecardVisual PBI_onObject PBI_setLabelOnExportPdf PBI_oneDriveSave PBI_oneDriveShare PBI_useModernPublishDialogs PBI_publishDialogsSupportSubfolders PBI_gitIntegration PBI_tmdlInDataset PBI_enhancedReportFormat PBI_enhancedReportFormatPBIX PBI_advancedSlicerTypeList PBI_useModernMashupEditor PBI_aiNarrativesVisual PBI_customCalendars PBI_copilotUnifiedTooling MashupFlight_EnableOracleBundledOdacProviderV2 PBI_enableOracleBundledOdacProviderForDQ PBI_sqlDbNativeArtifactsOnDesktop PBI_warehouseSnapshotArtifactsOnDesktop PBI_dynamicCalcColumn PBI_newVisualDefaults2026 PBI_enableExportQueries PBI_DesktopNamedPipeBridge PBI_dateSlicerPreselectionAuthoring Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 150% Supported Services: Power BI WebView2 Runtime Version: 149.0.4022.69 WebView2 SDK Version: 1.0.2365.461.1KViews7likes3CommentsIssue: Oracle Cloud Connection created without centralized On-Premesis Gateway and can't delete it.
Hello, this problem recently happened on Friday, and I think I am up a creek without a paddle. I have a Power BI Pro license using the On-Premises Gateway (Personal mode) for refreshes. The company does not have a standard On-Premises Gateway installed and configured. We use Oracle database for alot of our backend data. I just recently upgraded to the June 2026 update of Power BI Desktop with all preview features enabled. All of my reports that use Oracle are connected with the native Oracle database connector that utilize the personal gateway. Somehow, a Cloud version of the Oracle connector got created on the service, and nothing will connect because we do not have a standard gateway. I have tried deleting the Oracle cloud connections and trying to rebind it with a new file, but, it just keeps coming back. This article states if this happens, this is irreversible: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database. However, I don't understand how it could be created without an installed centralized gateway? How can I fix this? I'm open to extreme steps at this point, minus getting the centralized On-Premises installed, because that is not going to happen this year. If I have to get our vendor to reset my entire workspace and license to start from scratch, I'm willing to do that, assuming it will actually work. Any suggestions would be helpful. I really need to be able to use the native Oracle connector with the personal gateway.284Views0likes1Comment