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.
» Lue lisääThe capability to pass custom data for row level security is now available in Power BI Premium, Power BI Embedded, and Power BI Premium per User.
» Lue lisää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.
» Lue lisääPower BI is the leading platform for both self-service and IT-managed enterprise BI. We have taken great strides to bring AAS capabilities to Power BI. Power BI has inherited a large ecosystem of developers, partners, BI tools, and solutions built up over decades.
» Lue lisääToday, we are announcing General Availability (GA), along with several enhancements.
» Lue lisää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.
» Lue lisää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.
» Lue lisää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.
» Lue lisää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
» Lue lisääThis is the first blog post dedicated to Analysis Services on the Power BI blog. As discussed in this post on the old Analysis Services team blog, Microsoft is moving off MSDN and TechNet blogs. We have made it clear that Power BI will be a one-stop shop for both enterprise and self-service BI on …
» Lue lisää