Connecting to a Dataflow

Dataflows are a type of data source that enables many Power BI reports to reference a single source of truth. Instead of configuring all of the connection parameters for a dataset yourself, you can utilize a dataflow that has been created by someone else in a workspace.

How to connect to a dataflow:

1. Open Power BI desktop and create a new report

2. Under the home tab, Click Get Data -> Dataflows

Selecting dataflows under "Get Data"

1. You may have to log-in with your COA credentials

2. Click connect

Authenticating and connecting to the dataflow

1. Browse the workspaces folder for existing dataflows

2. Select the table(s) you wish to import to your report and click load

Loading the dataflow's table

TPW 3-1-1 Service Requests Dataflow

This dataflow is housed in the TPW - Production workspace. If you do not have access to the workspace follow the steps here. This dataflow is already configured to be refreshed daily with the latest 3-1-1 service requests for the department. The data dates back to October 2021 and more details about it can be found here.

Moped Dataflow

The Moped dataflow is also housed in the TPW - Production workspace. If you do not have access to the workspace follow the steps here. It contains two tables, one with Moped project-level data and one with component-level data. It is refreshed daily at 2AM.