SUBTOTAL PROB
Title: Power BI Matrix — How to Show Subtotal Only at StudentID Level, Not StudentName Level? I am using Power BI Desktop October 2026, version 2.159.883.0 (64-bit). My Matrix visual has: Rows: StudentID → StudentName → Subject Values: Total Marks My data model contains a student master table and a student transaction table, related by StudentID. I want to show: StudentID 101 subtotal = 258 StudentID 102 subtotal = 166 StudentID 103 subtotal = 180 StudentName subtotal should not appear Subject-level marks must remain visible Grand total = 775 I enabled Row subtotals and used Apply settings to → Per row level. However, when I select StudentName and turn Show subtotal off, the StudentID subtotal also disappears. How can I achieve this in my Power BI version? Please provide the exact navigation for this version or a verified alternative. I can provide screenshots and a sample PBIX file if needed.
How to bulk-convert PBIR-Legacy reports to PBIR
Hi everyone, I'm looking for a way to automate the migration of more than 100 Power BI reports from PBIR-Legacy to PBIR, without using Microsoft Fabric. Current setup We have a master report in one workspace and more than 100 copies deployed to different workspaces. All reports share the same layout but are connected to different semantic models. Our current deployment process uses the Power BI REST API's Update Report Content operation to update existing reports. The issue is that our source report is now in PBIR format, while the destination reports are still in PBIR-Legacy format, and the update process doesn't work as expected. What we've tested We confirmed that opening a legacy report in Power BI Service, making a small modification to a text box, and saving it converts the report to PBIR. However, doing this manually for more than 100 reports would be time-consuming. My questions Is there a supported REST API to convert an existing report from PBIR-Legacy to PBIR programmatically? Can the Update Report Content API handle this format mismatch, or is this an unsupported scenario? Is there another API or automated migration approach that can trigger the equivalent of an edit-and-save operation? Can we perform this conversion without Fabric while preserving existing report IDs and each report's semantic-model connection? Our goal is to automate the conversion while keeping the existing workspaces, report IDs, semantic-model connections, and report functionality unchanged. Has anyone encountered this scenario or found a supported solution? Thanks in advance for your help!
Looking to connect with teams using Power BI for self-service reporting and insights
I lead product management for HR dashboards at a large organization, and we're migrating our self-service analytics reporting to Power BI. I have 13+ years in People Analytics, mostly on other BI platforms, so I'm looking to learn from teams already doing this well. I'd love to hear from HR or other functional leaders leaders who use Power BI for end-user self-service. In particular: Dashboard design: What does a great dashboard look like in Power BI? What are the art of the possibilities? Any examples or design patterns you'd recommend? Adoption and enablement: What training and support materials worked best for non-technical end users (for example, filtering, slicers, bookmarks, and exporting)? Governance: How do you manage workspaces and apps, and handle row-level security for sensitive HR data? Lessons learned: What would you do differently if you were migrating again? I'd also welcome a short conversation or demo with anyone willing to share how their team uses Power BI. Please reply here or message me directly. Thanks Natalie
Power BI interpreting DD/MM/YYYY dates as MM/DD/YYYY when day is 12 or below
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Hi, I'm having an issue with dates coming from an Excel source into Power BI. The source dates are intended to be in UK format (DD/MM/YYYY). However, dates where the day is 12 or below can be interpreted as MM/DD/YYYY, which moves transactions into the wrong month and significantly affects the monthly totals in the report. For example, an intended date such as: 08/10/2026 = 8 October 2026 can potentially be interpreted as: 10 August 2026 The problem is particularly difficult to identify because dates where the day is greater than 12 cannot be interpreted the other way around, so the issue appears to affect only the ambiguous dates at the beginning of each month. The report uses an Excel source and the affected field needs to remain a proper Date data type because it is related to a Date table and used for monthly filtering and measures. I would like to ensure that Power BI always interprets the incoming values as: DD/MM/YYYY / English (United Kingdom) rather than relying on automatic locale detection. What is the most reliable way to enforce this at import/Power Query level so that it remains correct after refresh and after publishing?Display personal bookmarks as a list on the report canvas
I want report viewers to create their own personal bookmarks and access them through a clickable list directly on the report canvas, instead of using the Bookmarks pane. The built-in bookmark navigator only supports report bookmarks, which viewers cannot create. Is there a way to display each user’s personal bookmarks within the report canvas, perhaps through a custom visual or another workaround?
How are teams handling AI-driven automation around Power BI Embedded applications?
I’m exploring patterns for adding AI-driven automation around Power BI Embedded applications. For example: Power BI Embedded → user interaction → backend/API event → AI analysis → business action I’m particularly interested in how teams are handling: event-driven actions from embedded reports calling backend APIs securely using AI to summarize or interpret report context triggering workflows based on report interactions authentication with service principals or managed identities keeping the architecture maintainable in production Are there recommended patterns for combining Power BI Embedded, Fabric APIs, and AI services without putting too much logic into the client application?
Reduce Category Header Height in New Card Visual
Hi Community, I'm using the New Card Visual in Power BI and have enabled the title with a blue background and white text. As shown below, the Category Header area appears quite tall compared to other visual titles (such as chart titles), and I'm trying to reduce the height of the blue header section to make the KPI cards more compact and visually consistent with the rest of the report. I've already tried: Reducing the text size Checking Multi-category Layout settings Looking for padding or spacing options ( I have made it to 0) However, the header height only decreases slightly and still occupies more space than desired. Question: Is there any way to further reduce the Category Header height in the New Card Visual, or is there a minimum height limitation built into the visual? Ideally, I'd like the header to look similar to the title bar shown in standard chart visuals. Any suggestions or workarounds would be greatly appreciated. Thanks in advance! Current Card Visual: Desired Appearance:
Como alterar a cor da fonte/texto na Exibição de Tabela (Data View) do Power BI Desktop
Olá, pessoal! Gostaria de saber se existe alguma forma de alterar a cor da fonte/texto na Exibição de Tabela (Data View) do Power BI Desktop, conforme destacado na imagem anexada. Estou utilizando o tema escuro do Power BI e gostaria de personalizar a cor dos textos exibidos nas células, por exemplo, utilizando um verde estilo terminal/Matrix (#00FF41) sobre o fundo escuro. Importante: não estou me referindo a um visual de Tabela ou Matriz criado na página do relatório. Minha dúvida é especificamente sobre a grade de dados do Power BI Desktop, acessada pelo ícone de tabela na lateral. Existe alguma configuração nativa, tema, arquivo JSON, configuração avançada ou outra maneira de personalizar a cor da fonte dessa área? Caso não seja possível atualmente, alguém sabe se existe alguma solicitação dessa funcionalidade no Microsoft Fabric Ideas ou alguma alternativa?Navigate Between Multiple Power BI Report Server Reports Inside Power BI Mobile App
Hello everyone, We are using Power BI Mobile with an on-premises Power BI Report Server. We have multiple Power BI reports, and we would like users to navigate from one report to another using buttons inside the reports. For example: Report 1 → Report 2 → Report 3 Our goal is to keep the navigation inside the Power BI Mobile app. Currently, when we use the normal Power BI Report Server report URL in a button, the link may open through the mobile web browser instead of opening the target report directly inside the Power BI Mobile app. Is there an officially supported way to navigate between different Power BI Report Server reports while staying inside the Power BI Mobile app? For example, is there a supported deep link, URL format, or another navigation method specifically for on-premises Power BI Report Server? Please note that we are using Power BI Report Server (on-premises), not the Power BI Service. Thank you for your help.Power BI Service Refresh Fails with DataFormat. Error 10942 - Desktop Refresh Works.
Hi Everyone, I need help troubleshooting a persistent Power BI Service refresh issue. I have spent considerable time debugging it using Copilot, AI assistance, YouTube tutorials, and community suggestions, but the issue remains unresolved. 1. Issue and Error My Power BI report refreshes successfully in Power BI Desktop, usually within 7–15 minutes, but every refresh fails in Power BI Service. Exact error: DataFormat.Error: We were unable to load this Excel file because we couldn't understand its format. File contains corrupted data. Microsoft.Data.Mashup.ErrorCode = 10942. The error appears while processing the semantic model. 2. Data Source and Dashboard Logic Data source: SharePoint folder using SharePoint.Files() in Power Query. SharePoint contains approximately 900 MB+ of data and hundreds of files. Files are spread across five folders, containing Excel and CSV files. Power Query filters files by folder path, imports Excel workbooks using Excel.Workbook(), promotes headers, changes data types, and combines files using the Combine Files / Transform Sample File mechanism. Multiple queries depend on a common BASE SOURCE query. These queries process different datasets, including MAIN, PROFILES, LOGIN, BREAK, QC, ABANDON, and other reporting datasets. The processed data is used in my VKYC Daily Reporting Dashboard. 3. Troubleshooting Already Done I have already tried: Re-authenticating SharePoint and Power BI Service data-source credentials. Checking file extensions, file formats, column names, data types, and historical schema differences. Standardising the historical ACHT column and newer TaskID column to TaskID. Checking for desktop.ini and other unexpected files. Reviewing Power Query dependencies and the Transform File / Transform Sample File helper queries. Testing try...otherwise logic and adjusting Excel sheet navigation. Checking queries individually. The MAIN query was the first to show an error during one Desktop debugging attempt; other queries failed because of dependencies. Creating a separate test PBIX and rebuilding the Combine Files logic, then publishing it to Service. The test PBIX also refreshes in Desktop but fails in Service with the same error. I have also checked the SharePoint file metadata, but I still cannot identify the exact file causing the problem. 4. Help Needed Could someone please suggest a reliable way to: Identify the exact Excel file causing DataFormat.Error 10942 during Power BI Service refresh? Log the file name and folder path of files that fail when Excel.Workbook() processes them? Diagnose why Service fails while Desktop refresh succeeds? Test or isolate problematic files without manually opening hundreds of files or rebuilding the entire dashboard? Use Power Query M code or another diagnostic method to capture the failing file and error details? I would particularly appreciate a practical, step-by-step solution or sample M code that can help identify the exact failing file. I have already tried multiple troubleshooting approaches and would really appreciate expert guidance. Thank you!
