Managers, analysts, engineers, and information workers who use it know that SQL Server Analysis Services Tabular (SSAS Tabular) is a valuable ICT asset. On the other hand, Power BI (PBI) is a great tool too that has a bit more functionality under its belt. Yet, there are cases where SSAS Tabular might prove useful which we’ll detail in this blog.
Let’s look at the essence of both technologies. Simply put, with a single Power BI file you can:
SSAS Tabular, on the other hand, only takes care of the above-mentioned points b and c. Now, don’t judge hastily and decide that Power BI is the only way to go for you. We will tell you why SSAS Tabular will interest you in a minute, but first we want to briefly address the points that are not covered by SSAS Tabular.
So far, SSAS may seem like an extra, somewhat unnecessary subsystem in your business intelligence process, but here are a few cases where it will help you overcome obstacles and things it does better than Power BI. The below benefits makes it worth looking into it for using it in your data efforts.
The number of records loaded into Power BI files can grow quickly as your business goes on. However, some day, you will encounter a limit for the amount of data that can be compressed in the memory of your PBI files. Currently this limit is 1GB for a Standard Power BI version. The latest Power BI Premium version has no limit anymore, but that means you’re moving to another cost level. In SSAS Tabular, you are only limited by the size of the on-premises server’s RAM or by the amount of available Azure resources in case of cloud deployment.
SSAS Tabular gives you the possibility to define very precise and granular security rules on the consumable data. With row-level security rules, data rows can be shielded from target audiences like external users or employees from other departments depending on your business requirements.
Developing Power BI files is easy and is a fun thing to do. If you work in a large organization, it will not take long before your infrastructure will host a ton of Power BI files. Within these files are models that differ from each other ever so slightly, because they were developed on a different day or by another person. Table and column names may be different across PBI files, for instance. In this plausible scenario, there is a bigger chance that calculations and KPIs will be named differently and even that their definitions are scripted in another way. We’re only human after all. These slightly differing models confuse your users when they look for the right file and data to use.
With SSAS Tabular, however, you can deploy a single model which can easily be queried from many Power BI files for analysis and reporting. The underlying base model will always be consistent. In a SSAS Tabular model, definitions of calculations, KPIs, and calculated columns as well, will be defined consistently for all end applications using them.
It may be time-consuming to change user access in case you have tens or hundreds of Power BI files located in on-premises file shares and in Power BI Service work folders. In the case of an SSAS Tabular model, you treat this information source as a database making it easier to regulate access. Just add or remove a user from a role that can access the Tabular model. Active Directory, or Azure AD, takes care of the rest.
Power BI and Excel are just great tools to use with a SSAS Tabular model. They match perfectly.
But if you want to use other reporting tools, such as Reporting Services reports, Tableau, Pyramid, Spotfire, and the like, then you’re set with a SSAS Tabular Model.
A PBI model can expand over time to become really large. Some of its users may only need a portion of it, however, and are confronted with a model that is oversized and difficult for them to use. A SSAS Tabular model provides the possibility to define viewable parts of the model called “perspectives”. With these perspectives you can hide irrelevant portions of the model for certain target groups. This approach makes your users feel more “at home” in your model.
You may have important user groups operating in different languages, such as Dutch, English, and French. SSAS Tabular can apply different languages for the names of the model, its tables, its columns, and calculations, which can potentially be dynamically shown in reports based on the clients’ locale.
The seven arguments above may help you to decide whether SSAS Tabular has a place in your business intelligence pipeline, either on premises or in Azure. Using it in conjunction with Power BI can probably give you the best of both worlds. In any case, it’s a good idea to keep your eye on the tool. Both Analysis Services and Power BI (Premium) are constantly enhanced with new features. A fortune-teller may reveal that both will become one in the distant future.
Want to learn more? Take a look at our other blog articles!
© 2023 Kohera
Crafted by
© 2022 Kohera
Crafted by
Cookie | Duration | Description |
---|---|---|
ARRAffinity | session | ARRAffinity cookie is set by Azure app service, and allows the service to choose the right instance established by a user to deliver subsequent requests made by that user. |
ARRAffinitySameSite | session | This cookie is set by Windows Azure cloud, and is used for load balancing to make sure the visitor page requests are routed to the same server in any browsing session. |
cookielawinfo-checkbox-advertisement | 1 year | Set by the GDPR Cookie Consent plugin, this cookie records the user consent for the cookies in the "Advertisement" category. |
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
CookieLawInfoConsent | 1 year | CookieYes sets this cookie to record the default button state of the corresponding category and the status of CCPA. It works only in coordination with the primary cookie. |
elementor | never | The website's WordPress theme uses this cookie. It allows the website owner to implement or change the website's content in real-time. |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |
Cookie | Duration | Description |
---|---|---|
__cf_bm | 30 minutes | Cloudflare set the cookie to support Cloudflare Bot Management. |
pll_language | 1 year | Polylang sets this cookie to remember the language the user selects when returning to the website and get the language information when unavailable in another way. |
Cookie | Duration | Description |
---|---|---|
_ga | 1 year 1 month 4 days | Google Analytics sets this cookie to calculate visitor, session and campaign data and track site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognise unique visitors. |
_ga_* | 1 year 1 month 4 days | Google Analytics sets this cookie to store and count page views. |
_gat_gtag_UA_* | 1 minute | Google Analytics sets this cookie to store a unique user ID. |
_gid | 1 day | Google Analytics sets this cookie to store information on how visitors use a website while also creating an analytics report of the website's performance. Some of the collected data includes the number of visitors, their source, and the pages they visit anonymously. |
ai_session | 30 minutes | This is a unique anonymous session identifier cookie set by Microsoft Application Insights software to gather statistical usage and telemetry data for apps built on the Azure cloud platform. |
CONSENT | 2 years | YouTube sets this cookie via embedded YouTube videos and registers anonymous statistical data. |
vuid | 1 year 1 month 4 days | Vimeo installs this cookie to collect tracking information by setting a unique ID to embed videos on the website. |
Cookie | Duration | Description |
---|---|---|
ai_user | 1 year | Microsoft Azure sets this cookie as a unique user identifier cookie, enabling counting of the number of users accessing the application over time. |
VISITOR_INFO1_LIVE | 5 months 27 days | YouTube sets this cookie to measure bandwidth, determining whether the user gets the new or old player interface. |
YSC | session | Youtube sets this cookie to track the views of embedded videos on Youtube pages. |
yt-remote-connected-devices | never | YouTube sets this cookie to store the user's video preferences using embedded YouTube videos. |
yt-remote-device-id | never | YouTube sets this cookie to store the user's video preferences using embedded YouTube videos. |
yt.innertube::nextId | never | YouTube sets this cookie to register a unique ID to store data on what videos from YouTube the user has seen. |
yt.innertube::requests | never | YouTube sets this cookie to register a unique ID to store data on what videos from YouTube the user has seen. |
Cookie | Duration | Description |
---|---|---|
WFESessionId | session | No description available. |