interesting links
422 TopicsPower BI Design Best Practices
Hello fellow developers and data enthusiasts, I've put together a comprehensive set of 12 Power BI design best practices based on my insights and explorations in the data realm. I'd love to get your thoughts and feedback on these principles! 1.Understand Your Target Audience Design a dedicated view for each sort of audience. Example: Leaders should have an executive view on what they are concerned about, whereas customers should have a low-level perspective on what they are engaging in. Before designing a view, consider the employee's kind of job; for example, providing a financial balance sheet to a non-financial employee is pointless. 2.Define Clear Objectives Always begin with an understanding of your dashboard's primary goal and the problem that needs to be solved. Example: If you're developing a sales performance dashboard, your goal may be to deliver real-time insights on revenue, sales trends, and product performance to assist sales teams in making data-driven decisions. 3.Choose the Appropriate Visualizations Choose relevant data visualizations. Example: Use a bar chart to demonstrate how different product categories contribute to overall income. Show the progression of revenue over time with a bar/line chart. A map visualization may be more successful than a pie chart for showing geographical sales data. 4.Break the problem and solve by visual Break the problem into numerous questions that address the problem, then construct each visual such that it answers at least one of the questions/doubts presented in the analysis. Example: Each visual on the Sales Dashboard should address or resolve each issue or doubt raised through the sales analysis. 5.Design with consistency Maintain consistency in design, layout, and formatting throughout every component of the dashboard for a consistent user experience. Example: Make ensure that all charts and graphs use the same color scheme or pattern of similar data points across several visuals (i.e., Profit – Green color, Loss – Red color) and maintain organizational design standards all over the dashboard. 6.Use Reports/Dashboard in the appropriate place. Develop reports when an in-depth and comprehensive examination is required, and dashboards when quick overview, executive summaries, and real-time monitoring is required. Example: Report: (Descriptive & Diagnostic Analysis) In Sales Report, what has happened in the past two years and why it has happened should be addressed. Dashboard: (Predictive & Prescriptive Analysis) In Sales Dashboard, with minimal information about what has happened and prescribing what to do in future to solve this can be addressed. 7.Ensure visibility. Maintain users informed of ongoing activities, such as data loading or refreshing. Example: Using icons or a progress bar to illustrate the state of a data refresh process, as well as indications to identify when they were last updated (to demonstrate how old the data is). 8.Design with freedom. Allow users to quickly customize data with filters, slicers, and interactive components. Allow users to rollback or undo actions. Example: Providing filter choices for date ranges (e.g., particular dates, quarters, or years) to enable different data analysis, giving drill-down charts for exploring data, and allowing users to reverse changes by providing Back navigation and clear slicers options where necessary to undo an operation. 9.Use Meaningful and Contextual Labels. To provide context and improve understanding, use clear and descriptive labels for charts, graphs, and filters etc. Example: Use terms like "Monthly Revenue Trends" or "Sales by Region" rather than "Revenue Data" or "Sales Information" instead of generic labels. 10.Use white space effectively. Make thoughtful use of white space to improve readability and identify important details. Example: To avoid congestion and promote understanding, space out graphics and text sections. 11.Improve user Engagement. To increase user involvement and study, use interactive components like as filters, slicers, and tooltips. Example: Include data slicers that allow users to filter data by date ranges or category of products, allowing for customized analysis. 12.Help the user. With pop-ups and documents, assist the user in understanding the action they are performing. Example: Including help icons with precise documentation, as well as providing tooltips to visualizations that explain the relevance of individual data points or trends. I believe these practices are crucial for creating impactful and user-friendly reports. However, I'm eager to hear about your journeys. Have you found similar principles effective? Do you have additional tips to enhance Power BI design? Your feedback is invaluable! Feel free to share your thoughts or suggest any other practices you've discovered during your expeditions in the realm of Power BI. Let's collaborate and further enrich our data voyages together!Solved21KViews2likes4CommentsArchivos de Adobe incrustados en la aplicación powerbi
En la aplicación de powerbi tenía publicados unos vínculos que hacían referencia a archivos adobe y no tenía ningún problema, los podía visualizar correctamente en la misma página de la aplicación, pero ahora me está apareciendo el error que adjunto y no sé si es problema de la aplicación, del adobe o de permisos de mi institución. Alguien tiene alguna sugerencia o idea?90Views0likes3CommentsMissing "Show data point as a table" in Power BI Service for a map visual
I have a report created in Power BI Desktop and published to the Power BI Service. The report contains a Bing map visual with bubbles sized by the number of wagons at various stations. Issue: In Power BI Desktop, when I right-click on a bubble, I see and can use the option "Show data point as a table." However, in the Power BI Service (web version), this same right-click option is missing. The context menu does not show it at all. Steps to Replicate: Publish the report with the map visual to Power BI Service. Open the report in a web browser. Right-click on a bubble on the map. Observe that the option "Show data point as a table" is absent. Additional Context: I have confirmed that this is not a report structure issue. When I download the same report from the service and open it in Power BI Desktop, the right-click option works correctly. I've also been told that this option was available in the service for this report in the past. Question: What could be the cause of this discrepancy, and is there a solution or a workaround to provide this functionality to web users? Is this a known limitation or a recent change in the service?Solved251Views1like4CommentsFree Microsoft tenant or user account.
A group of students wants to practice Microsoft Fabric (Lakehouse, Data Factory, Power BI semantic models, reports, etc.) completely for free, without needing a credit card or any paid subscription. They are looking for ways to create their own tenant or user account to hands-on experiment with Fabric and Power BI. We remember that a few years ago there was the Microsoft 365 Developer Program (E5 subscription) that gave a free tenant for 180 days (renewable). Questions: What are the current best ways in 2026 for students to get a free Fabric / Power BI practice tenant? Is the Microsoft 365 Developer Program still the best option? Does it still provide good access to Fabric? Are there other free methods (Fabric free trial, personal accounts, etc.) that don’t require a credit card? What limitations should students expect with the free options? Any recommended step-by-step guides or recent tutorials for setting this up? The goal is to give students a real environment where they can create workspaces, build semantic models, develop reports, and explore the full Fabric platform without any cost. Any current advice or successful experiences would be very helpful! Thank youSolved1.4KViews0likes3CommentsHow to Auto-Select Latest Month in Power BI Slicer (No Manual Intervention)?
**Requirement: Dynamic Default Month Selection in Power BI Slicer** I have a Power BI report with a time period slicer built on a hierarchy: **Fiscal Year → Quarter → Month** (Indian fiscal year: April–March). * The data is refreshed **monthly** * Currently, the slicer selection is being **updated manually** after each refresh --- ### **Expected Behavior** I want to make this process fully dynamic: * Whenever new data is refreshed (e.g., April data becomes available), the report should: * Automatically default to the **latest available month** in the dataset * Reflect this both in the **data displayed** and ideally in the **slicer selection** --- ### **Additional Requirements** * The logic should be **data-driven** (based on the latest available date in the fact table, not TODAY()) * **No manual intervention** should be required after refresh * Users should still be able to: * Manually select other months/quarters/years from the slicer for analysis * Reset back to the default (latest month) --- ### **Current Setup** * Date hierarchy is derived using a **Date table related to the Fact table** * No existing **“current month” or “latest month” flag** is present ---Solved927Views0likes4CommentsLogging Applied Filters in Power BI Report Server
Hi everyone, I’m currently working with Power BI Report Server and looking into ways to improve auditing and logging for compliance purposes. Is there a simple way to capture or log the filters (e.g. slicers or parameters) that a user has applied when viewing a report? Ideally, I would like to record: - The selected filters or parameters - Ideal the output - The user who executed the report - The time of execution I’m aware of the ExecutionLog, but I’m not sure if it fully captures interactive filter states from reports. Has anyone implemented something similar or found a good approach? Thanks in advance!Solved861Views0likes4CommentsCustom visual in Power BI for integration of GPT or Gemini with Power BI
I’m working on integrating ChatGPT or Google Gemini into Power BI using a custom visual to enable interactive AI responses directly from the report, based on the dataset contents. Everything works fine when I test the API in Postman, but Power BI blocks the API call from the custom visual due to security restrictions, most likely related to Content Security Policy (CSP) or cross-origin (CORS) issues. I have Tried So Far Built a custom visual in Power BI using React and TypeScript Integrated OpenAI/Gemini API logic inside the visual Created a proxy API server to forward the API requests Used tunneling tools like: localtunnel ngrok Cloudflare Tunnel I Need Help With How can I successfully connect Power BI custom visual to OpenAI/Gemini API through a proxy or tunnel? Is there a recommended tunneling or reverse proxy approach that works with Power BI visuals? Any other approaches to solve the same problem? Any guidance or step-by-step solution would be greatly appreciated! Thanks!Solved6.4KViews0likes5CommentsrsQueryMemoryLimitExceeded Error in P&L / Balance Sheet Measure (Small Dataset)
Hi Community, I am facing the following error while building a Profit & Loss report: Underlying Error: rsQueryMemoryLimitExceeded Resource Governance: This query uses more memory than the configured limit. Consumed memory: 1024 MB, Memory limit: 1024 MB. 📌 Scenario: Dataset size is small (not a large fact table). Using Import mode. The visual is a Matrix with rows from a dimension table (e.g., Schedule Order / BS Order, Year and P&L Amount). The measure uses a large SWITCH statement to return different financial measures based on selected description. P&L Amount = (SWITCH( SELECTEDVALUE('Schedule order'[Description]), " Revenue From Operations", CALCULATE( [Revenue From Operations],REMOVEFILTERS('Schedule order')), " Other Income", CALCULATE( [other income],REMOVEFILTERS('Schedule order')), "Total A.REVENUE", CALCULATE( [Total A.REVENUE],REMOVEFILTERS('Schedule order')), " Cost of Material Consumed", CALCULATE( [Cost of material consumed],REMOVEFILTERS('Schedule order')), " Purchase of Stock in Trade", CALCULATE( [Purchase of Stock in Trade],REMOVEFILTERS('Schedule order')), " Changes in Inventories of Finished Goods & Semi Finished Goods", CALCULATE( [Changes in Inventories FG],REMOVEFILTERS('Schedule order')), " Employee Benefits Expense", CALCULATE( [Employee Benefits Expense],REMOVEFILTERS('Schedule order')), " Finance Cost", CALCULATE( [Finance Cost],REMOVEFILTERS('Schedule order')), " Depreciation and Amortization Expenses", CALCULATE( [Depreciation and Amortization Expenses],REMOVEFILTERS('Schedule order')), " Other Expenses", CALCULATE( [other Expense],REMOVEFILTERS('Schedule order')), "Total B.EXPENSE", CALCULATE( [Total B. Expense],REMOVEFILTERS('Schedule order')), "Profit Before Exceptional and Extraordinary items and tax", CALCULATE( [Profit before 16],REMOVEFILTERS('Schedule order')), "Exceptional Items", CALCULATE( [Exceptional Items],REMOVEFILTERS('Schedule order')), "Profit before extraordinary items and tax", CALCULATE( [profit before 20],REMOVEFILTERS('Schedule order')), "Profit before extraordinary items and tax", CALCULATE( [profit before 20],REMOVEFILTERS('Schedule order')), "Tax Expense", CALCULATE( [Tax Expense],REMOVEFILTERS('Schedule order')), "Extraordinary Items", CALCULATE( [Extraordinary Items],REMOVEFILTERS('Schedule order')), "Current Tax", CALCULATE( [Current Tax],REMOVEFILTERS('Schedule order')), "Deferred Tax", CALCULATE( [Deferred Tax],REMOVEFILTERS('Schedule order')), "Profit After Tax", CALCULATE( [Profit Befor 27],REMOVEFILTERS('Schedule order')), "Profit (loss) from the period from continuning operations", CALCULATE( [profit 30],REMOVEFILTERS('Schedule order')), "Profit/(loss) from discontinuing operations ( after tax)", CALCULATE( [profit 36],REMOVEFILTERS('Schedule order')), "profit/ (loss) for the period", CALCULATE( [Profit 38],REMOVEFILTERS('Schedule order')) ))+0Solved1.6KViews1like4CommentsHow to add Power BI action bar in embedded applications for your customers(App owns data) ?
I am embedding reports for customers in ISV Application. They want an Action bar that has a share, export and subscribe option. Is it possible for customers(App owns data)? If yes then how?3.1KViews1like5CommentsGit integration without Fabric capacity
Hi, I'm starting to learn how to use Git to version control my power bi reports. We don't use Fabric. We chose Snowflake instead. Based on YouTube content, most videos show that when you have Fabric you can sync a power bi workspace with Git. My question is what do you do in the case you don't have Fabric? thanksSolved2KViews0likes6Comments