In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
Back in March, with the publication of the Dynamics 365 Release Notes document (which you can download here, halfway down the page), we learned a lot about the roadmap of Power BI; my blog post here summarises the announcements. However, on Twitter Matthew Roche reminded me that it is a living document and indeed it […]
See how many of the internal teams at Microsoft are using Zebra BI visuals to visualize typical business data such as YOY growth. This post first appeared at https://powerbi.microsoft.com/en-us/blog/5-29-webinar-building-spectacular-power-bi-dashboards-with-zebra-bi-visuals/. The author is Read More
Why Fly Home Tuesday Night? Make it an epic week. Join me in Seattle for a full week of Power BI Goodness Hi folks, in what’s become a tradition, we like to teach classes in Seattle and schedule them consecutively… This post first appeared at https://powerpivotpro.com/2018/05/combine-biz-apps-summit-with-p3-training-classes/. The author is Rob CollieRead More
Power Bi Webinar, focusing on how time intelligence can be used for analysis in retail and wholesale industries This post first appeared at https://powerbi.microsoft.com/en-us/blog/5-24-webinar-time-intelligence-for-retail-and-wholesale-industries-with-power-bi-by-matt-allington/. The author is Read More
We are excited to announce that we have released the May update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release Impala SSO… This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-may-update-is-now-available/. The author is Read More
About two years ago I wrote a blog post describing how the #table M function can be used to generate tables, but in that post I only covered the functionality I used regularly – namely using #table with a list of column names or a table type in the first parameter. However there two other […]
Disconnected Slicers With DAX Variables & SELECTEDVALUES Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially… This post first appeared at https://powerpivotpro.com/2018/05/disconnected-slicers-with-dax-variables-selectedvalues/. The author is Reid HavensRead More
Level: Intermediate to Advanced Matt here. I recently met Parker Stevens online through LinkedIn – he too is a Power BI fan, just like me. Parker has shared a few techniques with me that I found very interesting. These topics have not been covered on my blog before and hence I thought it was a […]
We love hearing feedback from the Power BI community and today we have another quarterly survey to keep improving Power BI with your feedback. This post first appeared at https://powerbi.microsoft.com/en-us/blog/help-improve-power-bi/. The author is Read More
Join Microsoft Program Managers, Mathew Roche and Charles Sterling in this demo heavy webinar for a tour of the Common Data Service for Apps, Common Data Service for Analytics and Power BI Insights Apps This post first appeared at https://powerbi.microsoft.com/en-us/blog/5-17-webinar-a-look-at-the-common-data-service-for-apps-common-data-service-for-analytics-and-power-bi-insights-apps/. The author is Read More
Back in 2012 I wrote a blog post explaining how to handle multi-value parameters in DAX queries in Reporting Services reports. The approach I took back then was basically: Generate a string containing a pipe-delimited list of all the parameter values that the user has selected (I did this in DAX too, but to be […]
Power BI Premium was announced generally available less than a year ago as the platform of choice for enterprises deploying high-performance, scalable BI systems in the cloud. In the May release of… This post first appeared at https://powerbi.microsoft.com/en-us/blog/incremental-refresh-in-power-bi-premium/. The author is Read More
Today, we’ll look at Power BI workspaces, apps, and how to keep changes from mucking up reports. In the software development lifecycle, a distinct space to test new reports ensures consistent results. Moreover, it’s part of good governance. This post builds… This post first appeared at https://powerpivotpro.com/2018/05/power-bi-workspaces-apps/. The author is Fred KaffenbergerRead More
Follow @gilra Working with column types can be challenging in Power Query. The default conversion of types may not always work well for you, and may create future refresh errors, when the column names change. I have blogged about it in details here, and usually recommend to use explicit type conversion, and remove the automatic Changed […]
We’re bringing our BizApps community together for the first-ever Microsoft Business Applications Summit, *the* place for Dynamics 365, Power BI, Excel, PowerApps and Flow superfans to connect, collaborate and pack in as much learning as possible, July 22-24 in Seattle. Whether you’re a BizApps whiz or one in the making, this all-new conference has something […]
Today, I am thrilled to announce the availability of dashboard theming in the Power BI service. Power BI dashboards pull together reports, images, Excel workbooks, and more, to provide a 360-degree… This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-dashboard-theming-in-the-power-bi-service/. The author is Read More
As a quick follow-on from last week’s post on how to detect whether query folding is taking place when importing from OData data sources, if you’re importing data from Analysis Services you have a similar problem: how do you know whether query folding is taking place? Ensuring that query folding takes place for as many […]
We’re excited to announce registration is open for the first-ever Microsoft Business Applications Summit, coming to Seattle July 22–24! Combining the best of the Microsoft Data Insights Summit, Convergence, and the Dynamics 365 Technical Conference, this new event is designed to help you create the best, lasting solutions for your business. This post first appeared […]
April turned out to be exciting month for the Power BI team. Mostly because we got to meet many of you, our awesome community members, at the Data & BI Summit in Dublin. Huge thank you for those… This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-april-2018-feature-summary/. The author is Read More
What an amazing year 2018 has started out to be! Joining the PowerPivotPro team was an aspiration of mine that started in the Fall of 2013… I wanted to BE a part of this team and this community – to… This post first appeared at https://powerpivotpro.com/2018/05/powerquerymagic-advance-folder-combine/. The author is Krissy DyessRead More