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.

  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

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

  1. Click the ellipses and select “Open in Power BI Desktop”.
  2. Publish blank report to PowerBI.com.
  3. 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.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment