Select Page

In The Trenches

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

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

We have lots of great updates this release! We’re super excited to announce this month that both the decomposition tree and drill through button actions are now generally available. On top of this, we have several new features and updates that will really enrich your reporting: curate featured tables for Excel, new Apply button for […]

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

Read More

Read More

We’ve got another PBI Community recap for you! This post first appeared at https://powerbi.microsoft.com/en-us/blog/april-2020-community-highlights/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/april-2020-community-highlights/. The author is 

Read More

Read More

We are very pleased to announce the availability of the Power BI Premium Capacity Metrics App as a template app. This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-premium-capacity-metrics-app-as-a-template-app/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-premium-capacity-metrics-app-as-a-template-app/. The author is 

Read More

Read More

In Power BI, you can now use service principals to automate common tasks such as deploying models, performing a data refresh, and applying model changes. Permissions are assigned to service principals through workspace membership, much like regular user accounts. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-support-for-service-principals-using-the-xmla-endpoint-in-power-bi-premium/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-support-for-service-principals-using-the-xmla-endpoint-in-power-bi-premium/. The author is 

Read More

Read More

We’re excited to announce new developer samples for Power BI embedded analytics. These new samples should help developers get up and running quickly in a variety of programing languages and frameworks, and provide examples of REST APIs calls from different programing languages. This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-developer-samples-for-power-bi-embedded/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-developer-samples-for-power-bi-embedded/. The author is 

Read More

Read More

We are happy to announce the public preview release of Power BI Deployment Pipelines, a new and improved way for BI teams to manage content lifecycle within Power BI Premium. This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-deployment-pipelines-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-deployment-pipelines-preview/. The author is 

Read More

Read More

It can sometimes be frustrating to work with slow data sources or complex Power Query queries in Power BI Desktop: you open the Power Query Editor, make some changes, click Close & Apply and then wait a loooong time for your data to refresh. In this post I’m going to show you a technique that […]

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

Read More

Read More

Veolia, a French transnational environmental service company, created a dedicated portal for customer insights and analytics built using embedded Power BI reports. Underpinning these Power BI reports is Azure data architecture.    This post first appeared at https://powerbi.microsoft.com/en-us/blog/how-veolia-improves-customer-experiences-with-power-bi-and-azure/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/how-veolia-improves-customer-experiences-with-power-bi-and-azure/. The author is 

Read More

Read More

There was a very subtle but important change made in the April 2020 release of Power BI Desktop that you may have missed. Take a look in the format pane on the right in the … Expression Based Formatting in DAX Read More This post first appeared at https://exceleratorbi.com.au/expression-based-formatting-in-dax/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/expression-based-formatting-in-dax/. The author is Matt Allington

Read More

Read More

Follow @gilra In case you watched the MBAS virtual summit sessions, you might saw me in minute 11:11 of the keynote session here. I was recently recognized by Microsoft as a Fast Track Solution Architect (Find all recognized Power Platform architects here). According to Microsoft, and I quote: “This prestigious recognition is conferred by the […]

This post first appeared at https://datachant.com/2020/05/11/fasttrack-recognized-solution-architect/. The author is Gil Raviv

Read More

Read More

If you’ve ever used DAX Formatter to format your DAX code and wondered why there isn’t an equivalent for Power Query/M, then wonder no more: the nice people at Power Pivot Insights in Germany (read their German-language blog here) have built one. You can find it here: https://powerqueryformatter.com/ This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/FVHzPj8CBNw/. The author […]

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

Read More

Read More

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

Blogroll