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.
» 閱讀更多 Starting with SQL Server 2019 Cumulative Update (CU) 5, DAX-based clients such as Power BI can use SuperDAX functions and query patterns against multidimensional models to boost query performance.
» 閱讀更多 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.
» 閱讀更多 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
» 閱讀更多 It’s time again to recap the major features and announcements we made in the Power BI service and mobile for the month of July.
» 閱讀更多