interesting links
7389 Topics
left join dax
I have two tables store and clients; no relations between them. I must not have physical relationship, I prefer virtual. And the report have a many slicers: Year, region, country from clients. So the visual have four columns. region (clients) Country (clients) sales (clients) inventory (store) and table store have year region Country inventory Dax measure: NATURALLEFTOUTERJOIN (store, clients) The principal idea is inventory is actually a measure (e.g. left outer join) to get the total in each sublevel: country, region passing the selected value from slicer. Actually I get the total from all years in measure "inventory". I don't get the context to compute (left outer join) :( . I figure out is about the missing relation between tables. Any ideas? thanks in advance.51Views2likes4Comments
Color Coding Issue
I have a PBI report in which I am using a tree map visual and I have coded few brands but for rest which i dint coded is having duplicate color issue, I am searching for a optimised solution for color coding where instead of doing it manually i can do it in some other optimised way.59Views2likes2Comments
How to get the internal Page Name and Visual Name for Power Automate
Hi everyone, I am trying to automate a daily Power BI report email using Power Automate. My requirement is: Power BI Report ↓ Power Automate ↓ Export a specific Power BI visual as PNG ↓ Embed the image in an HTML email ↓ Send the email daily I already have an existing Power Automate flow that sends an HTML table successfully. Now I also want to include a Power BI chart below the table in the same email. I am using the Power BI action: "Export To File for Power BI Reports" I have selected: - Workspace - Report - Export Format = PNG The action provides the following fields under Pages: - Pagename - Visualname - Bookmark Name - Bookmark State The Power BI report has a page called "X" and the visual I want to export is called "Y". The problem is that I don't know the INTERNAL page name and INTERNAL visual name required by the Power Automate export action. My Power BI Service URL follows this format: https://app.powerbi.com/groups/<workspace-id>/reports/<report-id>/<some-id>?experience=power-bi Unlike some examples I have seen, the URL does not contain something like: ReportSection123abc I understand that the Power BI API uses an internal page name that is different from the visible page name. My questions are: 1. How can I retrieve the internal page name for page "X" in the current Power BI Service experience? 2. How can I retrieve the internal visualName for visual "Y"? 3. Is there a recommended way to get these values without manually inspecting browser/developer tools? 4. Can I use the Power BI REST API / Get Pages API to retrieve the internal page name and then use that value in Power Automate? 5. Is there a Power BI/Power Automate connector or API that can retrieve the visual names using getVisuals or another method? Any guidance would be greatly appreciated. Thanks!Solved84Views0likes6CommentsAnti join custom query
Hi community, in ths time., I have two tables A y B, the tbale A have some columns are ID_CITY, ID_STATE, ID_COUNTRY, ID_YEAR, DESCRIPTION_MESSAGE, COUNT_PEOPLE, the other table B the columns are: ID_CITY, ID_STATE, ID_COUNTRY, ID_YEAR, ANNUAL_INCOME, AVERAGE_HEIGH, PERFORMANCE_SCORE, So with the anti right join (ID_CITY, ID_STATE, ID_COUNTRY, ID_YEAR) in power is get the rows than exists in table B but they don't in table A, so with the result create a "new records" with the same structure that table A and append this records in A. is this possible? custom function required? thanks in advance.Solved96Views0likes5Comments
Migrating Reports from Tableau to Power BI
HI Team, We are plannig to migrate report from Tableau to Power BI from April 1st. When, i check the previous discussion on any helping tools to migrate reports from tableau to power bi. First, currently do we have any tools to migrate report? Second, any alternative suggetion to to reduce the efforts to migrtae 100 dashboards. I appreciate the help Thank you in advance!Solved38KViews3likes20Comments
Connect Power BI to SAP Hanna On SAP Cloud
Hello All, Anyone has ever connect SAP Hanna present on SAP Clound, on premises SAP Hanna can be connected using the SAP connector available under the databases in Power BI. But i am looking for an option to connect SAP Hanna which is deployed on SAP Cloud. Appreciate your help 🙂 Regards, Chayan UpadhyaySolved7.2KViews0likes3Comments
Power 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!Solved21KViews2likes4Comments
