Summary


This article describes the Database Query to Power BI Workflow. This Workflow is used to produce a PowerBI Dataset from a database query and deliver to the Power BI Server.


Select New > Workflow > DBQuery to Power BI



1- DB Query

  • Select a Database Connection and Continue
  • Select a Query or Create New Query
  • Select Continue



2 - Parameters

  • Add one or more semicolon delimited values
  • Select Continue



3 - Delivery

  • Select a destination Power BI Platform
  • Select a destination Workspace
  • Select Continue


Options

  • File Name: Enter a static file name or select the M icon to create a file name using macros
  • Replace: Uncheck to prevent replacement of existing file
  • First Row Headers: Uncheck if first data row is not column headers
  • Warn if empty (do not create): Select this option to prevent delivery of an empty Dataset



4 - Schedule

  • When: Select and configure a Schedule frequency
  • Select Continue



5 - Summary

  • Workflow Summary: Summary of Workflow configuration
  • Run Now: Run Workflow on demand
  • Unwrap Workflow: Administrator-only option to split Workflow into its component parts (Document/Burst/Schedule)