Project Online Roadmap not visible in Power BI Template

[NMehta]

Hi,

I have a client who wanted to integrate Project Online with Power BI. I downloaded the Project Power BI template from  https://docs.microsoft.com/en-us/project-for-the-web/connect-to-project-for-the-web-data-through-pow...

followed the steps and the reports works fine except the roadmaps. It seems like we need to enable load for the roadmaps for it to be visible in the Power BI report. When I try this and run query it gives error: Access to the resource is forbidden. I tried going to data source settings, clear permissions and again entered the credentials but the same issue. I checked the rights with my administrator and I have access to the roadmaps. Any suggestions on this issue?

Thanks,

Nupur

[v-diye-msft · Accepted solution]

Hi @NMehta 

Check this blog whether helps: Enabling Roadmap Data in the Project for the web Power BI Template

[sswanson]

Looks like the old link might be broken - here's the new link:

https://www.senseiprojectsolutions.com/insights/enabling-roadmap-data-in-the-project-for-the-web-pow...

[amitchandak]

@NMehta , refer if these can be a bit of help

https://www.youtube.com/watch?v=yAGej903VO8

https://www.youtube.com/watch?v=NSwPx7QlltQ

https://www.youtube.com/watch?v=8pa1edRefto