📔
TPW Staff Resources
  • About This Wiki
  • Staff Resources Read-Only
  • General
    • Acronym Lookup
    • Technology Service Requests
    • UKG Timesheets
  • Video, Chat, and Collaboration
    • Microsoft Teams
      • Creating Meetings
      • Joining Meetings
      • Chat
      • Creating Teams
      • Teams Channels
    • Miro
    • Using Box.com to Share Large Files
  • Working Remotely
    • Getting Started (revise this..)
    • Citrix Receiver
      • Connect from Outside the COA Network
      • Connect from Inside the COA Network
    • NetMotion
    • GoToMyPC
    • Working Remotely from a Mac
      • Troubleshooting AnyConnect for macOS Catalina
      • Resetting Your Network Password from a Mac
  • Computer Management
    • Managing your Network Password
    • ANTI-VIRUS for Computers not Connected to the City’s Network
  • Phone Resources
    • Checking Voicemail | Non-COA phone
    • Checking Voicemail | COA phones
    • Masking personal phone number when calling external numbers
    • Display your COA phone number when calling from your cell phone
    • Phone Forwarding (EC500)
    • Phone Forwarding Alternative (Avaya OneX Communicator)
    • Avaya IX Workplace Setup and User Guide for Mobile Phone
    • Voicemail to Email (Avaya Unified Messaging)
  • Power BI
    • Getting Started
    • How-To
      • Access Power BI Premium Workspace
      • Create a new premium workspace in Power BI
      • Connecting to a Dataflow
      • Access On-premise Data Gateway
      • Publish public link for Power BI item
    • Handover Checklist
      • SMD Signs and Markings Performance Measures
    • Power Query and DAX Formulas
      • Calculate Fiscal Year
      • Conditional Format using DAX
      • Percent Complete on Time
  • Solutions Menu
    • Offerings
    • Do you know about MS Forms?
    • Need a Smart form for public intake?
    • What can SharePoint do?
    • So you need a dynamic Report & Dashboard?
    • What we can build in Knack
    • Need a custom solution?
Powered by GitBook
On this page
  • How to connect to a dataflow:
  • TPW 3-1-1 Service Requests Dataflow
  • Moped Dataflow

Was this helpful?

  1. Power BI
  2. How-To

Connecting to a Dataflow

PreviousCreate a new premium workspace in Power BINextAccess On-premise Data Gateway

Last updated 9 months ago

Was this helpful?

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

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

  2. Click connect

  1. Browse the workspaces folder for existing dataflows

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

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.

Selecting dataflows under "Get Data"
Authenticating and connecting to the dataflow
Loading the dataflow's table