Forum Discussion

TheCreepster1's avatar
TheCreepster1
Helper II
4 years ago

Analyze in Excel

Hello, I have a colleague who is having an issue refreshing data in excel that has been built using the 'Analyze in Excel' option from Power BI. Unfortunately, it's not a dataset I recognise but I'd ...
Need Help
TheCreepster1's avatar
TheCreepster1
Helper II
4 years ago

Hi, thanks for your reply. I have access to the tenant admin, but it's not something I've used very frequently. Where would I find an inventory of the tenant datasets and how would it help me identify the source in excel?

lbendlin's avatar
lbendlin
Super User
4 years ago

Ask your tenant admin to run the inventory API calls.

 

 

 $workspaceBatch = Invoke-PowerBIRestMethod -Method Get  -Url "https://api.powerbi.com/v1.0/myorg/admin/groups?`$skip=$skip&`$top=$batchSize&`$expand=datasets" | ConvertFrom-Json        

               $datasets 	+= $workspaceBatch.value | Where-Object {$_.datasets.Count -gt 0} | Select-Object @{Name = "workspaceId"; Expression={ $_.Id} }, @{Name = "datasets"; Expression={ $_.datasets | Select-Object * -ExcludeProperty WorkspaceId } } | Select-Object * -ExpandProperty datasets -ExcludeProperty datasets

 

 

That will allow you to look up which workspace the dataset is in, and who the owner is.