Forum Discussion

DenisChe's avatar
DenisChe
Frequent Visitor
3 years ago

How to make the changes in Large Model

Hello,

I have a Dataset now configured as a Large Model.

The question is:

How to make the changes in this dataset - concerning new or existing measures, Power Query, relations, etc.

Is it possible to have full-value access to this dataset via Power BI Desktop?

Will appreciate any kind of help - like documents, tutorials, or direct explanations.

 

Tutorial Requests

1 Reply

  • Bipin-Lala's avatar
    Bipin-Lala
    Solution Sage
    4 months ago

    Hi DenisChe,

     

    Once a model is converted to the Large Semantic Model Storage Format and grows beyond the standard PBIX limit (usually around 10 GB), the "Download .pbix" option is disabled in the Power BI Service.

     

    Power BI Reporting changes

    • Use Power BI Desktop to connect to the model via a Live Connection for building reports.

    To make changes (Measures, Relations, Metadata)

    • The industry standard for managing Large Models is using the XMLA Endpoint. This allows you to "reach into" the Power BI Service and edit the model's metadata without moving the data.
    • Use Tabular Editor to make the require changes
    • Or you can directly make changes in Power BI Service

    Also, I would recommend that if you are planning to convert a model to the Large format, keep a master backup copy of your .pbix file on a secure drive or in a Git repository before you flip the toggle.

     

    That's how we currently maintain the pbix in our organisation.

     

    Let me know if you have any questions!