How to check size of pbip project dataset size in power bi desktop?

[jaryszek]

Hello,

I have read that dataset size for power bi desktop has a limit of 1 GB. 
But already imported few tables with size of 600 mb and saved as bpip project and published without any issues. 

How to check dataset size of bpip project?

Best,
Jacek

[v-pnaroju-msft]

Hi jaryszek,

In the Power BI Service, you can view the size of each dataset or semantic model directly from the workspace settings by following these steps:

1. Navigate to the workspace where the dataset is published.
2. Click the gear icon in the top right corner.
3. Select Manage group storage.
4. A list of all datasets in that workspace, together with their sizes, will be displayed.

This is the most reliable method to verify the actual size of the dataset in the Service. It enables us to monitor whether we are approaching the 1 GB limit for Pro licences or the higher limits applicable to Premium/PPU capacities.

We hope that the information provided will help resolve your issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Thankyou, @Greg_Deckler, for your response.

Hi jaryszek,

We appreciate your inquiry made through the Microsoft Fabric Community Forum.

Based on my understanding, the .PBIP project format stores the dataset or semantic model as decomposed JSON files and does not contain the actual in-memory compressed data model as is present in a .pbix file. Consequently, the dataset size cannot be directly observed within the .pbip folder.

Kindly follow the steps below to determine the dataset size of a .PBIP project in Power BI Desktop:

1. As suggested by @Greg_Deckler, please open the .pbip project in Power BI Desktop, then navigate to File, select Save As, and choose the PBIX format. Locate the saved .pbix file and check its file size. This size represents the compiled semantic model, which is subject to the 1 GB limit in Power BI Desktop.

2. Please note that the .PBIP project does not store the runtime cache inside the project folders. The actual cache is generated at runtime in the temporary Analysis Services workspaces folder used by Power BI Desktop. While this cache reflects memory usage, it is temporary and not reliable for tracking dataset size.

Additionally, you may refer to the following links for further information:
Power BI Desktop projects (PBIP) - Power BI | Microsoft Learn
Power BI Desktop project semantic model folder - Power BI | Microsoft Learn

We hope that the information provided will assist you in resolving the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

[jaryszek]

thank you. How to check dataset model size in power bi service? 

[Greg_Deckler]

@jaryszek The quick method would be to save it as a PBIX and look at the size of the PBIX file.

[jaryszek]

Greq,

what about cache file inside bpip project? It is connected to size of semantic model? 

Best,
Jacek