Select data from workspace

[serog22]

Hello everyone!

Is that possible to select these data from PBI service workspace in table format using PBI? 

[pmreis]

Hi @serog22 

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 LinkedIn

[serog22]

Thanks, but I want to select this data like a table. In Power query 

[pmreis · Accepted solution]

Hi @serog22 

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