In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
You probably know that dimensional modelling and building a star schema are very important in Power BI. In a star schema you’ll have at least one fact table, and in your fact table you’ll have two main types of column: dimension keys, which link the fact table to dimension tables, and measures, which store the […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/fBckKEG4Gf4/. The author is Chris WebbWe’ve added a new tenant setting for Power BI admins to choose if users can create classic workspaces. This helps organizations control workspace creation more effectively and prevent unwanted workspaces from appearing in Power BI when Office 365 groups are created. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-you-can-now-block-classic-workspace-creation/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-you-can-now-block-classic-workspace-creation/. The author isPower BI Dataflows now support multiple independent ADLSGen2 storage accounts, configurable by workspace admins. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-multiple-data-lakes-support/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-multiple-data-lakes-support/. The author isThis article is a follow on from last week. I recommend you go back and read the article first if you missed it, but in summary, I want to write a measure (not a calculated column) that will return the median sales of products while excluding the products with blanks (no […]Read More » This post […]
This post first appeared at https://exceleratorbi.com.au/part-2-filtering-out-blanks-in-a-medianx-measure-using-dax-studio/. The author is Matt AllingtonExciting news: We are starting our first cross-community ‘Can You Solve These?’ challenge. This post first appeared at https://powerbi.microsoft.com/en-us/blog/august-2020-community-challenge-can-you-solve-these/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/august-2020-community-challenge-can-you-solve-these/. The author isI don’t generally blog about data visualisation in Power BI because it’s not my strong point, and I don’t blog about maps and geospatial analysis because I know even less about that subject and there are people like David Eldersveld who cover it so well. I do like playing around with maps though and recently […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/CLC8VnMNf8U/. The author is Chris WebbFollow @gilra Follow @datachant I am happy to share with you the news. I have recently been re-awarded as a Microsoft MVP in the Data Platform category for my Power BI and Power Query work in this blog and in the community. This is the fourth time I receive this award and I thank you […]
This post first appeared at https://datachant.com/2020/07/30/microsoft-mvp-award-4/. The author is Gil RavivFollow @gilra Follow @datachant In one of my last tutorials here, we learned how to apply time-intelligence in DAX to analyze the COVID-19 data that is provided by Johns Hopkins University. The focus so far was to provide correct calculations on a daily level or to smooth them using running averages here. This post first […]
This post first appeared at https://datachant.com/2020/07/30/weekly-based-time-intelligence-in-power-bi/. The author is Gil RavivCome to this session to learn about the options that you have for your end-users and what way you can take to have the most cost-effective Power BI implementation. This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-thursday-july-30-2020-at-1100-am-1200-noon-pdt-with-reza-rad/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-thursday-july-30-2020-at-1100-am-1200-noon-pdt-with-reza-rad/. The author isI was going to title this blog “MEDIANX and the X Functions”, but that sounded too much like a 2030s band, so I opted for MEDIANX returns blank in DAX. But the article does indeed cover more than just MEDIANX and the blank “problem”. But first some background. I helped […]Read More » This post […]
This post first appeared at https://exceleratorbi.com.au/medianx-returns-blank-in-dax-part-1/. The author is Matt AllingtonThe Power Query OData.Feed function has an option called IncludeAnnotations that allows you to return annotation values from an OData data source. It’s not obvious how to use it though – even if you use this option when connecting, you won’t see the annotation values by default because they are returned as metadata. Here’s an […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/iHPHJUI7akU/. The author is Chris WebbI’m sure many of you will already know that today is Power BI’s 5th birthday. It has been another great year of development by the Power BI team at Microsoft and the product has literally become so compelling that virtually every organisation should be considering deploying this tool. I cite […]Read More » This post […]
This post first appeared at https://exceleratorbi.com.au/power-bi-birthday-number-5/. The author is Matt AllingtonIt’s time to recap all the features and announcements we made for the Power BI service and mobile for the months of May and June. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-may-and-june-2020-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-may-and-june-2020-feature-summary/. The author isJuly 2020 release of gateways This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-july-2020-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-july-2020-update-is-now-available/. The author isThe July 2020 version of Power BI Desktop released a new feature called the External Tools toolbar. This was announced back in May during the Microsoft Business Applications Summit, and I have been waiting eagerly for it to be released ever since. In this short article today I am going […]Read More » This post […]
This post first appeared at https://exceleratorbi.com.au/external-tools-in-power-bi-desktop/. The author is Matt AllingtonJoin us to walk through the latest tips and tricks when working with XMLA Endpoints in Power BI. This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-tuesday-july-21-2020-at-1100-am-1200-noon-pdt-with-gaston-cruz/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/join-us-tuesday-july-21-2020-at-1100-am-1200-noon-pdt-with-gaston-cruz/. The author isWe’re thrilled to announce the release of Power BI component for React.js. React.js is a popular open-source JavaScript library, and many of you asked for an easier integration between Power BI and React web applications. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-react-power-bi/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-react-power-bi/. The author isHere’s something that will excite all you M nerds out there! Did you know you can make tooltips appear when you hover over column headers in a table in the Power Query Editor in either Power BI Desktop or Excel? It’s all done with M metadata, and here’s an example query: This post first appeared […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/SOQRTGz7Jv4/. The author is Chris WebbIn the last tutorials of the COVID-19 dashboard series, you learned how to build your own COVID-19 dashboard from CSV files that were provided by Johns Hopkins University. In today’s tutorial, we will import one of the WHO situation reports and learn how to apply Power Query PDF connector. Ready to start? This post first […]
This post first appeared at https://datachant.com/2020/07/16/import-who-covid-19-data-from-pdf/. The author is Gil RavivJoin us to thank the Power BI Community for 5 Years of contributions and helping others. Get a sneak peek of the event, and to find out more on our blog. This post first appeared at https://powerbi.microsoft.com/en-us/blog/thank-you-for-5-years/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/thank-you-for-5-years/. The author is