More datasets reported in Personal Workspace than actually exist

[Stefvsignup]

Hi,

I ran a script in my company's tenant to extract all workspaces, for each workspaces all datasets and then count the number of source types e.g. file, sql server to better understand what data our company is looking at.

I'm seeing some strange behavior though for Personal workspaces. I can see for example that I have a lot of dataset_id linked to my personal workspace even though in reality I only have one dataset. Thus I'm trying to understand the behavior of the commands here. I've listed it down below in a more structured format

Background:

• I have one dataset in my personal workspace
• I don't have any datasets shared with me
• I am a member of several app workspaces
• I am also using some Apps

I'm using the following command:
Get-PowerBIDataset -scope Organization -WorkspaceId ... logged in as a PowerBI admin

Expectation: to only see the dataset that I have in my personal workspace
Reality: I am seeing datasets that are in Apps that I use and in App workspace I am a member off

Questions

• Do datasets in app workspaces you are a member off automatically appear when you query your personal workspace?
• Do datasets in apps you use automatically appear when you query your personal workspace?

[KayUnkroth]

Hi Stefvsignup,

Regarding your questions:

Do datasets in app workspaces you are a member off automatically appear when you query your personal workspace?
o This should not happen, and we are unable to reproduce this behavior. If it is indeed happening in your environment, would you be so kind to give me exact repro steps?

Do datasets in apps you use automatically appear when you query your personal workspace?
o When you install an app, it is installed in the personal workspace. We hide the information in UI, but the dataset is linked to the personal workspace, and hence it would show up in the list of datasets. This is by design so that you can enumerate the datasets linked to an app.

Cheers,
Kay

[bgribaudo]

Hello @KayUnkroth,

Do datasets in apps you use automatically appear when you query your personal workspace?
o When you install an app, it is installed in the personal workspace. We hide the information in UI, but the dataset is linked to the personal workspace, and hence it would show up in the list of datasets. This is by design so that you can enumerate the datasets linked to an app.

This is very interesting and helpful! Is there a way to determine which datasets are linked?

Thanks,
Ben

[KayUnkroth]

Yes, a link or AppId property would be very useful, indeed. Would you be so kind to file this as a new issue/feature request?
Cheers,
Kay

[bgribaudo]

Good idea—thanks! Done!
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36390475-add-associated-appid-to-data-set-details