Dynamic formart
Hi community, I try to find a workaround to apply dynamic formart in hierarchy, For example. The first column, should be apply format to each leven in hierachy, (colof font, font, italic, bold) in a table/matrix visual. Country 1 425 City 1 300 City 2 125 Country 2 456 I don't find such as configuration, :(. Any alternative ?Report Design Studio: a free tool for Power BI theme JSON and page layout
Styling every visual by hand, then editing theme JSON in a text editor, then checking colours by eye: I got tired of it. So I built Report Design Studio at Benibix. It is a free browser tool where you design the theme and the page on one live preview. What it does Theme JSON: set the palette, the font and the style of 27 visuals, including buttons and shapes in hover, selected and pressed states. The JSON is checked against the Power BI theme schema before it downloads. Colour: 65 curated palettes, colour harmony rules, or a palette taken from your own image. Page layout: navigation, title bar, slicer panel, tiles and footer. 8 starters and 7 page sizes for Power BI, Tableau and Looker Studio. Export as PNG, layered SVG, Copy for Figma or a PowerPoint slide. Accessibility: every colour is checked against the 3:1 floor for chart marks (WCAG 1.4.11), with APCA alongside. A matrix shows colours that are hard to tell apart, the live preview shows colour blindness views, and one click fixes failing colours. Import and export: import an existing theme JSON and keep editing it. What the studio does not edit is kept. Export a theme, a matched dark and light pair, a swatch sheet or design tokens. Your data Everything runs in your browser. There is no account and nothing is uploaded. A share link holds the design in the address after the #, which is not sent to a server. What it does not do A theme only sets defaults. A visual you coloured by hand stays as it is until you reset it. The background is downloaded as a PNG that you set per page in Power BI. It is not part of the theme. The theme JSON is for Power BI. For Tableau and Looker Studio, only the page layout applies. Try it The studio: opens straight in the browser, no sign-in. It is free. A 1 minute overview video 9 short lessons, about 30 min: from a first theme JSON to an accessible, fully styled report. The lessons are narrated with an AI-generated voice. One question: which visual or setting do you still format by hand in every report because a theme does not reach it?
Best Practices for Automating Power BI Dataset Refresh and Monitoring Failures
Hi everyone, I'm exploring different approaches to managing automated semantic model refreshes and monitoring failures across multiple Power BI workspaces. For organizations managing several reports and data sources, maintaining reliable refresh schedules and identifying failures can become challenging as the environment grows. I'm particularly interested in how teams are approaching the following: Are you primarily using Power BI's native scheduled refresh capabilities, Power Automate, or REST APIs for refresh orchestration? How are you implementing centralized monitoring and automated notifications when refreshes fail? What strategies work best for handling refresh dependencies and retries without triggering duplicate executions? Are there recommended approaches for integrating Power BI refresh monitoring with existing enterprise automation workflows? I'm interested in understanding which approaches are most practical for environments with multiple workspaces, particularly when reliability, maintainability, and operational visibility are priorities. Would appreciate any recommendations, architecture patterns, or real-world implementation experiences. Thanks in advance!
Data Analyst Growth Path: Seeking Guidance After Passing PL-300 Exam
I’m excited to share that I recently passed the Microsoft PL-300 exam, which has been a significant step in my journey as a Data Analyst. To prepare, I relied heavily on a practice test Designed by P2PCerts' that helped me understand the exam format and strengthen my skills. The preparation process gave me valuable insights into data visualization, transforming raw data, and creating effective reports using Power BI. Now that I’ve achieved this milestone, I’m looking to further enhance my career in data analytics. I’d love to hear from the community: What certifications, skills, or tools should I explore next to stay ahead in this field? Any recommendations for advanced data analytics techniques or technologies to focus on? Your advice and insights would mean a lot as I plan my next steps. Thanks in advance!What Are the Best Practices for Embedding Power BI Reports into Custom Business Applications?
Hi everyone, I'm exploring best practices for integrating Power BI reports and dashboards into custom business applications, particularly enterprise portals, SaaS platforms, and internal management systems. Power BI Embedded and REST APIs provide several integration options, but choosing the right architecture can become challenging when applications need secure access, user-specific reporting, and reliable performance. I'd appreciate insights from developers who have implemented Power BI in production applications. A few questions: Power BI Embedded: When would you recommend the app-owns-data model versus the user-owns-data model? Authentication: What are the recommended approaches for handling Microsoft Entra ID authentication, service principals, and embed token generation? Data Security: How do you implement row-level security (RLS) when multiple customers or departments access reports through the same application? REST API Integration: Which Power BI REST APIs have been most useful for automating report management, workspace operations, and integration with backend services? Performance and Scalability: What practices help maintain responsive embedded reports as application traffic and data volumes grow? I'm especially interested in real-world implementation experiences involving custom web applications built with technologies such as React, .NET, or Node.js. Would you recommend a centralized Power BI embedding service, or should each business application manage its own authentication and report integration? Thanks in advance for sharing your experience!403 GraphQL API
Hi Team, We are integrating the Microsoft Fabric API for GraphQL with Salesforce. Our requirement is to retrieve Account data from Microsoft Fabric/Data Lake into Salesforce based on the Account_ID. Current Implementation We have successfully generated a Microsoft Entra ID access token using: Tenant ID, Application (Client) ID & Client Secret We are then calling the generated Fabric GraphQL API: https://graphql.fabric.microsoft.com/v1/workspaces/<workspaceid>/graphqlapis/<graphqlid>/graphql Sample GraphQL request: query { accounts(first: 10) { items { Account_ID } } } Request headers: Authorization: Bearer <ACCESS_TOKEN> Content-Type: application/json Issue The GraphQL API call is returning HTTP 403 Forbidden. The response body is empty/null, while the response headers contain the following error: X-PowerBI-Error-Info: ServicePrincipalIsNotAllowedByTenantAdminSwitch Based on this error, it appears that the service principal is being blocked by a Fabric tenant-level setting. Questions Could you please confirm the following: Is the above GraphQL endpoint correct for calling a Fabric API for GraphQL using a Microsoft Entra service principal? Where exactly should service-principal access be enabled - Microsoft Fabric Admin Portal / Tenant Settings or Power BI Admin Portal / Tenant Settings or Microsoft Entra ID / Azure Portal We would appreciate your guidance on the required tenant-level configuration and Fabric permissions so that we can proceed with the Salesforce integration. Thanks, Harsh ChandraNavigate 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.Select Entire Hierarchies in Power BI Personalize Visuals
Feature Request: Select Entire Hierarchies in Power BI Personalize Visuals Hi Power BI Team, I'd like to suggest an enhancement to Personalize Visuals that allows users to select an entire hierarchy from a semantic model instead of adding each level individually. For example, my semantic model contains this hierarchy: Responsible Division Hierarchy Responsible Division Responsible Cost Center Currently, when users open Personalize this visual, Power BI correctly displays the hierarchy in the field picker. However, selecting the parent hierarchy does not add the complete hierarchy to the visual. Users must expand it and add each level individually in the correct order. Expected Behavior Users should be able to select Responsible Division Hierarchy and have Power BI automatically add the complete hierarchy to the visual, preserving the order defined in the semantic model. Individual hierarchy levels should remain selectable for users who only want a specific field. Why This Matters Personalize Visuals is designed to enable self-service reporting without requiring report editing permissions. Requiring users to manually reconstruct existing hierarchies creates unnecessary friction and assumes they understand the underlying data model. Since the hierarchy is already defined in the semantic model and recognized by the field picker, Power BI should leverage that metadata. Suggested Enhancement Allow users to select either: The parent hierarchy to add the complete hierarchy in its predefined order. An individual hierarchy level to add only that field. This would make Personalize Visuals more intuitive for business users while preserving flexibility for advanced users. Thanks for considering this enhancement!
