Forum Discussion
Using PowerBI with Project for the Web - Reporting on Summary Tasks and associated SubTask progress
Hey Amit,
Thanks for the response. I have now realised that the tables and fields pulled in by the PowerBI template for Project on the Web are not complete. Pulling in the full dataset allows me to use a parent task field which effectively gives me a workaround for this.
Thanks again
J
Hey Amit,
Thanks for the response. I have now realised that the tables and fields pulled in by the PowerBI template for Project on the Web are not complete. Pulling in the full dataset allows me to use a parent task field which effectively gives me a workaround for this.
Thanks again
J
How do you mean "pull in all data" - please can you elaborate? I am having the same problem. Thanks.
Hi Nozama,
The default PowerBI template does not include all database tables. Changing this and adding in all tables (initially and while you're building your dashboards) allows you to access all of the fields used in Project for the Web.
Does that help? Happy to try to elaborate if you need me to.
J
If you could please elaborate that would be great! Currently the Project Dashboard takes input from PWA workspace (Project Online) and the respective Dataverse URL. So if there are tables missing - what additional source did you add to add those tables?!
