In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
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 WebbOur 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 RavivLast 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 AllingtonWhile the documentation on how to import data from Azure Data Lake Gen2 Storage into Power BI is pretty detailed, the connector (which at the time of writing is in beta) that supports this functionality in the Power Query engine has some useful functionality that isn’t so obvious. If you look at the built-in documentation […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/3vOS22DjFjA/. The author is Chris WebbWe’re happy to announce our September 2019 update of Power BI Report Server! This release is packed with tons of reporting features, including visual level filters for slicers, Icon sets, grouping for visuals, new default themes, and more! In this release, you will also see the new updated design, the new filtering experience, and more […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-september-2019-feature-summary/. The author isI was delivering Power BI training in Melbourne last week and one of my students asked if it was possible to show on a report if any filters have been applied. It is a very … Is my Power BI Report Filtered? Read More This post first appeared at https://exceleratorbi.com.au/is-my-power-bi-report-filtered/. The author is Matt AllingtonRead More
This post first appeared at https://exceleratorbi.com.au/is-my-power-bi-report-filtered/. The author is Matt AllingtonWANTED: Power BI Consultants for Our Team. AND People to Push Power BI on (Internet) Street Corners. Still Growing the Consulting Team! We post these reminders periodically because, well, Power BI is blowing up and so are we (in the… This post first appeared at https://powerpivotpro.com/2019/09/now-hiring-power-bi-consultants-and-evangelists/. The author is Rob CollieRead More
This post first appeared at https://powerpivotpro.com/2019/09/now-hiring-power-bi-consultants-and-evangelists/. The author is Rob CollieI am going to publish a new series soon. The first post will be about Pie Charts. I cannot share more at this stage, but I would really appreciate your help in answering this survey and sharing it with your colleagues and report consumers. The results will be published soon… This post first appeared at https://datachant.com/2019/09/25/pie-charts/. […]
This post first appeared at https://datachant.com/2019/09/25/pie-charts/. The author is Gil RavivWe’re thrilled to introduce template apps update capability! From now on, after downloading and connecting a template app from AppSource every Power BI Pro or Premium user can update the app while preserving the connection configuration. This post first appeared at https://powerbi.microsoft.com/en-us/blog/template-apps-update-preview-is-now-available/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/template-apps-update-preview-is-now-available/. The author isFor our Back to School contest this year, we had so many amazing entries, showcasing creativity, design expertise, advanced Power BI skills, and of course a genuine love for education! With the help of both teachers and several members of the Power BI Product Team, have narrowed down the winners! This post first appeared at https://powerbi.microsoft.com/en-us/blog/congratulations-to-the-winners-of-the-back-to-school-contest/. […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/congratulations-to-the-winners-of-the-back-to-school-contest/. The author isJust a quick post to let you know that an interview I recorded for the BIFocal Show podcast at the Microsoft Business Applications Summit in Atlanta a few months ago is now available for your listening pleasure: Episode 117 – Interview with Chris Webb This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/2zbI3HgwUEs/. The author is Chris WebbRead More
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/2zbI3HgwUEs/. The author is Chris WebbWelcome back to another “New Feature Friday” for Paginated Reports in the Power BI service. We’re pleased to announce three new features rolling out around paginated reports. This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-reports-in-power-bi-september-2019-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/paginated-reports-in-power-bi-september-2019-feature-summary/. The author isOn 2 October I will be hosting a free webinar called “Introduction to DAX for Power BI”. I have trained literally thousands of people on the DAX language through my books, online training and live … Free Webinar: Introduction to DAX for Power BI Read More This post first appeared at https://exceleratorbi.com.au/free-webinar-introduction-to-dax-for-power-bi/. The author is Matt AllingtonRead […]
This post first appeared at https://exceleratorbi.com.au/free-webinar-introduction-to-dax-for-power-bi/. The author is Matt AllingtonThis is What I Want (What I Really Really Want): Zeroes to Rank Poorly. Divide by Zero Errors to Display “N/A.” And “N/A” to NOT participate in my ranking. RANKX: the Mother of Many Blog Posts Ya know, we could… This post first appeared at https://powerpivotpro.com/2019/09/a-brief-treatment-of-divide-rankx-and-n-a/. The author is Rob CollieRead More
This post first appeared at https://powerpivotpro.com/2019/09/a-brief-treatment-of-divide-rankx-and-n-a/. The author is Rob CollieSeptember release of Gateway This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-september-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-september-2019-update-is-now-available/. The author isIn my last post I showed lots of examples of how Power BI’s new custom format string feature can be used to format numbers. This post, looking at dates and times, will be a bit different for two reasons: there are a lot more useful examples of custom date and time formats built into Power […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/p7MlFytsWk8/. The author is Chris Webb