Select Page

In The Trenches

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

We saved the best for last. The final stretch of 2018 was incredible for the Power BI team. We announced some of our biggest previews, rolled out new features, and improved existing functionality across service and mobile based on your feedback. Before we ring in the new year, here’s a quick recap, in case you […]

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

Read More

Read More

Every year, on the anniversary of the first-ever post on this blog, I write a post summarising my thoughts on what’s happening in the world of Microsoft BI and what I’m up to professionally. This year, rather than go on about how Power BI is taking over the world (which we all know already), I […]

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

Read More

Read More

I have known for a long time that data privacy checks can have an impact on the performance of data refresh in Power BI and Excel, but on a recent performance tuning engagement I had the chance to observe just how much of a difference changing these settings can make. Unfortunately I can’t share the […]

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

Read More

Read More

We are excited to announce that we have just released the December update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release: – Enhancements in SAP BW connector – The On-premises data gateway now includes the December version of the mashup engine The […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-december-2018-update-is-now-available/. The author is 

Read More

Read More

It’s The Time Of Year For Family Hello P3 Nation. All of us here at PowerPivotPro want to wish you a Happy Holidays! We also want to let you know that we’re taking a break for a few weeks for… This post first appeared at https://powerpivotpro.com/2018/12/happy-holidays-2/. The author is Jason BaldessariRead More

This post first appeared at https://powerpivotpro.com/2018/12/happy-holidays-2/. The author is Jason Baldessari

Read More

Read More

When an end user sees a strange value in a Power BI report, their first reaction is usually to want to see the detail-level data from the underlying table. Power BI’s drillthrough feature is a great way of  letting them do this, but it only returns meaningful results if you use it on measures that […]

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

Read More

Read More

Microsoft offers partners to introduce their consulting services through AppSource (For exmaple, you can find here the services which are related to Power BI in US). I am working on a Power BI refreshable version of this report. Here is the first draft. Contact me at gil.raviv@avanade.com if you want to work with the best This post […]

This post first appeared at https://datachant.com/2018/12/20/power-bi-consulting-firms-and-their-services-as-seen-on-appsource/. The author is Gil Raviv

Read More

Read More

There are quite a few common business scenarios where you get data in the form of a file on a regular basis from some source system and you need to process these files into your Power BI reports.  There are 3 common patterns that come to mind. Each day/month/year you get a new file containing […]

This post first appeared at https://exceleratorbi.com.au/load-the-latest-version-of-a-file-in-power-query/. The author is Matt Allington

Read More

Read More

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

Hansen BI brings you the latest insights from the most popular Microsoft Business Intelligence bloggers around the world

Blogroll