Publishing reports in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to publish a Power BI report to the workspace.

Power BI

Publish-PowerBIReport -Path "C:\Reports\Sales.pbix" -WorkspaceId [1]

Drag options to blanks, or click blank then click option'

AImport-PowerBIReport

BGet-Workspace

CConnect-PowerBIServiceAccount

D12345-abcde-67890-fghij

Attempts:

3 left

💡 Hint

Common Mistakes

Using a cmdlet name instead of the workspace ID.

Confusing the workspace ID with the report path.

The WorkspaceId parameter requires the ID of the workspace where the report will be published.

2fill in blank

medium

Complete the code to connect to the Power BI service before publishing.

Power BI

Connect-PowerBIServiceAccount -Credential [1]

Drag options to blanks, or click blank then click option'

A$UserCredential

BGet-Workspace

CPublish-PowerBIReport

DDisconnect-PowerBIServiceAccount

Attempts:

3 left

💡 Hint

Common Mistakes

Using a cmdlet name instead of a credential variable.

Omitting the credential parameter.

The -Credential parameter expects a credential object, usually stored in a variable like $UserCredential.

3fill in blank

hard

Fix the error in the command to publish a report by filling the missing parameter.

Power BI

Publish-PowerBIReport -Path "C:\Reports\Finance.pbix" [1] "workspace-001"

Drag options to blanks, or click blank then click option'

A-WorkspaceName

B-WorkspaceId

C-ReportName

D-DatasetId

Attempts:

3 left

💡 Hint

Common Mistakes

Using -WorkspaceId with a name instead of an ID.

Using -DatasetId which is unrelated here.

The correct parameter to specify the workspace by name is -WorkspaceName.

4fill in blank

hard

Fill both blanks to assign the report ID and then export the report to a file.

Power BI

$reportId = (Get-PowerBIReport -Name "Sales Report" -WorkspaceId [1]).Id
Export-PowerBIReport -Id $reportId [2] "C:\Exports\SalesExport.pbix"

Drag options to blanks, or click blank then click option'

A12345-abcde-67890-fghij

B-OutFile

C-WorkspaceId

D-FilePath

Attempts:

3 left

💡 Hint

Common Mistakes

Using -WorkspaceId in the export command instead of -OutFile.

Confusing parameter names.

The workspace ID is needed to get the report, and the export command requires the -OutFile parameter to specify the file location.

5fill in blank

hard

Fill all three blanks to update a dataset and refresh it after publishing.

Power BI

Update-PowerBIDataset -Id [1] -WorkspaceId [2]
Invoke-PowerBIRefresh -DatasetId [3] -WorkspaceId [2]

Drag options to blanks, or click blank then click option'

Adataset-789

Bworkspace-456

Dworkspace-123

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing dataset and workspace IDs.

Using different workspace IDs in the two commands.

The dataset ID is used for updating and refreshing, and the workspace ID must be consistent for both commands.