Summary


This article describes the Universe to Power BI Workflow. This Workflow is used to produce a Power BI Dataset from a BusinessObjects Universe query and deliver to Power BI Server.


Select New > Workflow > Universe to Power BI



1 - Universe Query

  • Select a SAP BusinessObjects Platform and Continue
  • Select a Universe
  • Select Continue
  • Select Universe objects
  • Select Query Filters to add one or more query filters (optional)



2 - Prompts

  • Add Prompt values (if applicable)
  • Select LOV to select values from BusinessObjects
  • 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)