In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
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. […]
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 isWelcome to the May 2022 update. We are thrilled to announce the general availability of Canvas zoom and Data point rectangle select features, Field parameters and Error bars for columns and line combination charts new preview features, new Format pane and managing composite models preview feature updates. There is more to explore, please continue to […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-may-2022-feature-summary/. The author isGuest Author: Henk-Jan van Well As a follow up to two older Matrix Multiplication posts here and here, I would like to share with you an alternative query for matrix multiplication using the Cartesian product-functionality within Power Query. This post first appeared at https://datachant.com/2022/05/16/matrix-multiplication-using-the-cartesian-product-in-power-query/. The author is Delia FernandezRead More
This post first appeared at https://datachant.com/2022/05/16/matrix-multiplication-using-the-cartesian-product-in-power-query/. The author is Delia FernandezSeven years ago I gave a presentation at SQLBits called “Building a reporting solution using Power Query”. You can watch the recording here: https://sqlbits.com/Sessions/Event14/Building_A_Reporting_Solution_Using_Power_Query This post first appeared at https://blog.crossjoin.co.uk/2022/05/15/building-a-reporting-solution-using-excel-power-query-where-are-we-now/. The author is Chris WebbRead More
This post first appeared at https://blog.crossjoin.co.uk/2022/05/15/building-a-reporting-solution-using-excel-power-query-where-are-we-now/. The author is Chris WebbSandDance is a data visualization tool developed by the VIDA (Visualization and Interactive Data Analysis) team at Microsoft Research and is available as a custom visual for Power BI. SandDance uses unit visualizations, which apply a one-to-one mapping between rows in your data and marks on the screen. We have exciting updates coming for this […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/sanddance-power-bi-custom-visual-updates/. The author isPower BI just launched a new Known Issue page! This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-power-bi-known-issue-page/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-power-bi-known-issue-page/. The author isIf you’re using DirectQuery mode in Power BI you may occasionally run into the following error message: Couldn’t load the data for this visual This post first appeared at https://blog.crossjoin.co.uk/2022/05/08/understanding-the-we-couldnt-fold-the-expression-to-the-data-source-error-in-power-bi/. The author is Chris WebbRead More
This post first appeared at https://blog.crossjoin.co.uk/2022/05/08/understanding-the-we-couldnt-fold-the-expression-to-the-data-source-error-in-power-bi/. The author is Chris Webbnew data source and gateway management experience in Power BI This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-data-source-and-gateway-management-experience/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-data-source-and-gateway-management-experience/. The author isWe continue to iteratively improve experiences that help you find relevant content and return to your work in the Power BI service. Upon hearing your feedback, conducting usability tests, and running successful A/B experiments we’re sharing the following changes coming to all users in early June 2022. Here’s what’s coming: Navigation changes – the introduction […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/coming-soon-changes-to-the-power-bi-service-simpler-navigation-improvements-to-lists-on-home-and-style-updates/. The author isA few months ago one of my colleagues at Microsoft, David Browne, showed me an interesting Power Query problem with how the Xml.Tables and Xml.Document M functions handle null or missing values. I’m posting the details here because the problem seems fairly common, it causes a lot of confusion and it’s not easy to deal […]
This post first appeared at https://blog.crossjoin.co.uk/2022/05/01/the-power-query-xml-functions-missing-or-null-values-and-inconsistent-schema-inference/. The author is Chris Webb