OfficeDev/Project-Power-BI-Templates

Task URL

Closed this issue · 1 comments

TheThettinger commented

Anyway to pull the Task link to create a Task URL?

sadanapriyanka commented

@TheThettinger Please follow these steps to add Task URL.

  1. Open transform data in Power Bi Desktop.
  2. Select the "Project Tasks" table.
  3. Add a new custom column. In the editor window, enter: "https://project.microsoft.com/?org="& Text.Middle(#"Dataverse URL",8)& "#/taskboard?projectId="&[Project ID]& "&taskId="&Text.Upper([Task ID])

Let us know if this helps.