Forum Discussion
Select data from workspace
Hello everyone!
Is that possible to select these data from PBI service workspace in table format using PBI?
Hi Anonymous
If you are admin, you can check all the tenant informations as described here:
View workspaces - Power BI | Microsoft Learn
You can also configure and use / share Logs as described here:Audit and usage admin settings - Microsoft Fabric | Microsoft Learn
If you are not, the administrator can give you rights for instance on a dataflow from the logs, on which you can connect as a table in Power BI.
Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple
If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!
Find me at LinkedIn
3 Replies
Hi Anonymous
You can do this by using Power BI Cmdlets. Open PowerShell with admin rights and run:
Install-Module -Name MicrosoftPowerBIMgmt -Force -AllowClobber
Authenticate:
Connect-PowerBIServiceAccount
Get a list of workspaces:
Get-PowerBIWorkspace -Scope Organization
Then you can get a list of Reports, Datasets and Dashboard running respectively:
Get-PowerBIReport -WorkspaceId <WorkspaceId> -Scope Organization
Get-PowerBIDataset -WorkspaceId <WorkspaceId> -Scope Organization
Get-PowerBIDashboard -WorkspaceId <WorkspaceId> -Scope Organization
(replace the Workspace ID by your own)For more information, check the documentation here: Power BI Cmdlets reference | Microsoft Learn
Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple
If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!
Find me at LinkedInHi Anonymous
If you are admin, you can check all the tenant informations as described here:
View workspaces - Power BI | Microsoft Learn
You can also configure and use / share Logs as described here:Audit and usage admin settings - Microsoft Fabric | Microsoft Learn
If you are not, the administrator can give you rights for instance on a dataflow from the logs, on which you can connect as a table in Power BI.
Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple
If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!
Find me at LinkedIn