Preview Feature: Connect to PowerBI DAX 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.

Preview features are early versions of features and are not to be used in a production environment as the core behavior remain subject to change between preview and GA. By selecting to expose preview features, you can access and use them as you would any other functionality. The official versions of preview features are included in subsequent releases. For access to this feature, contact your account team.

Connect to Power BI DAX Query via Connector

Prerequisite

You must have the Use Universal Access and Use Application Power BI privileges.
Cognitive search index must be enabled. For more information, see Cognitive Search.

Retrieve Token Based Access for Power BI DAX Query

Ensure Library has OAuth enabled and that the environment has a trust relationship created. For more information, see Universal Semantic Layer Environment Configurations.
In the Library left Navigation pane, click Data.
Locate your data model and click Additional Information .
Next to Power BI URL, click Generate and click Copy.
Open Power BI.
Click Get data from other sources.
Click Get data from another source.
Find and select SQL Server Analysis Services database.
Click Connect.
In Server, paste the URL you copied in step 8.
Click OK.
Expand your data and select the check box next to the tables you want add to Power BI.
Click Load and view your Strategy data in Power BI.

View in PowerBI Based on Token Auth

You can also package your Strategy data model and Power BI DAX query connection into a .zip file to directly access the Mosaic model in Power BI desktop by opening the .pbir file.

Prerequisite

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

Download Package File

In the Library left Navigation pane, click Data.
Right-click a data model and choose View in Power BI.
After the model downloads, unzip the package.
Locate the definition.pbir file.

Do not move the .pbir file outside of the delegated folder. If you move the file to another folder with more content (for example, your machine's Downloads folder), Power BI will read the entire folder as a project and an error will occur.
Double-click the file to open the data model in Power BI.

Troubleshooting Tokens

To manage token lifetime:

In Workstation, right-click an environment and choose Properties.
In the left pane, click Library.
In Mosaic Universal Access, type a value in minutes. Administrators can enter a value between 1 and 43200 (30 days).

The default value is 1440.
Click OK.

If the token expires after opening the .pbir file and Power BI displays an Unable to connect dialog:

In the Library left Navigation pane, click Data.
Locate your data model and click Additional Information.
Next to Power BI URL, click Generate and click Copy.
Open Power BI.
In the Unable to connect dialog, click Edit.
In Server, paste the new Power BI URL.
Click OK.