Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

MS Project for the Web Power BI Template - Resource Demand

Hello;

 

I am new in Power BI and I am kinda stuck working with the MS Project template. Right now I'm working on the Resource Availability report, and appears empty.

 

 

Analyzing the data, I figured out that the ResourceDemandTimephasedDataSet is empty, meaning that there is no demand for any of my resources.

 

 

I have been searching for a solution in internet, and the only recommendation that I got, it was to make sure to have baseline created, and of course every project have it, the other reports that use baseline information (like cost report) are working fine. 

 

Any ideas that may help me? Thanks in advance

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

     

    I had a similar issue. I'm using Project for the Web App (PWA or Project Online) and the same Power Bi template you are using.

     

    2 things I had to do

    1. ensure I had assigned resources to specific tasks in MS Project with some work assigned.

    2. turn on the refresh for the Timephased Resource data setting in PWA. (see below).

     

    Hope this helps. If not, let me know. I've been troubleshooting my way through setting up PWA and Power Bi so I might have other suggestions.

     

     

     

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi Anonymous 

     

    See if these links help:

    Monitor Resource Allocation with Project Power BI Template - Microsoft Tech Community

    Building reports and dashboards with Project for the web - UMT360

     

    If you go to Power Query  Editor through Home > Transform data and select the 'ResourceDemandTimephasedDataSet' table in the Queries pane, does this query return any data? Are there any transformation steps applied to the query to filter the data? You could try transforming queries to return the data you want. 

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Jing, thanks for your replay.

       

      Answering your quiestions

       

      'ResourceDemandTimephasedDataSet' table did have some transformations applied, but the table is empty even in its raw form. So, the query doesn't return any data

       

       

      About the link you share, thanks again. However, this information works for the Project Online template (the  informartion repository is in dynamics). In my case, I am working with the Project Web App template (the information repository is in sharepoint), and the source has not a “Resource Assignment Staging” table.

       

      I'll keep looking for a solution.

       

      Regards