Connect to PowerBI SQL Query

If you are a Power BI user and want to connect data sources from your Power BI environment to Strategy Mosaic, you can use the connectors available through your Power BI license, such as Starburst. Be aware that it is your responsibility to ensure compliance with the license terms and conditions that apply to any third-party software, services, or tools you use.

Use the Starburst Enterprise connector to connect Strategy to PowerBI for SQL queries. This connection supports Standard and LDAP authentication types.

Prerequisites

• You must have the Use Universal Access and Use Application PowerBI privileges.

• Download the Starburst ODBC driver and install it on the machine where PowerBI runs.

• Cognitive search index must be enabled. For more information, see Cognitive Search.

Connect to PowerBI SQL

1. Open PowerBI.

2. Click Get data from other sources.

3. Click Get data from another source.

4. Find and select Starburst.

5. Click Connect.

6. In Host, type your Strategy environment URL. For example, xxxxxx.cloud.microstrategy.com.

7. In Port, type 443.

8. In Data Connectivity mode, choose DirectQuery.

9. Click OK.

10. Type your User name and Password.

11. Click Connect.

12. Expand your data and select the check box next to the tables you want add to PowerBI.

13. Click Load and view your Strategy data in PowerBI.