[PowerShell] Publish-FinOpsHubReport

[flanakin]

📝 Scenario

As a hub admin, I need to publish a Power BI report in order to make it available to all stakeholders

💎 Solution

Create a Publish-FinOpsHubReport command that downloads FinOps hub reports, publishes them to the Power BI service, and optionally connects them to a hub instance.

⛔ Blocked

• See [PowerShell] Download-FinOpsHubReport #250

Synopsis

Publishes a report to the Power BI service and optionally connects it to a FinOps hub instance.

Syntax

Publish-FinOpsHubReport `
    [-Name] <string> `
    [-HubName <string>] `
    [-ResourceGroupName <string>] `
    [-Version <string>] `
    [-Preview] 

Description

The Publish-FinOpsHubReport command publishes a report to the Power BI service. If the -Name is a file path to a PBIX file, that custom report will be published. If the -Name references a FinOps hub report name, the report will be downloaded and published. If a hub instance is specified either via -HubName or -ResourceGroupName, the report will be connected to that hub instance. If a hub instance is not specified, the report will contain sample data.

Parameters

Parameter	Description
-Name	Required. Name of the Power BI report or a path to a custom PBIX file to publish.
-HubName	Optional. Name of the hub instance to connect to. Default = none.
-ResourceGroupName	Optional. Name of the resource group the FinOps hub is deployed to.
-Version	Optional. Version to download. Default = Hub instance version or "latest", if not specified.
-Preview	Optional. Indicates whether to include preview releases when -Version is "latest". Ignored when a specific version is specified. Default = false.

ℹ️ Additional info

Use the Download-FinOpsHubReport to get the download the report. Use the version of the hub instance when downloading a specific version. If not specified, use the latest version.

We should be able to use New-PowerBIReport to publish the report.

We might be able to update the query parameters via the Set-PowerBIDataset command. We need to confirm.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Are there any parameters that are missing?
3. Leave comments to help us solidify the vision.