Forum Discussion

amsrivas's avatar
amsrivas
Icon for Helper IV rankHelper IV
5 years ago

Relation between WorkSpace, DataFlow , Dataset and Report of Power BI

Hi Folks!! I want to create a report that will display relation ship between  WorkSpace, DataFlow , Dataset and Report of Power BI. In order to acheive this, I need to create Dataset which having a...
Need Help
avatorl's avatar
avatorl
Icon for Impactful Individual rankImpactful Individual
5 years ago
$Workspaces = Get-PowerBIWorkspace
foreach ($workspace in $Workspaces) {
Write-Host $workspace.id Write-Host $workspace.name
}

 

amsrivas's avatar
amsrivas
Icon for Helper IV rankHelper IV
5 years ago

Hi avatorl  Thanks for all your inputs !!!

Any help here would be really appreciable.

1. Relation ship between Workspace and Dataflow 

Script Used : 
$Workspaces = Get-PowerBIWorkspace
$res = @( foreach ($workspace in $Workspaces) {Get-PowerBIDataFlow -Workspace $workspace }) | Export-Csv -NoTypeInformation -Path C:\Azure\Dataflow.csv

 

Result : Its giving me detail of Dataflow only such Dataflow Id, Dataflow Name etc.

-  Will it be possible to include the workspace ID which i have passed above in script in the Output.

 

2. WorkSpace - Dataset 

Script Used : Get-PowerBIDataset

Output - No relationship between Workspace ,dataflow and reports are there.

 

3. WorkSpace - Report 

 Script Used : Get-PowerBIReport

This gives relation ship with Dataset, any way to have relation between workspace, dataflow as well.

 

4. Any scipt that says relation ship between Report to Workspace, Dataflows , dataset , users etc will be great help!!

 

THanks

Amit