Select Page

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 […]

Read More

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

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

Read 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

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

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 […]

Read More

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

Read 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 […]

Read More

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

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

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 […]

Read More

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

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

Read 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 […]

Read More

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 […]

Read More

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

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 […]

Read More

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 […]

Read More

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

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

Read More

Hansen BI brings you the latest insights from the most popular Microsoft Business Intelligence bloggers around the world

Blogroll