PowerShell Get a List of Reports and Datasets from My workspace

[roncruiser]

Hello!  🙂

How do I get a list of reports and datasets from My Workspace?  I'm able to get the lists from a group workspace using this:
Get-PowerBIWorkspace -Name GroupName
Get-PowerBIDataset - Name GroupName

How do I get it from it from my own workspace?

Thanks!

[v-csrikanth]

Hi @roncruiser 

We are following up once again regarding your query. Did you gat any chanve to raise it in the ideas forum with Microsoft.
As per Microsoft community guidelines, we will now proceed to close this thread to keep discussions focused and manageable. If you still need assistance, you're welcome to start a new thread in the community at any time.
We appreciate your understanding and participation.

Thank you for your understanding and participation.

Best Regards,
Cheri Srikanth 

[roncruiser]

@v-pbandela-msft 

This is has not been resolved.  I still have not found a solution.

[v-pbandela-msft]

Hi @roncruiser,

Thank you for the update and apologies for the inconvenience caused.

We request you to contact our support team through the link below for immediate assistance by raising a ticket. They will be able to provide specific insights related to your account and potential resolutions.

To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Regards,
Pavan.

[v-pbandela-msft]

Hi @roncruiser,

Thank you for reaching out in Microsoft Community Forum.

Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Regards,
Pavan.

[Deku]

https://learn.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.data/get-powerbidataset?vie...

https://learn.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.workspaces/get-powerbiworks...

Don't provide a scope 

-Scope

Indicates scope of the call. Individual returns datasets from "My Workspace" by default. With -Workspace or -WorkspaceId, datasets under the workspace assigned to the caller are returned; Organization returns all datasets within a tenant (must be an administrator to initiate). Individual is the default.

[roncruiser]

Sorry.  I am totally new to using PowerShell for PowerBI.  I'm trying to ramp up and learn as fast as possible.
Syntax is still confusing to me.

Do you mean leaving -Scope empty like below:
Get-PowerBIWorkspace -Scope

[v-pbandela-msft]

Hi @roncruiser,

Thank you for reaching out in Microsoft Community Forum.

Thank you @Deku  for the helpful response.

please don’t need to include the -Scope parameter at all. By default, PowerShell automatically uses My Workspace scope when you omit -Workspace or -WorkspaceId.

1. Please Simply run the following commands without -Scope to list reports and datasets from My Workspace.
# List reports
Get-PowerBIReport

# List datasets
Get-PowerBIDataset

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[roncruiser]

Something else is going on when simply run Get-PowerBIReport.
I have 4 reports/datasets in My Workspace.  After running, it show about 50 different reports.  Most of the reports of which I do not recgonize.

Is there a way to force it to look at My Workspace?  It's gathering reports from outside My Workspace, too.  I don't know why.

[v-pbandela-msft]

Hi @roncruiser,

Thank you for your update!

The reason you’re seeing reports outside "My Workspace" is that the Power BI cmdlets might be returning results from all accessible workspaces due to tenant-wide visibility or admin privileges.

Please follow below steps to resolve the error;

1.Force PowerShell to target "My Workspace":
$workspace = Get-PowerBIWorkspace -Scope Individual
Get-PowerBIReport -WorkspaceId $workspace.Id
Get-PowerBIDataset -WorkspaceId $workspace.Id

2.Verify the results to make sure only "My Workspace" reports and datasets are listed.

3.Check for admin privileges if you still see external reports
Get-PowerBIWorkspace -Scope Organization

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[roncruiser]

Hi...
I ran the commands from Power Shell and encountered these issues circled in yellow:

[v-pbandela-msft]

Hi @roncruiser,

Thank you for reaching out in Microsoft Community Forum.

No Error with $workspace.id: The yellow-circled $workspace.id is expected behavior, simply displaying the ID of My Workspace.

1. Run the following commands to confirm you are targeting My Workspace only
$workspace = Get-PowerBIWorkspace -Scope Individual | Where-Object { $_.Name -eq "My Workspace" }
$workspace.Id
Get-PowerBIReport -WorkspaceId $workspace.Id
Get-PowerBIDataset -WorkspaceId $workspace.Id

2.To verify the ID corresponds to My Workspace, Please run:
Get-PowerBIWorkspace -Scope Individual | Format-Table Id, Name

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[roncruiser]

@v-pbandela-msft 
Here is what I received after running the commands:

It's as if it seems My Workspace is inclusive of all other group workspaces.

[v-pbandela-msft · Accepted solution]

Hi @roncruiser,

Thank you for reaching out in Microsoft Community Forum.

Please go through the above mentioned steps and check step by step again ,if still faces the same issue then please consider raising a support ticket for further assistance.

To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

[roncruiser]

Thanks for the reply.  I'll try it out and report back.