topic Re: Deploy dataset to multiple workspaces with script in Developer

Deploy dataset to multiple workspaces with script

Anonymous — Tue, 29 Aug 2023 15:59:19 GMT

Hi,

I have a master dataset that I would like to copy, deploy to multiple workspaces and change a dataset paramenter all with a script. From what I can tell, I should be able to do this with the XMLA endpoint, Is this something I can do with Tabluar editors advanced scripting?

I haven't found any good examples of this or alternative ways to do it. Any advice would be greatly appreciated 🙂

Re: Deploy dataset to multiple workspaces with script

Anonymous — Thu, 31 Aug 2023 07:04:50 GMT

Hi @Anonymous ,

You can use PowerShell scripts to deploy a Power BI dataset to multiple workspaces. Here is an example script that imports a dataset to multiple workspaces:

PowerShell script that automatically uploads PowerBI report to list of Workspaces - Stack Overflow

Import-Module MicrosoftPowerBIMgmt $oldReportName = "Fancy Report" $pbixFilePath = "C:\Power BI\Fancy Report.pbix" $username = "user@example.com" $password = "P@ssw0rd" | ConvertTo-SecureString -asPlainText -Force $credential = New-Object System.Management.Automation.PSCredential($username, $password) Connect-PowerBIServiceAccount -Credential $credential | Out-Null # -All - Returns all results, not only top 100 $workspaces = Get-PowerBIWorkspace -All -Scope Organization -Include All foreach($workspace in $workspaces) { $report = Get-PowerBIReport -WorkspaceId $workspace.Id -Scope Organization -Name $oldReportName if ($report) { Write-Host "Report $oldReportName found in workspace $($workspace.Name)..." New-PowerBIReport -Path $pbixFilePath -Workspace $workspace -ConflictAction CreateOrOverwrite } } Disconnect-PowerBIServiceAccoun

PowerShell script to publish Power BI reports into multiple tenants - Power of Business Intelligence (powerofbi.org)

Re: Deploy dataset to multiple workspaces with script

Anonymous — Thu, 31 Aug 2023 18:42:15 GMT

Hi @Anonymous thank you for your response, when I try to push via the Rest api I get an error becasue my dataset it too big. This is way I wanted to use the XMLA endpoint.

Is there a way to use the Rest API for a large dataset?

Re: Deploy dataset to multiple workspaces with script

Anonymous — Tue, 05 Sep 2023 06:54:19 GMT

Hi @Anonymous ,

You can follow the steps below to get it:

Make sure that the XMLA endpoint is enabled for read/write operations in the Power BI Admin portal.
Use a tool like SQL Server Management Studio (SSMS), the open-source Tabular Editor, or script with Tabular Model Scripting Language (TMSL) to connect to the XMLA endpoint of the workspace that contains the dataset you want to deploy.
Use the tool to create a backup of the dataset.
Connect to the XMLA endpoint of each workspace you want to deploy the dataset to.
Use the tool to restore the backup of the dataset to each workspace.

In addition, you can refer the following links to get it.

Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Learn

Backup and restore Power BI Premium datasets - Power BI | Microsoft Learn

Power BI — backup and restore datasets | by Michal Molka | Medium

Best Regards