With the availability of virtual machine images for SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) in Azure Marketplace, you can now more easily migrate your AS and RS BI solutions from on-premises to Azure! This is a great opportunity to move your multidimensional workloads closer to Power BI to reduce the physical distance between your AS servers and your Power BI reports. For the same reasons, it’s also a good idea to deploy Azure VMs running SSRS in the same region as your SSAS VMs, or to migrate your paginated reports to Power BI so that your reports have the most efficient connectivity to their data models.
» 詳細を読む With a recent update of the Analysis Services Tabular engine in Power BI, Multidimensional Expressions (MDX) clients, such as Microsoft Excel, can now enjoy improved query performance against datasets in Power BI.
» 詳細を読む Today, we are further enabling external tools to work with Power BI datasets, this time from within the Power BI Desktop authoring experience. We are excited to announce the public preview of external tool support in Power BI Desktop.
» 詳細を読む In Power BI, you can now use service principals to automate common tasks such as deploying models, performing a data refresh, and applying model changes. Permissions are assigned to service principals through workspace membership, much like regular user accounts.
» 詳細を読む It’s time to recap all the features and announcements we made for the Power BI service and mobile for the months of February and March.
» 詳細を読む We are excited to announce the public preview of read/write capabilities for the XMLA endpoint in Power BI Premium.
» 詳細を読む Puzzled when to use Power BI Premium vs Azure Analysis Services? Power BI Premium is where future investments will be made but there are things to consider when making a choice.
» 詳細を読む It’s time to recap all the features and announcements we made for the Power BI service and mobile for the months of October and November.
» 詳細を読む We are excited to announce the public preview of large models in Power BI Premium. This enables fast user interactivity over large datasets. Until now, dataset caches in Power BI Premium have been limited to 10 GB after compression. Large models remove this limitation, so dataset cache sizes are limited only by the Power BI Premium capacity size.
» 詳細を読む We are excited to announce RC1 of SQL Server 2019 Analysis Services (SSAS 2019). The SSAS 2019 release is now feature complete! We may still make performance improvements for the RTM release. RC1 introduces the following features: Custom ordering of calculation items in calculation groups Query interleaving with short query bias for high concurrency workloads Online attach for optimized synchronization of read-only replicas SuperDAXMD for improved performance of Power BI reports over SSAS multidimensional Governance setting to control Power BI cache refreshes
» 詳細を読む