Forum Discussion
Bamak
5 years agoHelper V
Power Shell & get Datasets size
Hi
- I would like to retrieve the size of the datasets present on PBI Service (all workspaces), in order to identify the largest
- I test the following power shell script above
- Unfortunately, I do not detect information concerning the size of datasets
Thanks a lot for any help and regards
#1. Authenticate to Power BI with Power BI Service Administrator Account
$User = "XXXXXXX"
$PW = "XXXXXXXX"
$SecPasswd = ConvertTo-SecureString $PW -AsPlainText -Force
$myCred = New-Object System.Management.Automation.PSCredential($User,$SecPasswd)
$DSPath = "C:\DS.csv"
Connect-PowerBIServiceAccount -Credential $myCred
Get-PowerBIDataset -Scope Organization | Export-Csv $DSPath -NoTypeInformation
2 Replies
- GilbertQSuper User
hi there
have you tried the examples on the Power BI Rest APIs to make sure it works for your account?
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasetingroup#code-try-0
- BamakHelper V
Hi Gilbert
Thanks a lot but
- Unfortunately, I do not detect information concerning the size of datasets