Select Page

In The Trenches

With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS

Today, I am thrilled to announce the release of custom branding for the Power BI service. Now you can change the look and feel of the Power BI service to match your corporate theme with just a few clicks! This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-custom-branding-for-your-organization/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-custom-branding-for-your-organization/. The author is 

Read More

Read More

One common requirement I have come across a few times is to limit a Power BI visual to only show completed months and exclude the current active month. This is common if you load data … Dynamically Show Completed Months in Power BI Read More This post first appeared at https://exceleratorbi.com.au/dynamically-show-completed-months-in-power-bi/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/dynamically-show-completed-months-in-power-bi/. The author is Matt Allington

Read More

Read More

Following on from my last two posts on Power Query performance, I thought I would write about another trick that can make a big difference to your query execution times. It’s actually something that Ehren from the dev team mentioned in a forums thread that I blogged about here but it deserves to be better […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/QvRJ5Rs_avw/. The author is Chris Webb

Read More

Read More

August release of Gateway This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-august-2019-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-august-2019-update-is-now-available/. The author is 

Read More

Read More

Our August release has another hotly anticipated feature from the Microsoft Business Application Summit, grouping. Grouping in reports, similar to PowerPoint’s grouping, lets you easily organize groups of visuals to move and resize them as a set. This month’s release also has some updates to our newest features, such as a  icon set picker for […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2019-feature-summary/. The author is 

Read More

Read More

A few weeks ago I wrote an article about the Power BI Icon feature released in July 2019. You can read that article here https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/ There were 2 common questions/themes coming from readers’ comments, and … Power BI Icon Names Read More This post first appeared at https://exceleratorbi.com.au/power-bi-icon-names/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/power-bi-icon-names/. The author is Matt Allington

Read More

Read More

Power BI Mobile team partnered with Azure Active Directory team to integrate Power BI mobile applications with Azure Active Directory (AAD) Application Proxy to connect to Report Server from their mobile app, without the need to setup complex on-premise configuration. This post first appeared at https://powerbi.microsoft.com/en-us/blog/access-on-prem-report-server-from-your-power-bi-mobile-app-with-azure-active-directory-application-proxy/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/access-on-prem-report-server-from-your-power-bi-mobile-app-with-azure-active-directory-application-proxy/. The author is 

Read More

Read More

Five new Power BI Premium Capacity settings are available in the portal , preloaded with default values. Admin can review and override the defaults with their preference to better protect their capacity from running into issues and avoid problems before they arise. This post first appeared at https://powerbi.microsoft.com/en-us/blog/five-new-power-bi-premium-capacity-settings-is-available-on-the-portal-preloaded-with-default-values-admin-can-review-and-override-the-defaults-with-their-preference-to-better-fence-their-capacity/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/five-new-power-bi-premium-capacity-settings-is-available-on-the-portal-preloaded-with-default-values-admin-can-review-and-override-the-defaults-with-their-preference-to-better-fence-their-capacity/. The author is 

Read More

Read More

In part 1 of this series – which I strongly recommend you read before reading this post – I showed how removing columns from a table can make a dramatic improvement to the performance of certain transformations in Power Query. In this post I’ll show some tricks taught to me by Curt Hagenlocher of the […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/TN-sAKL_Wco/. The author is Chris Webb

Read More

Read More

It’s time again to recap the major features and announcements we made in the Power BI service and mobile for the month of July. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-july-2019-feature-summary/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-july-2019-feature-summary/. The author is 

Read More

Read More

With the public preview available for “Multi-Protocol Access” on Azure Data Lake Storage Gen2, now AAS can use the Blob API to access files in ADLSg2. Check how to do it! This post first appeared at https://powerbi.microsoft.com/en-us/blog/connecting-azure-analysis-services-to-azure-data-lake-storage-gen2/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/connecting-azure-analysis-services-to-azure-data-lake-storage-gen2/. The author is 

Read More

Read More

I’ve just learned some really interesting new Power Query/M optimisation tricks! I’m going to write them up here as a series of worked examples rather than generalised patterns because I’m still trying to understand them properly myself and I’m not really sure what lessons to draw from them exactly; instead, I hope they give you […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/F9HP_91O9sY/. The author is Chris Webb

Read More

Read More

Take our survey to help us continue to improve copy vs. export related scenarios in Power BI. This post first appeared at https://powerbi.microsoft.com/en-us/blog/help-improve-power-bi-copy-vs-export-survey/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/help-improve-power-bi-copy-vs-export-survey/. The author is 

Read More

Read More

As we head into August, we’ve released two feature updates for Paginated Reports in Power BI, with several more on the way.  This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-reports-august-2019-feature-update-report-builder-update-saas-embedding-support-and-whats-coming-soon/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-reports-august-2019-feature-update-report-builder-update-saas-embedding-support-and-whats-coming-soon/. The author is 

Read More

Read More

Level: Intermediate In my last article, I introduced the basics of the DAX FILTER() function. Hopefully that introductory explanation to FILTER() helped you get your head around what FILTER() is doing under the hood. With … The FILTER Function in DAX Part 2 Read More This post first appeared at https://exceleratorbi.com.au/the-filter-function-in-dax-part-2/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/the-filter-function-in-dax-part-2/. The author is Matt Allington

Read More

Read More

Last month, Power BI partnered with Hacking STEM and NASA to create an interactive, educational data story to teach students about radiation. Educators loved the idea of bringing Power BI data stories to the classroom, and they are looking for more! So, this month we are launching a “Back to School” Contest to engage and […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-back-to-school-contest/. The author is 

Read More

Read More

Follow @gilra In the last post here, we walked through the steps to detect overlapping time periods and calculate their durations. We used Cartesian Product to match all the pairs of tasks of the same resource, and even used the M function Table.Buffer to accelerate the load of the table. This post first appeared at https://datachant.com/2019/07/31/find-overlapping-time-periods-using-powerquery-3/. […]

This post first appeared at https://datachant.com/2019/07/31/find-overlapping-time-periods-using-powerquery-3/. The author is Gil Raviv

Read More

Read More

A few years ago I blogged about the Table.Profile M function and how you could use it to create a table of descriptive statistics for your data: Descriptive Statistics In Power BI/M With Table.Profile() This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/p_wNSM5qUzg/. The author is Chris WebbRead More

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/p_wNSM5qUzg/. The author is Chris Webb

Read More

Read More

This blog post covers the latest updates for Power BI embedded analytics and Custom Visuals. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-june-july-update/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-june-july-update/. The author is 

Read More

Read More

New South Africa Region This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-power-bi-region-in-south-africa/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-power-bi-region-in-south-africa/. The author is 

Read More

Read More

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

Blogroll