المنشورات المميزة بعلامة: Analysis Services

What’s new in SQL Server 2022 Analysis Services CTP 2.0

SQL Server 2022 Analysis Services is now available for public preview! SSAS 2022 tabular models now join forces in Power BI Desktop with other data to create composite models, speed up MDX queries used in Excel PivotTables, allow for more control over resources, and get data back to business users faster when demand is high.

» قراءة المزيد

Power BI bolsters Azure AS compatibility with EffectiveUserName support

We are announcing support for user impersonation using the EffectiveUserName connection-string property. This is truly exciting because it opens the door for mass migrations of tabular Analysis Services solutions that rely on EffectiveUserName-based impersonation to Power BI. It also opens new options for administrative tools and scripts to connect to datasets on Power BI Premium using different user identities! Impersonating another user can be as easy as specifying that user’s UPN on the connection string.

» قراءة المزيد

Announcing support for backup and restore of Power BI datasets

e are excited to announce the public preview of Backup and Restore for datasets in Power BI Premium and Premium per User (PPU). You can now use SQL Server Management Studio (SSMS), Analysis Services cmdlets for PowerShell, and other tools to perform backup and restore operations in Power BI via XMLA endpoints in much the same way as you would for tabular models in Azure Analysis Services (Azure AS).

» قراءة المزيد

Community and third-party tools for developing enterprise-level Power BI and Analysis Services models

Over the past few years, along with the high adoption rate of Power BI, also came the development of new tools by the Power BI community. Customers, partners, and individual users are contributing tools that improve the productivity of users creating models and reports in Power BI. It’s an evolution of a trend that started several years ago with tools that support developers using Analysis Services as a backend platform for their enterprise Business Intelligence solutions.

» قراءة المزيد