Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Select data from workspace

Hello everyone! Is that possible to select these data from PBI service workspace in table format using PBI?     
Need Help
  • pmreis's avatar
    pmreis
    2 years ago

    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
pmreis's avatar
pmreis
Most Valuable Professional
2 years ago

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 LinkedIn








  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

    • pmreis's avatar
      pmreis
      Most Valuable Professional
      2 years ago

      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