Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
Anonymous
Not applicable

Resource data from Project Online in PowerBI

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

3 REPLIES 3
Sunnie
Helper I
Helper I

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. 

v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Hi

Sorted this now, had to link on date field.

Thanks

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.