Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AMD0791
Advocate II
Advocate II

Upgrading compatibility level for model in service

I am using ALM Toolkit to compare the model in my local desktop file with the model published in the service.   ALM Toolkit returns an error that the source (PBI Desktop) is compatibility level 1567 and the target (PBI Service) is level 1550, and that discrepancy is not supported for comparison.  It then offers to update the model in the service from 1550 to 1567.

 

The different levels makes sense -- this particular model hasn't been updated and republished in a couple years and was certainly last updated with a much older desktop configuration.

 

Is there anything I need to review before allowing ALMToolkit to update the model in the service?  What is the risk associated with changing to a higher compatibility level?  Is ALMToolkit the proper tool to use, or would it be better to use Tabular Editor or SSMS?

 

Thank you!!

2 ACCEPTED SOLUTIONS
TomMartens
Super User
Super User

Hey @AMD0791 ,

 

I have to admit that I'm not that familiar with the ALM Toolkit. Before you update the model in the service, I would save the current definition as a file, the "bim" file, using the Tabular Editor.

 

While using the ALM toolkt I realized that it does not break anything. Of course this is not a guarantee 😉

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

v-yaningy-msft
Community Support
Community Support

Hi, @AMD0791 

Thanks for @TomMartens  reply. Updates to the AML Toolkit are not reversible for models. After an update, models may use features or syntax that are not supported in the older version, and the model file structure may change to accommodate these new features. Before updating, you need to back up your data or test the updated model in a sandbox environment to make sure everything works as expected. The choice of whether to use ALM Toolkit , Tabular Editor or SSMS depends on your needs. Here are the main differences between these third party software.

 

1. ALM Toolkit is an open source architecture comparison tool designed specifically for Power BI semantic models. It is typically used for Application Lifecycle Management (ALM) scenarios.

Key features: ALM Toolkit allows comparison of database architectures to more easily identify differences between versions of a Power BI dataset; code changes can be merged across environments to ensure consistency and smooth deployment; simplifies deployment of models; it integrates seamlessly with source code management systems; definitions can be reused across models; ALM Toolkit bridges the gap between self-service and enterprise-class BI development. The ALM Toolkit bridges the gap between self-service and enterprise-level BI development.

 

2.Tabular Editor is an open-source tool that allows you to create, maintain, and manage tabular models using an intuitive, lightweight editor.

Key features: Tabular Editor provides a hierarchical view of all objects in the tabular model; you can use display folders to organise objects; edit the properties of multiple objects at the same time; support for DAX syntax highlighting and more.

Related link: Development tools for Tabular models in 2021 - SQLBI

 

3. SSMS is a Microsoft tool primarily used for managing SQL Server databases, including Analysis Services. Although SSMS is not specifically designed for the tabular model, it provides a broader set of features for managing databases, including the tabular model.

Key features: The ability to write and execute queries against the tabular model; allowing the model to be deployed to different environments; performing a variety of administrative tasks, such as handling partitioning, managing security, and monitoring performance; and lacking some of the specialised functionality available in the ALM Toolkit and the table editor.


Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

View solution in original post

2 REPLIES 2
v-yaningy-msft
Community Support
Community Support

Hi, @AMD0791 

Thanks for @TomMartens  reply. Updates to the AML Toolkit are not reversible for models. After an update, models may use features or syntax that are not supported in the older version, and the model file structure may change to accommodate these new features. Before updating, you need to back up your data or test the updated model in a sandbox environment to make sure everything works as expected. The choice of whether to use ALM Toolkit , Tabular Editor or SSMS depends on your needs. Here are the main differences between these third party software.

 

1. ALM Toolkit is an open source architecture comparison tool designed specifically for Power BI semantic models. It is typically used for Application Lifecycle Management (ALM) scenarios.

Key features: ALM Toolkit allows comparison of database architectures to more easily identify differences between versions of a Power BI dataset; code changes can be merged across environments to ensure consistency and smooth deployment; simplifies deployment of models; it integrates seamlessly with source code management systems; definitions can be reused across models; ALM Toolkit bridges the gap between self-service and enterprise-class BI development. The ALM Toolkit bridges the gap between self-service and enterprise-level BI development.

 

2.Tabular Editor is an open-source tool that allows you to create, maintain, and manage tabular models using an intuitive, lightweight editor.

Key features: Tabular Editor provides a hierarchical view of all objects in the tabular model; you can use display folders to organise objects; edit the properties of multiple objects at the same time; support for DAX syntax highlighting and more.

Related link: Development tools for Tabular models in 2021 - SQLBI

 

3. SSMS is a Microsoft tool primarily used for managing SQL Server databases, including Analysis Services. Although SSMS is not specifically designed for the tabular model, it provides a broader set of features for managing databases, including the tabular model.

Key features: The ability to write and execute queries against the tabular model; allowing the model to be deployed to different environments; performing a variety of administrative tasks, such as handling partitioning, managing security, and monitoring performance; and lacking some of the specialised functionality available in the ALM Toolkit and the table editor.


Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

TomMartens
Super User
Super User

Hey @AMD0791 ,

 

I have to admit that I'm not that familiar with the ALM Toolkit. Before you update the model in the service, I would save the current definition as a file, the "bim" file, using the Tabular Editor.

 

While using the ALM toolkt I realized that it does not break anything. Of course this is not a guarantee 😉

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors