Select Page

In The Trenches

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

We’re happy to announce that Auto ML in Power BI is generally available in all public cloud regions where Power BI Premium and Embedded is available. Using Auto ML in Power BI, business analysts can build ML models to solve business problems that once required data scientists. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-automated-machine-learning-in-power-bi-general-availability/. The author is Read […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-automated-machine-learning-in-power-bi-general-availability/. The author is 

Read More

Read More

The Desired End Result: Compare Two Entities in a Specific Visual Style (Used here for football QB’s, but perhaps useful in other “head to head” comparisons – products, ad campaigns, etc.) Setting the Stage: a “Risk” This is one of… This post first appeared at https://powerpivotpro.com/2019/10/head-to-head-comparison-infographic-in-power-bi/. The author is Rob CollieRead More

This post first appeared at https://powerpivotpro.com/2019/10/head-to-head-comparison-infographic-in-power-bi/. The author is Rob Collie

Read More

Read More

It’s time again to recap the features and announcements in the Power BI service and mobile for the month of September. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-september-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-september-2019-feature-summary/. The author is 

Read More

Read More

The new contact list for reports and dashboards makes it easy to support end users by providing a contact list that includes multiple users or even groups in the Power BI service. When used with the New Look for the Power BI service, end users can quickly find and contact someone to make timely data […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-new-contact-lists-for-reports-and-dashboards-in-the-power-bi-service/. The author is 

Read More

Read More

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

Read More

Read More

Since last week’s post proved very popular (it turns out people want video – who knew?) I thought I’d post the recording of a presentation I did earlier this year at the Power BI User Group in Wellington, New Zealand, called “Introduction to M in Power Query and Power BI”. It’s a session I’ve presented […]

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

Read More

Read More

WIN SWAG! Visit the Power BI community to get answers to your questions and connect with others to see cool examples of how people are using Power BI. https://aka.ms/commkudo This post first appeared at https://powerbi.microsoft.com/en-us/blog/win-power-bi-swag-with-community-kudopalooza/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/win-power-bi-swag-with-community-kudopalooza/. The author is 

Read More

Read More

Today, we are making scheduling of refreshes much more flexible to improve how Power BI works in processes like the ones described above. Specifically, we have added a new Refresh a dataset action to the Power BI connector for Microsoft Flow. This post first appeared at https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/. The author is 

Read More

Read More

Follow @gilra DataChant is launching a new series that will focus on bad practices in Power BI. Instead of sharing with you tips & tricks on how to deliver best-of-breed analytics solutions in Power BI, let us try taking the opposite approach, and share the most common worst things you may do in Power BI. […]

This post first appeared at https://datachant.com/2019/10/17/bad-practices-power-bi-pie-charts/. The author is Gil Raviv

Read More

Read More

Pubic preview- PowerShell gateway This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-management-via-powershell-public-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-management-via-powershell-public-preview/. The author is 

Read More

Read More

This month’s update is filled with major updates across the whole product. In the data preparation area, we’ve introduce query diagnostics, which allow you to see what queries are being run behind the scenes. On the reporting side, we are taking a huge step forward in terms of real time reporting, with our new automatic […]

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

Read More

Read More

This week I was honoured to be a guest on the Guy In A Cube channel, and for my topic I decided to tackle one of life’s eternal questions: why does Power BI query my data source more than once when I refresh my dataset? You can watch the video here: This post first appeared […]

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

Read More

Read More

I have been planning for various speaking and training events over the last 6 months and these events are now rapidly approaching.  As it turns out, it seems I have a bit of a world … Matt’s Power BI World Tour Read More This post first appeared at https://exceleratorbi.com.au/matts-power-bi-world-tour/. The author is Matt AllingtonRead More

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

Read More

Read More

Our guest today is Sandeep Pawar. A Simulation & Data Analytics Engineer at Cree Lighting in Racine, WI. Sandeep applies Data Analytics, Statistics, and Machine Learning to improve Manufacturing operations. You can contact him here. I wanted to share with you today an interesting challenge that I solved recently. I received quality inspection data (You […]

This post first appeared at https://datachant.com/2019/10/11/guest-story-unpivot-pairs-of-columns/. The author is Gil Raviv

Read More

Read More

It is with great pleasure that the Power BI User Group announced the 2019 Power BI User Group Global Hackathon winning team as… This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-2019-power-bi-user-group-global-hackathon-champions/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-2019-power-bi-user-group-global-hackathon-champions/. The author is 

Read More

Read More

Last week I held a free Power BI webinar for people starting out with Power BI who are wondering why they should invest time in learning about DAX. I had more than 700 people register … Power BI Webinar Overflow Q&A Read More This post first appeared at https://exceleratorbi.com.au/power-bi-webinar-overflow/. The author is Matt AllingtonRead More

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

Read More

Read More

Case sensitivity is one of the more confusing aspects of Power BI: while the Power Query engine is case sensitive, the main Power BI engine (that means datasets, relationships, DAX etc) is case insensitive. Imke Feldmann shows how to make Power Query case insensitive through custom M here; in this blog post I’m going to […]

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

Read More

Read More

Power BI and Azure Analytics help businesses build a data-driven culture and drive analytics proficiency.  This has been seen in recent findings from the commissioned Forrester Consulting study, The Total Economic Impact™ Of Microsoft Azure Analytics With Power BI. The study specifies that together, Azure Analytics and Power BI can provide value to customers by […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/increase-business-impact-with-power-bi-and-azure-analytics/. The author is 

Read More

Read More

The Microsoft business applications virtual launch event is almost here! You don’t want to miss this opportunity to get a first-hand look at the new innovations we’re rolling out for Power BI. Register today for this free event, and then tune in to the live stream on October 10, 2019 from 8:00 AM – 9:30 […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-updates-at-the-microsoft-business-applications-october-virtual-launch-event/. The author is 

Read More

Read More

Level: Intermediate Recently Microsoft introduced a new function in DAX called REMOVEFILTERS(). This is a very useful and well named function and it does exactly what its name suggests. Its purpose is to act as … REMOVEFILTERS() in DAX Read More This post first appeared at https://exceleratorbi.com.au/removefilters-in-dax/. The author is Matt AllingtonRead More

This post first appeared at https://exceleratorbi.com.au/removefilters-in-dax/. 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