Please follow the below steps for configuring Power BI Data Flow in Power BI Service.
Pre-requisites:
- A workspace setup with Power BI Premium or Pro account.
- BI Connector Server edition installed on the Power BI Gateway machine.
Steps to create Power BI Data Flow:
- Install the BI Connector Server Edition on the Gateway machine and configure the BI Connector DSN using the steps here
- In your Power BI Service via browser, navigate to any workspace setup with Power BI account, and click New and select DataFlow
- Click Get Data and Select ODBC
- Enter the DSN you created using the BI Connector Driver in the ODBC Connection string field in the following format:
dsn=DSNyouCreated
For example, if your DSN name is "OBIEE SA", you should enter the ODBC connection string as "dsn=OBIEE SA"
- Select the Gateway, and the Authentication Kind, and enter the credentials if required, and click Next.
Now you'll be able to connect to your OBIEE data source and setup the Dataflow on Power BI Service.
If you have any questions or issues creating a report, we are just a click away. Contact us at [email protected] or file a ticket at our support portal.