In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
On-premises data gateway May 2022 update is now available This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-may-2022-update-is-now-available/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-may-2022-update-is-now-available/. The author isAs 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 […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/unlocking-new-self-service-bi-scenarios-with-executequeries-support-in-power-automate/. The author isWe’re excited to bring you a new version of Power BI Report Server this Spring! With the May 2022 update, we have a variety of new enhancements, including Dynamic format strings support, multi row card selection, canvas zoom, updated slicer defaults and many more. Please continue to read on! This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-may-2022-feature-summary/. The […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-may-2022-feature-summary/. The author isWe 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 […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-the-executequeries-rest-api/. The author isMay 2022’s release of Power BI Desktop is the best releases we’ve seen in several years. They released a new gem of a featured called FIELD PARAMETERS and this blog is going to go over the benefits to you as a developer While there are a ton of blogs and videos already out there covering how incredible […]
This post first appeared at https://p3adaptive.com/2022/05/completing-the-set-up-field-parameters-using-tabular-editor/. The author is Mark BeedleToday, 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 […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-automatic-aggregations/. The author isSQL 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. […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/composite-models-on-sql-server-analysis-services/. The author isMicrosoft Build represents the ultimate developer event. A hundred thousand developers from across the world gather for three days with their peers to learn, engage, and collaborate on the latest innovations and tools from Microsoft. This post first appeared at https://powerbi.microsoft.com/en-us/blog/democratize-enterprise-analytics-with-microsoft-power-bi/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/democratize-enterprise-analytics-with-microsoft-power-bi/. The author isAnnouncing 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 […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-public-preview-of-datamart-in-power-bi/. The author isSQL 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. […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/whats-new-in-sql-server-2022-analysis-services-ctp-2-0/. The author isWe’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 […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/tell-a-story-with-your-data-announcing-the-all-new-power-bi-integration-for-powerpoint/. The author isWe 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 […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-goals-is-now-metrics-and-is-moving-to-ga/. The author isI have many reasons for sharing content online. The main reasons are that I like sharing what I know, but also that I want to document how to complete a task for future reference. My article today ticks both of those boxes. How Many Employees by Period I’m calling this […]Read More » This post […]
This post first appeared at https://exceleratorbi.com.au/how-many-employees-by-period/. The author is Matt AllingtonIf you have sensitive data in your Power BI dataset you may need to stop some users seeing the data in certain columns or measures. There is only one way to achieve this: you have to use Object Level Security (OLS) in your dataset. It’s not enough to exclude those measures or columns from your […]
This post first appeared at https://blog.crossjoin.co.uk/2022/05/22/stopping-some-users-seeing-certain-columns-or-measures-in-your-power-bi-report-with-object-level-security-and-field-parameters/. The author is Chris WebbUsers can author formatted tables using a modern low code web-based authoring experience in the Power BI service. This post first appeared at https://powerbi.microsoft.com/en-us/blog/exportable-formatted-data-tables-preview/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/exportable-formatted-data-tables-preview/. The author isThe May 2022 version of Power BI Desktop includes a very interesting and useful feature – Field Parameters. Today I will show you how to use this new feature illustrating with 3 (no, wait, 4) use cases – Chart Elements, Chart Axis, Table Contents and Permanent Ad hoc Hierarchies. How […]Read More » This post […]
This post first appeared at https://exceleratorbi.com.au/field-parameters-in-power-bi/. The author is Matt AllingtonJoin us to learn about Power Query custom functions with Ted Pattison and special guest Alex Powers! This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-power-bi-dev-camp-thursday-26-may-2022-at-1100-am-pdt/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-power-bi-dev-camp-thursday-26-may-2022-at-1100-am-pdt/. The author isAs part of the Gartner Data and Analytics Summit EMEA in London, UK, Gartner invited Microsoft to participate in their bake-off event. This year’s topic was the UN’s Sustainable Development Goals, and we dug into data around access to electricity and CO2 emissions. This post first appeared at https://powerbi.microsoft.com/en-us/blog/analyzing-the-uns-sustainable-development-goals-at-gartner-data-analytics-summit-emea/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/analyzing-the-uns-sustainable-development-goals-at-gartner-data-analytics-summit-emea/. The author isIn the future you’re going see me writing blog posts on the official Power Query blog as well as here on my own personal blog, and indeed the first of these posts went live a few hours ago. It’s on a new M function called Table.StopFolding which, as the name suggests, stops query folding taking […]
This post first appeared at https://blog.crossjoin.co.uk/2022/05/16/im-posting-on-the-power-query-blog-too/. The author is Chris WebbWe’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 […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-action-bar-for-interactive-reports-in-the-power-bi-tab-for-microsoft-teams/. The author is