📔
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
      • Calendar Table
      • 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 12 months ago

Was this helpful?

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

Moped Dataflow

This is housed in the TPW - Production workspace. If you do not have access to the workspace follow the steps . 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 .

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

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