Add separate parameter for Roadmaps URL to avoid "key didn't match any rows in the table" errors when project is deployed into a new environment

[RobH-CRT]

For anyone deploying Project for the Web to a new environment, they will encounter an issue when using this template:

Microsoft has not currently provided a way to deploy the Roadmaps solution to a new environment. This means that tables matching msdyn_roadmap, referenced in the template, will only exist in the default environment. The result is that users will get multiple "key didn't match any rows in the table" errors, and data refresh will fail.

I propose that a separate Roadmaps URL parameter should be added to the template, and this used to connect to the Roadmaps tables.

For anyone experiencing the issue with the current version of the template,the workaround is:

1. Open template in PowerBI Desktop, and enter URL for PfW environment (as usual).
2. Cancel data refresh (this will only error anyway).
3. From the top ribbon, select Transform Data.
4. In the PowerQuery editor, select Manage Parameters > New

• Name: Roadmaps URL
• Type: Text
• Current value: Paste in the URL for the Default environment (from Power Platform Admin Center)

5. Go to each of the Roadmaps queries in turn:

• Click Advanced Editor on the toolbar
• Replace #"Dataverse URL" in the first line with #"Roadmaps URL"

6. If any of the queries still show a yellow warning triangle and/or a warning message that refresh was cancelled:

• Go back to the query and click "Retry" in the main pane
• Wait for the preview data to be loaded