Select Page

In The Trenches

With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS

I see a lot of Power BI users asking for the ability to set a default slicer selection in their reports. Although this isn’t natively supported as of yet, we can imitate this functionality with a little bit of DAX!… This post first appeared at https://powerpivotpro.com/2018/12/setting-a-default-slicer-selection/. The author is Parker StevensRead More

This post first appeared at https://powerpivotpro.com/2018/12/setting-a-default-slicer-selection/. The author is Parker Stevens

Read More

Read More

This has been a great year for Power BI service admins. In July, we shipped APIs and PowerShell cmdlets for Power BI management, and recently we also released a preview version of a Workspaces page in the Power BI Admin Portal (see the screenshot below). This page lists all the workspaces in a tenant and […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/workspace-management-in-the-admin-portal/. The author is 

Read More

Read More

The order of the columns in a table in a Power BI dataset doesn’t matter all that much, especially because the Fields pane in Power BI Desktop ignores the original column order and lists the columns in a table in alphabetical order. However there are a few situations where it is important, for example when […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/ZFPyy3WppOg/. The author is Chris Webb

Read More

Read More

Recently I shared with you a survey here and asked you to estimate the impact of Power Query: How much time does Power Query save you in a year? How much money do you save for your organization? Can you estimate how many people worldwide use Power Query, and how many don’t use it, but can […]

This post first appeared at https://datachant.com/2018/12/17/the-impact-of-power-query-survey-results/. The author is Gil Raviv

Read More

Read More

The Power BI Premium Capacity Metrics (version 1.10) app makes navigating and viewing metrics at workspace level easier. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-premium-capacity-metrics-app-makes-navigating-and-viewing-metrics-at-workspace-level-easier/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-premium-capacity-metrics-app-makes-navigating-and-viewing-metrics-at-workspace-level-easier/. The author is 

Read More

Read More

Earlier this week I presented a sneak peek at my book at a PASS BI webinar. You can download the deck here, and watch this video if you missed it. During the session, I couldn’t answer all questions. Here are the questions and my answers. Feel free to comment below if you have more questions. […]

This post first appeared at https://datachant.com/2018/12/14/sneak-peek-at-the-book-a-pass-bi-webinar/. The author is Gil Raviv

Read More

Read More

I was chatting to a few of my Power BI buddies during the week about when we thought the December 2018 update would be released.  It seemed to me that under normal circumstances the new version is released on or about the first Monday (US time) on or after the 3rd or 4th day of […]

This post first appeared at https://exceleratorbi.com.au/power-bi-desktop-release-date-history-using-power-bi/. The author is Matt Allington

Read More

Read More

I’ve written in the past about using the CUBE functions in Excel. The general pattern of the examples I’ve used was pretty consistent: Creating a set of members of some sort, like products or customers using the CUBESET function Extracting… This post first appeared at https://powerpivotpro.com/2018/12/cube-functions-the-good-the-bad-and-how-to-make-them-great/. The author is Dany HoterRead More

This post first appeared at https://powerpivotpro.com/2018/12/cube-functions-the-good-the-bad-and-how-to-make-them-great/. The author is Dany Hoter

Read More

Read More

December is a huge month for us in terms of accessibility. With this release, the entire product supports screen readers, keyboard navigation and high contrast for both report consumption and report creation. We are also previewing one of the most asked for features related to Q&A, support for live connect! We also have lots of […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-december-2018-feature-summary/. The author is 

Read More

Read More

Recently I’ve been doing some more investigations into how data privacy settings work in Power BI. This is a subject I’ve blogged about in great detail already in a series of posts last year, but this functionality is so complex that there is always more to learn. I don’t have any profound new insights to […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/NBzRL6A9cRE/. The author is Chris Webb

Read More

Read More

We are very excited to announce the public preview of Power BI dataflows and Azure Data Lake Storage Gen2 Integration. Business analysts and BI professionals can now exchange data with data analysts, engineers, and scientists working with Azure data services through the Common Data Model and Azure Data Lake Storage Gen2 (Preview). This post first […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-and-azure-data-lake-storage-gen2-integration-preview/. The author is 

Read More

Read More

This blog post covers the latest updates for Power BI Developers community- Power BI Embedded and Custom Visuals. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-november-update-2018/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-developer-community-november-update-2018/. The author is 

Read More

Read More

Using Presentation mode in the Power BI app running on Surface Hub in your conference room and collaboration areas, better allows you to have meetings which focus on your data. Presenting, collaborating and having productive discussions with your colleagues and team members while using your data in your Power BI dashboards and reports has never […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/presentation-mode-in-power-bi-windows-app/. The author is 

Read More

Read More

Recently I used Azure Cloud Shell for the first time. This is a quick post to show how I referenced the file share in Azure Storage to communicate with Cloud Shell. What is Cloud Shell?Cloud Shell is a lightweight way to run scripts using either Bash or PowerShell. You can run scripts in a browser […]

This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/dUYFWZR-12E/how-to-reference-azure-storage-files-from-cloud-shell. The author is Melissa Coates

Read More

Read More

Connect with experts, collaborate with your community and maximize learning opportunities at Microsoft Business Applications Summit, returning June 10-11, 2019 in Atlanta, GA. Back for its second year, this is the premier place for power users, analysts and technical architects to get hands-on with the tools you use every day – and get a sneak […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-business-applications-summit-is-back-join-us-june-10-11-2019-in-atlanta/. The author is 

Read More

Read More

Join us for a Tour of an improved Power BI navigation experience makes it easy to monitor and analyze your key business metrics. This post first appeared at https://powerbi.microsoft.com/en-us/blog/webinar-12-11-introduction-to-the-power-bi-home-global-search-experience-with-nikhil-gaekwad/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/webinar-12-11-introduction-to-the-power-bi-home-global-search-experience-with-nikhil-gaekwad/. The author is 

Read More

Read More

Announcement January 1, we will be moving Power BI solution templates to open source. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-solution-templates-moving-to-open-source/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-solution-templates-moving-to-open-source/. The author is 

Read More

Read More

This is the third bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. Follow @gilra This post first appeared at https://datachant.com/2018/12/07/preserve-context-worksheets-bonus-exercise-chapter-5-powerquery-book/. The author is Gil RavivRead More

This post first appeared at https://datachant.com/2018/12/07/preserve-context-worksheets-bonus-exercise-chapter-5-powerquery-book/. The author is Gil Raviv

Read More

Read More

In a comment on my blog post about international date and number formats and changing data types with the “using locale” option in Power Query/Power BI, Jan Karel Pieterse asked if there was any way to get a list of the thousand and decimal separators used for number formatting by each language and region. Since […]

This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/OtayM1L7Jiw/. The author is Chris Webb

Read More

Read More

A common problem I see some people struggle with in Power BI is when a slicer contains a (Blank) record for some reason.  The cause of the problem is not obvious and hence it is not clear how to fix it.   This article describes what causes this to occur and also how to fix it […]

This post first appeared at https://exceleratorbi.com.au/rename-blank-in-a-slicer-in-power-bi/. The author is Matt Allington

Read More

Read More