Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt
hiddentrue


...

ControlDescription
DashboardName your dashboard. Users will see this name from their home page or performance dashboards.
IDs

To display a Power BI dashboard, the required IDs have to be entered. These IDs are a part of the URL for the published Power BI dashboards. Please refer to the above doc for further details 

  1. Find the dashboard in Power BI Workspace
  2. Copy parts of the URL
  3. Go to Plain Dashboard tab
  4. Enter the details along with the IDs and hit Save.

When a dashboard has an alias, it does not need to be explicitly shared to a user for viewing. Think of an alias as a way of publishing a dashboard to anyone viewing it via My Home Page.

Parameters

Parameters are used to filter a dashboard down to show specific data. The most common use case is to have a dashboard that shows data about many users, but when viewed via My Home Page it only contains data about the current user. To accommodate this, the following special short codes are supported.

  • {0} - Primary User Type Name
  • {1} - Resource Display Name
  • {2} - Resource Cost Center Name
  • {3} - Resource Cost Center Number
  • {4} - Resource Company Name
  • {5} - Resource Company Number
  • {6} - Primary User Type Unique Identifier
  • {7} - Resource Unique Identifier
  • {8} - Resource User Unique Identifier
  • {9} - Resource Cost Center Unique Identifier
  • {10} - Resource Company Unique Identifier
  • {11} - Authenticated User Unique Identifier
  • {12} - Authenticated User Display Name
  • {13} - User’s Client Number

  • {14} - User’s Client Unique ID

  • {15}  - Primary User Type Cost Center Name

  • {16}  - Primary User Type Cost Center Number

  • {17}  - Primary User Type Cost Center Unique Identifier

Parameter filters only work if they are perfectly matched to a filter defined in Power BI. To add a filter, please refer to the above doc for further details.

You are actually building a querystring here, so you can define multiple filters by using the "and" function. For example, DIM_Resource/Resource_x0020_Display_x0020_Name eq '{1}' and DIM_Project/Project_x0020_Code eq '{0}' 

You can also set up filters on external data sources by building an interim mapping table that maps something like resource display name to these other fields. For instance, if resources/users happen to own different products that are modeled as project UDFs, you might need to map name -> product in an interim mapping table and then link that to the project UDF.