# Connecting to a Dataflow

[Dataflows](https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service) 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

<figure><img src="/files/umVA0TZKuL2ObcheJZWR" alt="" width="339"><figcaption><p>Selecting dataflows under "Get Data"</p></figcaption></figure>

3. You may have to log-in with your COA credentials
4. Click connect

<figure><img src="/files/k6VRfj6v78sIgk94Izr8" alt="" width="375"><figcaption><p>Authenticating and connecting to the dataflow</p></figcaption></figure>

5. Browse the workspaces folder for existing dataflows
6. Select the table(s) you wish to import to your report and click load

<figure><img src="/files/NX6Mf3nh7UjujTwaW1s6" alt="" width="375"><figcaption><p>Loading the dataflow's table</p></figcaption></figure>

## TPW 3-1-1 Service Requests Dataflow

This [dataflow](https://app.powerbigov.us/groups/d72985fd-9dd6-4252-9c5d-19e9f489655d/settings/dataflows/f0d87055-f358-4dc0-9a1f-ee6eac645590) is housed in the `TPW - Production` workspace. If you do not have access to the workspace follow the steps [here](/tpw-staff/power-bi/how-to/access-power-bi-premium-workspace.md). 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](https://datahub.austintexas.gov/Transportation-and-Mobility/Transportation-and-Public-Works-311-Service-Reques/38mr-dwji/about_data).

## Moped Dataflow

The [Moped dataflow](https://app.powerbigov.us/groups/d72985fd-9dd6-4252-9c5d-19e9f489655d/dataflows/79ee0b40-81c0-4390-87f9-fc64eb7a172c) is also housed in the `TPW - Production` workspace. If you do not have access to the workspace follow the steps [here](/tpw-staff/power-bi/how-to/access-power-bi-premium-workspace.md). It contains two tables, one with Moped project-level data and one with component-level data. It is refreshed daily at 2AM.&#x20;


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://atd-dts.gitbook.io/tpw-staff/power-bi/how-to/connecting-to-a-dataflow.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.