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 AllingtonOne 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 WebbFollow @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 RavivHave 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 WindenbergerSeriously, 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 AllingtonAs 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 isPower 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 isA 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 WebbWe’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 isWell 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 AllingtonFollow @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 RavivWe 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 isAs 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 isLearn 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 isLearn 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 isWe’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 isMulti 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 isPower 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 isA 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 WebbTabular 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