In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
DMVs (Dynamic Management Views) are, as the Analysis Services documentation states, “queries that return information about model objects, server operations, and server health”. They’re also available in Azure Analysis Service, Power BI and Power Pivot and are useful for a variety of reasons, for example for generating documentation. Several as-yet undocumented DMVs have appeared in […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/R-2ttyAvOpQ/. The author is Chris WebbWelcome back! Today we are going back to RANKX-apalooza! We are going to add two approaches that will allow you to apply RANKX across multiple columns. I went back and recreated the examples from the original post using the AdventureWorks… This post first appeared at https://powerpivotpro.com/2019/05/rankx-apalooza-part-2-within-and-across-groups-with-filters-etcand-using-multiple-columns/. The author is Jason BaldessariRead More
This post first appeared at https://powerpivotpro.com/2019/05/rankx-apalooza-part-2-within-and-across-groups-with-filters-etcand-using-multiple-columns/. The author is Jason BaldessariBack in September of last year, we announced dashboard commenting in Power BI. Since then, we’ve seen thousands of you leverage this feature to collaborate with colleagues and start discussions within your organization. Today, I’m excited to announce that we are bringing the same commenting capability to Power BI reports! With report commenting, you can […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-report-commenting-for-power-bi-service-and-mobile/. The author isI had an interesting question from one of my book readers and I thought it would make a good blog article. There are many ways of solving this problem, and I blogged about solving a similar problem Fill Table with Last Survey Result using DAX here. The solution I am providing in this blog post is using […]
This post first appeared at https://exceleratorbi.com.au/expanding-rows-using-power-query/. The author is Matt AllingtonFor the fifth week in a row, we’re pleased to announce two new features on “New Feature Friday” for Paginated Reports in Power BI. We’ve added support for two new data sources, Oracle and Teradata, and also added the ability to schedule your e-mail subscriptions on an hourly basis. Oracle and Teradata Now Supported We […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/oracle-and-teradata-data-source-support-and-hourly-e-mail-subscriptions-for-paginated-reports-now-available/. The author isWay back in Oct-2016, Microsoft released a feature in Power BI Desktop that makes the process of creating groups much easier for the average user. I was reminded of this feature by an article by Reid Havens a couple of months ago. I blogged about various other ways of doing this, including banded columns using DAX […]
This post first appeared at https://exceleratorbi.com.au/grouping-in-power-bi-desktop-without-using-dax/. The author is Matt AllingtonI’m one of those people who can’t resist peeking behind the scenes, and so when the Key Influencers visual appeared in Power BI I couldn’t help wondering how it worked its machine learning magic. Using DAX Studio to look at the DAX queries generated by the visual proved to be very revealing: it turns out […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/WJWNS7zycLw/. The author is Chris WebbThe Elizabeth Glaser Pediatric AIDS Foundation (EGPAF) seeks to end global pediatric HIV/AIDS through prevention and treatment programs, research, and advocacy in 19 countries worldwide. The number of new HIV infections among children has declined more than 90% in the U.S. and 70% worldwide. Over its 30-year existence, EGPAF has played a major role in these […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/how-power-bi-enables-remote-communities-in-africa-to-track-aids/. The author isGet a similar report on your preferred Facebook page here. The post Game of Thrones on Facebook with Power BI appeared first on DataChant. This post first appeared at https://datachant.com/2019/04/27/game-of-thrones-on-facebook-with-power-bi/. The author is Gil RavivRead More
This post first appeared at https://datachant.com/2019/04/27/game-of-thrones-on-facebook-with-power-bi/. The author is Gil RavivBy using the Power BI management cmdlets, you can automate typical user and administration tasks with significantly less effort and complexity than with direct Power BI REST API calls. To illustrate this point, let’s take a look at Sirui’s original copyWorkspace.ps1 script, published in 2017 for the “Duplicate workspaces using the Power BI REST APIs: […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/duplicating-workspaces-by-using-power-bi-cmdlets/. The author isIn a comment to the recent announcement of Workspace Management in the Admin Portal, JohnR asked for an option to export the list of workspaces with the fields provided. This would help facilitate admin work across thousands of workspaces. A great suggestion! Perhaps you wanted to export the list of workspaces placed on Premium capacities, […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/exporting-the-workspaces-list-from-the-admin-portal/. The author isAs discussed in our blog post announcing support for Azure Analysis Services, we promised to unlock the critical capability of allowing Paginated Reports to be built on the same enterprise semantic model as your interactive reports. This week for “New Feature Friday”, we’re pleased to announce that Power BI Datasets in premium workspaces are now […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dataset-data-source-support-for-paginated-reports-is-now-available/. The author isOne of the most popular blog posts I have written in recent years is this post on how the RelativePath and Query options for the Web.Contents() M function can be used to allow datasets that use web services as data sources to refresh successfully in the Power BI Service. It’s very frustrating when you write […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/whwQHYMvRvM/. The author is Chris WebbAs organizations grow their Power BI deployments and foster a data culture, users will have an ever-increasing amount of data available to them. This wealth of information makes it critical to have tools to find and organize relevant content. Last September, we took the first step in improving our overall navigation experience by introducing a […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-home-general-availability-ga-roadmap/. The author isWe are happy to announce that we have just released the April update for the On-premises data gateway (version 3000.3.138). Here are some of the things that we would like to highlight with this month’s release: Availability of the following connectors via the On-premises data gateway Oracle Essbase connector PDF support in File connectors. The […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-april-2019-update-is-now-available/. The author isIn Power BI, today, a new data source (cloud or on-prem) is created only if a successful connection can be made to the data source with the credentials provided. If it fails, the data source creation fails with an error message as shown below: The same applies to editing credentials for existing data sources. If […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/skip-test-connection-for-on-premises-and-cloud-data-sources/. The author isIt seems like every month there are so many new features added in Power BI. The Power Platform is continuously building steam. There are releases, classes, tutorials, new features, blog posts, YouTube video’s, LinkedIn articles. Everywhere you look there’s more… This post first appeared at https://powerpivotpro.com/2019/04/chasing-the-data-revolution-how-can-we-help/. The author is Jason BaldessariRead More
This post first appeared at https://powerpivotpro.com/2019/04/chasing-the-data-revolution-how-can-we-help/. The author is Jason BaldessariWe launched the public preview of the Data Gateway administration feature on the Power platform admin center in January. This feature provides tenant admins with visibility into all On-premises data gateways within their organization and also management capabilities. We are now excited to add 2 new capabilities to this feature: Visibility into On-premises data gateway […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/enhancements-to-on-premises-data-gateway-management-in-the-power-platform-admin-center/. The author isToday we are pleased to announce Query Caching for Power BI Premium, which speeds up content loading by caching previously-used query results. The setting is applied at the dataset level so any reports using this dataset can benefit from the cache. This feature is not applicable to LiveConnect datasets leveraging Azure Analysis Services or SQL […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-query-caching-in-power-bi-premium/. The author isI have written a few articles in the past that toy with the ideas of changing visibility and text colour based on selection. I started to wonder if it was possible to make a visual appear (or not) based on a selection from the user. There is no out of the box way to do […]
This post first appeared at https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/. The author is Matt Allington