Unable to create relationship
Hello PowerBI and DAX gurus, My end goal is to create a measure where I want to get the SUM of ([Hourly Rate] x [Number of Hours]) of each employee who works in that LOB in a given month. However, before I can even reach this goal, I am stuck in creating the relationship. As screenshot show below, I am trying to create a relationship from LOB[EmpName] to Payroll[EmpName] and Timesheets[EmpName], but unable to (2nd screenshot below shows the "error" message) Thus may I know what's the solution so that at the end, I'm able to create a measure where based on the LOB (whether it's from [Shipped Month End Order], [dimLOB] or [LOB] table), I am able to get the correct calculation of salary paid, which comes from Payroll and Timesheets by employee and LOB. A little explanation of the tables Shipped Month End Order - This is a fact table where it shows Line of Business (LOB) code and customer Payroll - This is a fact table where it shows the Employees with the Hour Types (Regular, Vacation, Sick, Stat Holiday, Overtime etc) in a given period (not date but period. A period is 1 week of calendar date). I have created a column 'EOM Date' in order to capture the total number of hours at the end of the month Timesheet - This is a fact table where it shows the Employees with their hourly rate by each date LOB - This is a fact table where it shows the Employees and it's allocations who work in a given LOB. i.e. Employee A, B, C and D works at LOB 1000 at 10%, 20%, 30% and 40%. This means that Employee A works only 10% for LOB 1000. Now assuming if model and relationship works, what I had in mind of what the measure to calculate is. Determine the LOB (i.e. from [dimLOB] or [LOB] table) and Date (from dimDate) Find out who are the employees who work in that LOB and in that month of date Get the Hourly Rate of those employees in that month of date Get the Number of Hours worked for those employees in that month of date Multiply the Hourly Rate and Number of Hours and SUM them for each employees in that month of date Note here that LOB are data shown in the visualization table down the row Note here that Date is "captured" via Slicer I have shared the URL link to my google drive and hopefully you can download it. Note that if you were to go to Power Query, it'll fail as source data is from both my local drive and sharepoint. Thank you in advanced for your help Power BI file
Power BI semantic model refresh fails in Service, but Gen1 dataflow and Desktop refresh successfully
Hi everyone, my semantic model refresh fails in Power BI Service with this error: DataFormat.Error: The input couldn't be recognized as a valid Excel document. Microsoft.Data.Mashup.ErrorCode = 10311. The exception was raised by the IDbCommand interface. However: The Gen1 dataflow refreshes successfully. The model also refreshes successfully in Power BI Desktop. I’ve reviewed the Power Query queries and couldn’t find any problems. The failure appears to happen only when refreshing the semantic model in Power BI Service. What could cause this difference, and how can I identify the specific query or source triggering the error? Error details: Cluster: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net Activity ID: 76273612-20ed-4ca2-988e-4f593db29fa5 Request ID: 42e32479-4c91-40cf-b83c-e1ebd9591dc4 Time: 2026-09-15 20:18:51 UTC Any help would be appreciated.Backward Deployment
Hello ! I have a deployment pipeline in this order : A (Development) -> B (Preproduction) -> C (Production). This is the standard order of the workspace, but there were some reports that have been created directly in B, so is it possible to deploy from B to A? without unassigning the worskpace from the actual pipeline. Thank you.
Need "Edit Report" Activity for published report
I'm trying to find a method to determine whether a published Power BI report has been edited directly in Power BI Service, and if so, identify: Who made the change When the change was made Which report was modified What audit activity/event indicates the modification I've already explored the Power BI Activity Log using Get-PowerBIActivityEvent and reviewed the available Activity and Operation values. However, I don't see an event such as UpdateReport or anything that clearly indicates that a report was edited and saved in the Service. My questions are: Is there any audit event that specifically indicates a report was edited in Power BI Service? Can Power BI/Fabric Audit Logs show who modified a published report? Is there a way to identify changes made to report visuals, filters, pages, or layout after the report is published? Has anyone implemented an external monitoring solution (REST APIs, metadata snapshots, deployment pipelines, Git integration, etc.) to detect report modifications? Any guidance, best practices, or real-world experience would be appreciated. Thanks in advance!What are the Benefits of using Power BI for Data Center Management
Using Microsoft Power BI for data center management offers several benefits, including: Real-time Monitoring: Power BI allows you to connect to data sources from data center infrastructure, such as servers, switches, and storage devices, to monitor key performance indicators (KPIs) in real-time. This enables you to quickly detect and address any issues or anomalies, ensuring optimal performance and uptime for your data center. Data Visualization: Power BI provides rich visualizations, including charts, graphs, and dashboards, that allow you to visually represent complex data center data in an easy-to-understand format. This enables data center managers to gain insights at a glance, identify trends, and make data-driven decisions to optimize data center operations. Customizable Dashboards: Power BI allows you to create customizable dashboards that can be tailored to the specific needs of your data center. You can create personalized dashboards for different stakeholders, such as IT managers, operations teams, and executives, providing them with the relevant data and insights they need to effectively manage the data center. Data Consolidation: Power BI can integrate data from various sources, such as servers, databases, virtualization platforms, and environmental sensors, into a single, consolidated view. This enables data center managers to have a holistic view of the data center operations, identify patterns or anomalies across different data sources, and make informed decisions based on the complete picture. Predictive Analytics: Power BI offers advanced analytics capabilities, including predictive analytics, that allow you to analyze historical data to forecast future performance and identify potential issues before they impact the data center. This proactive approach enables data center managers to take preventive actions to optimize data center operations and avoid potential downtime. Collaboration and Sharing: Power BI allows data center managers to collaborate and share dashboards and reports with other team members, stakeholders, and executives. This promotes data-driven decision-making and facilitates communication and alignment among different teams involved in data center management. Scalability and Flexibility: Power BI is a cloud-based solution that offers scalability and flexibility, allowing data center managers to scale up or down as per their needs, and access their data and insights from anywhere, at any time, using different devices. This enables remote monitoring and management of data centers, providing greater agility and convenience. Using Power BI for data center management provides real-time visibility, actionable insights, and improved decision-making, enabling data center managers to optimize data center operations, proactively manage issues, and ensure efficient and reliable data center performance.
Refresh Time Disparity
Hi I'm having trouble trying to get my refresh times accurate. The scheduled refresh on my report is for 0130hrs but the refresh time measure in my report shows it is happening an hour earlier at 0030hrs. I don't know which one is correct and how to make them run at 0030hrs from now on. If I changed Fig.1. to 2330hrs I'd be worried that I'm scheduling the refresh too early? Fig1. Fig.2. Fig.3Move Application from Workspace A to B
Hi all, I'd like to know if it's possible to move a Power BI App from a Development workspace to a Production workspace, rather than recreating it from scratch. Both workspaces already contain the same elements (reports, semantic models, etc.), so ideally I'd just move/publish the existing app to Production and repoint its content references to the corresponding items in that workspace — instead of building the app definition again from zero. Is there a supported way to do this? Thanks in advance!
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.
