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 isThe 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 CollieIt’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 isThe 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 isOctober 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 isSince 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 WebbWIN 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 isToday, 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 isFollow @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 RavivPubic 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 isThis 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 isThis 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 WebbI 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 AllingtonOur 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 RavivIt 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 isLast 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 AllingtonCase 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 WebbPower 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 isThe 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 isLevel: 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