powerbi get datasets api is missing some datasets

[ledd_25]

I have used the Get-PowerBIDataset and GetDatasetsAsAdmin in getting the datasets and PowerBIActivityEvent  to get the log events. I noticed that there are some datasets that appear in the log event but not in the get powerbi dataset. This is what i used: Get-PowerBIDataset -Scope Organization. I checked which workspace this "odd" dataset came from since the log events contained the workspace id and i obtained the workspaces by using  Get-PowerBIWorkspace -Scope Orgranization -all and i found that the workspace is there. So the dataset is not in the get powerbi dataset but its workspace is present in the get powerbi workspace.   

Why are there some datasets that i cant find? 

I have tried to loop through every workpsace and getting the dataset from there but i do not have access to every workspace. I believe this may be the culprit.

[Nasif_Azam]

Hey @ledd_25 ,
The discrepancy you are seeing is likely due to workspace access limitations. 

Try Recommended Actions:

1. Use Get-PowerBIDataset -Scope Organization or GetDatasetsAsAdmin only if you’re a Power BI Admin they return the broadest dataset list you're authorized to see.

2. For datasets that still don’t appear, check:

   • If they’re in classic workspaces (not supported).

   • If sensitivity labels or policies limit visibility.

   • If the dataset was deleted or unpublished after the log entry was captured.

3. If you truly need a complete inventory of all datasets, you’ll need:

   • Power BI Admin role.

   • To use Service Principal with tenant-wide permissions, and ensure it's approved for the required workspaces.

   • Alternatively, use Graph API or Admin APIs from a privileged account.

For Detailed Information:

Get-PowerBIDataset (Microsoft Docs)

GetDatasetsAsAdmin (REST API) – Microsoft Docs

PowerBIActivityEvent Reference – Microsoft Docs

Workspace types in Power BI – Classic vs. New

Admin APIs and Permissions in Power BI

Service Principal Authentication for Admin APIs

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam

[ribisht17]

Hi @ledd_25 

Have you checked the below post:

Solved: Re: Can't access entire organizational datasets us... - Microsoft Fabric Community

Regards,

Ritesh

Community Champion

Please mark the answer if helpful so that it can help others

Dance-Sing with Data Projects - YouTube