Forum Discussion

Rob_H68's avatar
Rob_H68
Copper Contributor
Oct 31, 2023

Roadmaps tables missing after installing Project for the Web in a new environment

I've just installed Microsoft Project Service core and the Project Management Office Accelerator to a new environment. This appeared to be successful (apart from a known error with one of the flows in the Accelerator), and I and was in the process of setting up a PowerBI dashboard from the template when I encountered a "key didn't match any rows in the table" error, affecting all the Roadmap tables:

 

Checking the tables in the environment, I find no tables matching msdyn_roadmap, while they are present in the default environment. I find 24 tables matching msdyn_project in both environments.

Have I missed a step, or is there something else going on? I do notice that there are two entries for Microsoft Project Service Core under Resources > Dynamics 365 apps in Power Platform Admin Center

(I didn't notice this when carrying out the initial install). Going into Details for each of these, I can't see any difference:

Thanks,
Rob

Business Intelligence
Project
Reporting
  • RodFromm's avatar
    RodFromm
    Oct 31, 2023

    Rob_H68 The issue is Roadmap is only available in the default environment, which is a different url that your named instance. If you want Project for the Web and Roadmap reports in the same set of reports:,

    1. Open the .pbix file
    2. Go to Power Query
    3. Create a new Roadmap URL parameter with address
    4. For each Roadmap query, update the Source line with new Roadmap URL parameter
    5. Refresh queries
      FYI - There is already an idea submitted to allow Roadmaps in a named environment, click the link and vote Deploy Roadmap in a different environment · Community (microsoft.com)



  • RodFromm's avatar
    RodFromm
    Steel Contributor
    Oct 31, 2023

    Rob_H68 The issue is Roadmap is only available in the default environment, which is a different url that your named instance. If you want Project for the Web and Roadmap reports in the same set of reports:,

    1. Open the .pbix file
    2. Go to Power Query
    3. Create a new Roadmap URL parameter with address
    4. For each Roadmap query, update the Source line with new Roadmap URL parameter
    5. Refresh queries
      FYI - There is already an idea submitted to allow Roadmaps in a named environment, click the link and vote Deploy Roadmap in a different environment · Community (microsoft.com)



Resources