Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
All
I have the following problem when creating a Resource Demand v Capacity report in Power BI from data in Project Online. I am using the following tables ResourceDemandTimephasedDataSet & ResourceTimephasedDataSet. I want to show Resource Demand across a year by month with the Capacity that can then be sliced by team, resource, role. Capacity comes through in hours per day the same as the Resource Demand data, but will not adapt to the monthly view.
I suspect that the answer may lie in the relationship of the tables. When I try to connect ResourceDemandTimephasedDataSet & ResourceTimephasedDataSet it comes up with an error message stating that there are no unique columns (despite both containing ResourceId & TimeByDay). I have tried linking both by the TimeByDay column in the TimeSet table instead. It allows me to do this, but I still get the same issue. My graphs does show Resource Demand broken down by month, but the Capacity one only shows a figure by day which does not correlate as it does not round up the totals into a monthly data set.
I would have thought this is something that others will have encountered. I use the out of the box Project Online reports for team views, but this is limited to 100 users, so I really wanted to use something in Power BI instead, especially as it should give me the ability to slice the data in more ways!
Any help with this issue, much appreciated. I have been battling this for a good few hours now!
Thanks!
Paul
Hi,
I am having slow refresh time with using this data set in Power BI desktop. Can you share how you are able to refresh quicker? It would be much helpful to me.
Hi @Anonymous,
How did your table relationship link? Can you please share more detail information to help us clarify your scenario?
How to Get Your Question Answered Quickly
In addition, you can also take a look at the following links about creating a bridge table to link fields who not exist unique values and how to build a relationship between multiple columns.
How to Join Many to Many with a Bridge Table in Power BI
Relationship in Power BI with Multiple Columns
Regards,
Xiaoxin Sheng
Hi
Sorted this now, had to link on date field.
Thanks
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
76 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |