Writing Reports Using Power BI Service

Separating Report Definitions from Data Model in Power BI

You can switch from an Import Mode .pbix file to a cube connection by following the steps outlined in the Guy in a Cube video linked below. Supporting materials are included in the github link.

*You will need the ability to create an Azure App.

1. Create a blank report (an import data model .pbix file) and publish to a workspace.
2. Log into the Azure Portal and navigate to Azure Analysis Services
3. Select the Azure Analysis Services instance you wish to connect your report to

4. Under the “Models on Analysis Services Server,” select the model that you wish to connect your reports.

5. Click the ellipses and select “Open in Power BI Desktop”.
6. Publish blank report to PowerBI.com.
7. Use the rebindReport.ps1 PowerShell script from the github link below.

• You will need to install PowerShell and the Azure PowerShell cmdlets (Install-Module AzureRM).
• Run PowerShell as an administrator.
• Follow the instructions within the PowerShell script to fill in the Client ID.
• Change PowerShell directory to where this script is saved.
• Open script for rebindReport.ps1.
• Fill in parameters within script.
• Run script.

*You will need the ability to register an Azure app on dev.powerbi.com/apps. If not, you will need assistance from an Azure administrator.