As part of our GA work for the ExecuteQueries REST API, we delivered a new Power Automate action to run queries against Power BI datasets. This action delivers a straightforward low-code/no-code experience to BI users who want to streamline repetitive, mundane tasks and processes. The purpose of this blog post is to help you get started running queries against datasets in Power Automate. It covers exporting data into csv files, building a solution to test datasets, and creating BI-driven cloud flows.
» Read more We are happy to announce that the ExecuteQueries REST API is now GA. By using this REST API, you can query datasets in Power BI from practically any modern environment on any platform, as long as you can authenticate with Azure Active Directory (AAD) and construct a Web request. The query functionality is comparable to XMLA read access, yet avoids dependencies on Analysis Services client libraries, requires no connection to XMLA endpoints, and works in Premium workspaces as well as in ordinary workspaces.
» Read more Today, we are excited to announce General Availability (GA) of automatic aggregations, along with several important improvements. By using automatic aggregations in Power BI Premium, you can unlock cloud-scale data volumes for interactive analysis. Automatic aggregations import data into the dataset only at the aggregated level while leaving the detail data at the source to minimize data duplication. In this way, most BI queries can benefit from Power BI’s blazing fast query performance in import mode, while occasional detail queries can still work transparently against the data source in DirectQuery mode.
» Read more SQL Server 2022 Analysis Services will support composite models and it is now ready for you to try out with the CTP2 that has just launched. After you install this CTP for SQL Server 2022 on a server, tabular models are hosted on that server can now be used to create a composite model with.
» Read more Announcing public preview of datamart in Power BI, a new Power BI Premium self-service capability that enables users to uncover actionable insights through their own independent and dependent data sets. For the first time ever, we are empowering everyone with the right-sized ability to build datamarts that can be succinctly and centrally governed and managed for workloads up to a terabyte. This new out-of-the-box Power BI capability effortlessly brings turnkey data warehousing to millions of Power BI users, alleviates demands on IT and accelerates time to insights from months to minutes.
» Read more 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.
» Read more We’re thrilled to be shipping Power BI Data storytelling that lets you add Power BI reports and bookmarks to your slides and enjoy the delightful interactive experience of Power BI inside your presentations. With data storytelling, data will always be up to date in your slides, whether you’re building a presentation or presenting it live to others.
» Read more We are excited to announce general availability for metrics in Power BI (formerly called goals) along with new features to deliver scorecarding scenarios even more effectively within Power BI. Additionally, we’re pleased to share plans for how Power BI will work with the new Viva Goals offering from Microsoft to empower organizations more effectively meet their goals with OKR experiences connected to Power BI data, delivered by Viva Goals.
» Read more Users can author formatted tables using a modern low code web-based authoring experience in the Power BI service.
» Read more We’re excited to announce that the Power BI tab in Microsoft Teams is getting a new action bar for interactive reports. The action bar enables users in the Power BI tab to use all the capabilities they have in the service when interactive reports are added to channels, chats, or meetings in Microsoft Teams. Read the blog to learn all about it.
» Read more