You need to add it manually, by running the following script in the Advanced Editor window of the Tabular Editor: w = new () Using BPA in Tabular Editorīest Practice Analyzer is not something you get out-of-the-box when you install Tabular Editor. But, the implications may be significant if you haven’t partitioned large tables, if your model contains many bi-directional or M:M relationships, or if you have many calculated columns and calculated tables in the model. That being said, from the model performance perspective, it doesn’t matter if you capitalized the first letter of data model objects, or hide foreign keys. Obviously, not all rules have the same importance for the model performance. This means you can live with these “issues” without sacrificing the model performance.īPA relies on rules – each rule belongs to a certain category, such as DAX expressions, Performance, Formatting, and so on. Some “issues” are just that – “issues” with double-quotes. In a nutshell, the Best Practice Analyzer (BPA) scans your tabular data model and warns you about all the “issues” within the model. You can find more details about the tool itself in this article. When dealing with problematic data models, Best Practice Analyzer will quickly become your best friend! This tool, or maybe it’s better to say extension, was developed by Michael Kovalsky from Microsoft. You have to use a Tabular Editor extension, called Best Practice Analyzer. Of course not! Knowing general best practices for the data model optimization, such as avoiding bi-directional relationships, reducing the column cardinality, avoiding DirectQuery whenever possible, or removing Auto Date/Time hidden tables, still remains the key requirement! But, Tabular Editor may help you quickly and easily identify potential violations of these practices – based on the insight gained, you can then decide if you want to apply the recommended practice(s) or keep your original data modeling logic in place.īefore I show you how to use Tabular Editor for this specific goal, I must admit that I wasn’t completely honest with you□… Tabular Editor alone WILL NOT save your data model from disaster. Of course, you can apply all the same steps in Tabular Editor 3, which is a commercial version of the productīut, now you’re probably asking yourselves: optimizing the data model is such a broad topic, how can one single tool help me to apply all those recommendations that spread across multiple books, videos, whitepapers, and blog posts? Is Tabular Editor a kind of magic wand that can help you transform data model “monsters” into “beauties” with a few clicks?! However, as the DP-500 exam focuses on optimizing the data model with Tabular Editor topic, let’s explain how the tool may help you in achieving this specific goal.ĭISCLAIMER: Since the DP-500 exam explicitly specifies Tabular Editor 2 (free version) for this topic, we’ll use this version in the remaining part of the article. Tabular Editor is a comprehensive tool, that may be helpful in various development scenarios. Now it’s time to switch our focus to another extremely popular external tool – Tabular Editor! I’ve already written about Tabular Editor and some of its features that can significantly boost your Power BI development. In the previous article, we’ve explained how to leverage DAX Studio free external tool to troubleshoot poorly performing DAX queries. This article is the part of the series related to mastering DP-500 certification exam: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI Book DP-500 Training Table of contents
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |