Select Page

In The Trenches

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

We have great updates this release! We’re super excited to announce this month that several features are now generally available: automatic page refresh, the hierarchy slicer, the modern ribbon, and AI insights are now generally available. On top of this, we have several new features and updates that will really improve your reporting: many enhancements […]

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

Read More

Read More

We are excited to introduce an improved mobile layout authoring experience. With the new capabilities introduced in this release, you can build compelling, interactive reports optimized for mobile devices. This post first appeared at https://powerbi.microsoft.com/en-us/blog/create-stunning-mobile-reports-with-the-updated-mobile-authoring-in-power-bi-desktop/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/create-stunning-mobile-reports-with-the-updated-mobile-authoring-in-power-bi-desktop/. The author is 

Read More

Read More

This is where we’re headed in Part Two. Today: taking stock of how we got here. (Click image for larger version) Summary of this 2-part piece: There’s always been a blurry line between Analysis and Reporting 20 years ago, BI was dominated by Reporting, with Analysis as an upstart Today, Analysis seems to have “won,” […]

This post first appeared at https://powerpivotpro.com/2020/06/power-bi-and-paginated-reports-have-we-come-full-circle/. The author is Rob Collie

Read More

Read More

In the last two posts in this series I showed how removing columns from the tables used in a Power Query merge operation can improve refresh performance. In this post I’ll show you a different trick that – when you can use it – can give you an equally significant performance boost. When you merge […]

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

Read More

Read More

Follow @gilra In my last tutorial here, you learned how to apply a What-If technique to calculate the estimated active cases of COVID-19. In this part, you will learn how to run running averages to smooth the trend lines of any measure you use. This post first appeared at https://datachant.com/2020/06/06/covid-19-time-running-average/. The author is Gil RavivRead More

This post first appeared at https://datachant.com/2020/06/06/covid-19-time-running-average/. The author is Gil Raviv

Read More

Read More

Power BI is and incredible product, yet there are still niggling issues that can frustrate and annoy the best of us (me included).  Having said that, changes and improvements are happening all the time and it is easy for new features that address old issues to slip past us without […]Read More » This post […]

This post first appeared at https://exceleratorbi.com.au/3-great-new-features-in-power-bi-desktop/. The author is Jason Cockington

Read More

Read More

In my last post I demonstrated how the size of a table affects the performance of Power Query merge operations on non-foldable data sources in Power BI. Specifically, I showed that removing columns from the tables involved in a merge before the merge took place improved performance. But does it matter when you remove the columns? […]

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

Read More

Read More

Merging (or, in SQL terms, joining) tables in Power Query is a common cause of refresh performance problems. I’ve often wondered whether there’s anything you can do to optimise the performance of merges and so I decided to run some tests to try to answer all the questions I had. In this series of posts […]

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

Read More

Read More

Today, we wanted to announce our roadmap for workspace upgrade so you can plan ahead.  We also announce in this post our classic workspace deprecation plans. If you’re a Power BI admin or workspace admin, this is a must read. This post first appeared at https://powerbi.microsoft.com/en-us/blog/roadmap-update-whats-next-for-the-new-workspace-experience-upgrade-in-the-coming-months/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/roadmap-update-whats-next-for-the-new-workspace-experience-upgrade-in-the-coming-months/. The author is 

Read More

Read More

We are excited to announce Direct Query support (Preview) for Power BI dataflows.  You can now connect directly to a dataflow without first requiring to import the data into a dataset.  This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-direct-query-support/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-direct-query-support/. The author is 

Read More

Read More

We are excited to bring you a new version of Power BI Report Server this month! With this update, we’re releasing a bevy of features across all aspects of Power BI: hierarchical slicer and decomposition tree visuals, query diagnostics, and more. Read on to get the full details of all the new additions! This post […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-may-2020-feature-summary/. The author is 

Read More

Read More

I see lots of chatter on Twitter and other media about the use of “small multiples” as a great way to communicate information across different subsets of data – yes Jeff Weir(d), that means you. I thought I would write a quick article about the concept to draw your awareness […]Read More » This post […]

This post first appeared at https://exceleratorbi.com.au/small-multiples-using-zebra-bi-custom-visuals/. The author is Matt Allington

Read More

Read More

We are pleased to announce the new page view option for Paginated Reports is now available in the Power BI service. This post first appeared at https://powerbi.microsoft.com/en-us/blog/page-view-for-paginated-reports-now-available-in-power-bi/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/page-view-for-paginated-reports-now-available-in-power-bi/. The author is 

Read More

Read More

If you’re working with large amounts of data in Power BI you may find that you have problems because: Your pbix file is very large This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/cXz1XmmwYGE/. The author is Chris WebbRead More

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

Read More

Read More

You asked for the sessions, and we’ve got them for you! View over 50 great sessions from the Microsoft Business Applications Summit 2020. Here’s the Power Platform sessions quick reference blog This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-business-applications-summit-2020-power-platform-sessions-quick-reference/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-business-applications-summit-2020-power-platform-sessions-quick-reference/. The author is 

Read More

Read More

In the April release of Power BI Desktop the Power Query Query Diagnostics feature was enhanced so that you can now return performance counter data. As the blog post says: When you run performance counters, every half second Power Query will take a snapshot of resource utilization. This isn’t useful for very fast queries but […]

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

Read More

Read More

We are excited to announced general availability (GA) of shared and certified datasets in Power BI. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-ga-of-shared-and-certified-datasets-in-power-bi/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-ga-of-shared-and-certified-datasets-in-power-bi/. The author is 

Read More

Read More

Earlier this week, Microsoft announced that Azure Synapse Analytics, the next generation of Azure SQL Data warehouse, is now available for public preview. Azure Synapse provides incredible performance over large data volumes and has built-in capabilities for data ingestion, data preparation, machine learning, and visualization, while accelerating time to value and reducing TCO. And it […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-azure-synapse-analytics-public-preview/. The author is 

Read More

Read More

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

Read More

Read More

Refresh Summaries Announcement This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-refresh-summary-for-premium-capacity-admins/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-refresh-summary-for-premium-capacity-admins/. 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