Forum Discussion

Zarina_Hajiyeva's avatar
Zarina_Hajiyeva
Frequent Visitor
1 year ago
Solved

When a pbix file is published, its size increases.

One Semantic model in one of my company's Pro workspaces hit the 1GB limit. After deleting all transactions from the year 2022 in 3 tables, PBIX size dropped to 816MB. But when we published and repla...
  • Anonymous's avatar
    Anonymous
    1 year ago
    Hi Zarina_Hajiyeva ,
    Thanks for reaching out to the Microsoft fabric community forum.

    To fix your PBIX file size issue, try deleting the current 1962 MB semantic model from the Power BI Service instead of overwriting it.

    Before republishing, open your PBIX file in Power BI Desktop and clear any cached data by going to File - Options and Settings - Options - Data Load and selecting Clear Cache. Saving the PBIX file with a new name also helps prevent metadata issues.

    Publish the PBIX as a new dataset from Power BI Desktop there should be no prompt to replace an existing one. After publishing, check the dataset size in System storage to confirm it matches your model’s actual size. This method ensures accurate file size and eliminates unnecessary metadata from previous versions.

    If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

    Best Regards,
    Sreeteja.
    Community Support Team