Select Page

In The Trenches

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

This is my third article about Tabular Editor, the others being the recent introduction article a few weeks ago, an also an article explaining how to copy measures between PBIX files. I watched the excellent … Move All Columns into a Display Folder with Tabular Editor Read More This post first appeared at https://exceleratorbi.com.au/move-all-columns-into-a-display-folder/. The author […]

This post first appeared at https://exceleratorbi.com.au/move-all-columns-into-a-display-folder/. The author is Matt Allington

Read More

Read More

One of the most common errors you’ll see when working with Power Query in Power BI or Excel is this: Expression.Error: The key didn’t match any rows in the table This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/Hq2tSS93JYk/. The author is Chris WebbRead More

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

Read More

Read More

Follow @gilra In my last tutorial here, you learned how to import COVID-19 confirmed and death cases from Johns Hopkins dataset to build your own Power BI dashboard using Power Query. In this tutorial, we will go quickly through the DAX measures that will help you gain better analytics capabilities using Power BI time intelligence. […]

This post first appeared at https://datachant.com/2020/04/03/covid-19-time-intelligence-in-power-bi/. The author is Gil Raviv

Read More

Read More

Have you ever seen the movie Limitless? In the film, Eddie Morra (played by Bradley Cooper) is a man whose life is in the dumps, but is turned around by a magic drug that enhances his mental acuity. With his… This post first appeared at https://powerpivotpro.com/2020/04/speed-up-your-power-bi-dax-formulas-by-up-to-95-using-the-new-optimizedax-function/. The author is Narayana WindenbergerRead More

This post first appeared at https://powerpivotpro.com/2020/04/speed-up-your-power-bi-dax-formulas-by-up-to-95-using-the-new-optimizedax-function/. The author is Narayana Windenberger

Read More

Read More

Seriously, I am so excited! And no, this is not an April fool’s joke!  This is an actual picture of Ken, Miguel and me from a few hours ago. Introducing Skillwave Training Today I am … Skillwave – Learn Power BI from Industry Experts Read More This post first appeared at https://exceleratorbi.com.au/skillwave-learn-power-bi-from-industry-experts/. The author is Matt AllingtonRead […]

This post first appeared at https://exceleratorbi.com.au/skillwave-learn-power-bi-from-industry-experts/. The author is Matt Allington

Read More

Read More

As the world grapples with COVID-19, it’s critical that public agencies working to stop the spread of the virus are equipped to give citizens timely and accurate information. Government agencies and non-profits are handling large amounts of data that are changing rapidly, and many of them are turning to Power BI to share data about […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/how-public-agencies-keep-communities-informed-on-covid-19-with-power-bi/. The author is 

Read More

Read More

Power BI is capable of flowing through all stages of a Business Intelligence process. In the session, we will see how phases are implemented and can get the most out of these features. This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-march-31-1100-am-pdt-power-bi-not-just-a-visualization-tool/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-march-31-1100-am-pdt-power-bi-not-just-a-visualization-tool/. The author is 

Read More

Read More

A few weeks ago I showed how XMLA Endpoints allow you to connect SQL Server Profiler to Power BI Premium. As well as looking at query execution times this also means you can see in more detail what happens when a dataset is refreshed, for example so you can find out exactly how long a […]

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

Read More

Read More

We’ve announced our ‘Better Together’-themed T-shirt design contest finalists! This post first appeared at https://powerbi.microsoft.com/en-us/blog/better-together-contest-finalists-announced/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/better-together-contest-finalists-announced/. The author is 

Read More

Read More

Well Covid-19 is a right royal pain in the backside for everyone. Am I right, or am I right? Everyone is effected to some extent, of course some more than others. One implication for me is … New Instructor Led Online Power BI Training Classes Read More This post first appeared at https://exceleratorbi.com.au/new-instructor-led-online-power-bi-training-classes/. The author is Matt AllingtonRead […]

This post first appeared at https://exceleratorbi.com.au/new-instructor-led-online-power-bi-training-classes/. The author is Matt Allington

Read More

Read More

Follow @gilra Note: Due to changes in the COVID-19 dataset that was published by Johns Hopkins (described here), I revised the original tutorial. Keep reading if you want to learn how to build your own Power BI Dashboard to analyze the spread of COVID-19 with the revised dataset. This post first appeared at https://datachant.com/2020/03/27/covid-19-build-your-own-power-bi-dashboard/. The author […]

This post first appeared at https://datachant.com/2020/03/27/covid-19-build-your-own-power-bi-dashboard/. The author is Gil Raviv

Read More

Read More

We are excited to announce the public preview of read/write capabilities for the XMLA endpoint in Power BI Premium. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-read-write-xmla-endpoints-in-power-bi-premium-public-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-read-write-xmla-endpoints-in-power-bi-premium-public-preview/. The author is 

Read More

Read More

As always, we love hearing from you to make Power BI better everyday. That is why we have another survey regarding performance for you to provide feedback. This post first appeared at https://powerbi.microsoft.com/en-us/blog/help-improve-power-bi-performance/. The author is Read More

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

Read More

Read More

Learn about the latest capabilities and future roadmap. Performance, scalability, management of Power BI artifacts, and monitoring are topics Christian Wade will cover. This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-march-26-200-pm-pdt-power-bi-premium-as-a-superset-of-analysis-services-the-read-write-xmla-endpoint/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-march-26-200-pm-pdt-power-bi-premium-as-a-superset-of-analysis-services-the-read-write-xmla-endpoint/. The author is 

Read More

Read More

Learn some great transformations that can save your ETL in Power BI This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-webinar-24-march-1100-am-1200-noon-pdt/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-webinar-24-march-1100-am-1200-noon-pdt/. The author is 

Read More

Read More

We’re happy to announce the general availability of Query Diagnostics for Power Query in Power BI. If you haven’t yet tried out the preview feature, Query Diagnostics is a powerful new feature that will allow you to determine what Power Query is doing during authoring and in some refresh workflows in Power BI Desktop. This […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-query-diagnostics/. The author is 

Read More

Read More

Multi Geo Performance Improvements This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-performance-improvements-for-multi-geo-premium-capacities/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-performance-improvements-for-multi-geo-premium-capacities/. The author is 

Read More

Read More

Power platform gateways managment This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-gateway-management-features-on-power-platform-admin-center/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-gateway-management-features-on-power-platform-admin-center/. The author is 

Read More

Read More

A very quick performance tip: do you have users consuming Power BI reports with Internet Explorer 11 and an older Windows OS like Windows 8.1 or Windows 7? If so, their reports are likely to be slower because over the last few months some important performance optimisations were made in Power BI that rely on […]

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

Read More

Read More

Tabular Editor is a community Open Source software project written by Daniel Otykier.   I have known about this product for several years but never really invested the time to understand what it does and how … Introduction to Tabular Editor for Business Users Read More This post first appeared at https://exceleratorbi.com.au/introduction-to-tabular-editor-for-business-users/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/introduction-to-tabular-editor-for-business-users/. The author is Matt Allington

Read More

Read More

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

Blogroll