Please follow the below steps for configuring Power BI Data Mart in Power BI Service.
Pre-requisites:
- A workspace setup with Power BI Premium (Per Capacity or Per User) account.
- BI Connector Server edition installed on the Power BI Gateway machine.
Steps to create Power BI Data Mart:
- 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 Premium account, and click New and select Datamart(Preview)
- Click Get Data and Select ODBC
Note: ODBC way of connection supports Import Query mode only.
- 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 Datamart on Power BI Service.
Please refer How to create datamart using OBIEE subject areas and table? for creating specific datamarts.
We have raised an Idea in Microsoft Power BI to include BI Connector in the Data Source list. Please Upvote to implement our idea.
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.