From the course: Project Online Reporting with Power BI

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using parameters

Using parameters

From the course: Project Online Reporting with Power BI

Start my 1-month free trial

Using parameters

“

- [Instructor] In Power BI, it's easy to control the URL or the data source connection in a single place. That way, end users can use it across multiple table sets without having to edit it for each table. To do that, we're going to go to our home ribbon and select edit queries. In the query editor, we'll select manage parameters and new parameter. We're going to create a single parameter that we can use across multiple tables. So we'll call it our PWA URL and in the description, we'll give somebody a hint about what they might want to do with this. So we'll say type your PWA URL in the following format. Since we want people to put it in the way it needs to be selected here, we'll put in https, we'll put in a tenant name, dot sharepoint dot com slash sites slash PWA URL name. This way, they'll have an idea about how the format should go in in the box when they get prompted to open that particular report. Since…

Contents