search

OfficeDev / Project-Power-BI-Templates

Expand Project with a Power BI Template
216 stars 77 forks source link

Task URL #16

Closed TheThettinger closed 3 years ago

TheThettinger commented 3 years ago

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

sadanapriyanka commented 3 years ago

@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.