Select Page

In The Trenches

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

I was doing some online shopping last week and saw a price slicer with a histogram to show the concentration of price points.  I thought it was pretty cool, so decided to see if I could build this in Power BI.  I came up with a solution that works, and in this article I show […]

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

Read More

Read More

This blog talks about the recently enabled feature “Multiple data source definitions to the same data source” This post first appeared at https://powerbi.microsoft.com/en-us/blog/multiple-data-source-definitions-on-the-on-premises-data-gateway-for-the-same-data-source/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/multiple-data-source-definitions-on-the-on-premises-data-gateway-for-the-same-data-source/. The author is 

Read More

Read More

Whoa! I can’t believe it is summer and almost 4th of July! It’s been WAY too long since I’ve blogged – I’ve just been SUPER busy here at P3! But I can’t let my Pug Meme readers down It seems… This post first appeared at https://powerpivotpro.com/2019/07/power-query-fail/. The author is Krissy DyessRead More

This post first appeared at https://powerpivotpro.com/2019/07/power-query-fail/. The author is Krissy Dyess

Read More

Read More

With Power BI aggregations, organizations can perform petabyte-scale analytics with instant response times, exploring and analyzing trillions of rows of data and interactively extracting insights on the fly. Aggregations can dramatically reduce the cost of unlocking large datasets for decision making. This post first appeared at https://powerbi.microsoft.com/en-us/blog/unlock-petabyte-scale-data-sets-in-power-bi-with-aggregations-upcoming-general-availability/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/unlock-petabyte-scale-data-sets-in-power-bi-with-aggregations-upcoming-general-availability/. The author is 

Read More

Read More

To kick off July, we’ve dropped the latest update to Power BI Report Builder in the download center.  It includes, for the first time, the ability to browse your Power BI workspaces and connect to your Power BI datasets, whether or not they are backed by premium capacity.  This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-support-for-non-premium-power-bi-datasets-in-power-bi-paginated-report-builder/. The author […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-support-for-non-premium-power-bi-datasets-in-power-bi-paginated-report-builder/. The author is 

Read More

Read More

A quick Q&A-related tip. If you create a report in Power BI Desktop and use a Power BI service live connection: …and then you put a Q&A button on the report, clicking on the button gives the following error message: This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/_2C3L71ph-k/. The author is Chris WebbRead More

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

Read More

Read More

As a Power BI service admin, do you frequently need to list all workspaces in your tenant, and all reports, dashboards, and datasets in those workspaces as well? If the answer is yes, you probably had to build your solution such that in a first call, all workspaces had to be retrieved by using the […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/avoiding-workspace-loops-by-expanding-navigation-properties-in-the-getgroupsasadmin-api/. The author is 

Read More

Read More

We’re two weeks post-GA of Paginated Reports in Power BI, and we wanted let you know about several updates we’ve made since then This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-paginated-reports-june-2019-feature-update-summary/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-paginated-reports-june-2019-feature-update-summary/. The author is 

Read More

Read More

An interesting – if obscure – fact I learned recently is that a small number of DAX functions such as Median() do not work on tables with more than 2 billion rows in Analysis Services Tabular, Azure AS and Power BI. It’s quite easy to reproduce in Power BI. The following M expression returns a […]

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

Read More

Read More

There was a new feature released in the June 2019 version of Power BI Desktop that I really like and I think warrants some explanation and review.  The new feature allows you to pre-filter a slicer so that it only contains a subset of values that would otherwise appear in that slicer. Filters on Non-Slicer […]

This post first appeared at https://exceleratorbi.com.au/filters-on-power-bi-slicers-wait-what/. The author is Matt Allington

Read More

Read More

dataflow templates This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-dataflow-templates-a-quick-and-efficient-way-to-build-your-sales-leaderboard-and-get-visibility-over-your-sales-pipeline/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-dataflow-templates-a-quick-and-efficient-way-to-build-your-sales-leaderboard-and-get-visibility-over-your-sales-pipeline/. The author is 

Read More

Read More

When I was a Sophomore in college, I got a job doing tape backups at a food ingredients company. The developers there maintained a stack of paginated reports for the managers in the corner offices. At the time, I thought it… This post first appeared at https://powerpivotpro.com/2019/06/from-english-major-to-data-analyst/. The author is Fred KaffenbergerRead More

This post first appeared at https://powerpivotpro.com/2019/06/from-english-major-to-data-analyst/. The author is Fred Kaffenberger

Read More

Read More

We’re excited to announce we’ve started to roll-out the Viewer role for the new workspace experience, perfect for users who need to view content within workspaces without the ability to modify it. Viewer role enforces RLS even for users browsing the workspace, its a replacement for ‘read-only’ classic workspaces. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-new-viewer-role-for-power-bi-workspaces/. The author […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-new-viewer-role-for-power-bi-workspaces/. The author is 

Read More

Read More

We are excited to announce new improvements to Power BI dataflows releasing this month including an enhanced compute engine to drastically improve data refresh times and a new set of dataflow templates to help you easily connect to common data sources mapped against the common data model. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-june-2019-feature-summary/. The author is Read […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-june-2019-feature-summary/. The author is 

Read More

Read More

The Microsoft Business Application Summit is behind us but that doesn’t mean there’s a lot of content we can share with the community. We recorded almost every session on site, and we made them available in our community. This post first appeared at https://powerbi.microsoft.com/en-us/blog/mbas-2019-on-demand-featured-sessions-power-bi-roadmap-and-vision/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/mbas-2019-on-demand-featured-sessions-power-bi-roadmap-and-vision/. The author is 

Read More

Read More

While writing my Microsoft Business Applications Summit session on Power Query-related reasons for Power BI dataset refresh failures (which you can watch online here for free, along with all the other sessions), I remembered something important that I have been meaning to blog about for a while. It’s an excellent article by Ehren von Lehe […]

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

Read More

Read More

Three Goals In today’s article, I’m aiming to achieve three overlapping goals: Provide an intro to the concept of Value Above Replacement (aka VAR) – if you’re unfamiliar with this concept, I think you will find it stimulating.  I’m not… This post first appeared at https://powerpivotpro.com/2019/06/power-bi-brain-candy-value-above-replacement/. The author is Rob CollieRead More

This post first appeared at https://powerpivotpro.com/2019/06/power-bi-brain-candy-value-above-replacement/. The author is Rob Collie

Read More

Read More

Bring Your Own Key (BYOK) preview available This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-bring-your-own-key-byok-preview-for-power-bi-premium/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-bring-your-own-key-byok-preview-for-power-bi-premium/. The author is 

Read More

Read More

Level: Intermediate There was an announcement made a few weeks ago by Microsoft that nearly slipped under my radar.  I don’t always read the more technical announcements because I don’t have a highly technical background.  Luckily I read this particular announcement as it contained a nugget of gold that is very useful for anyone with […]

This post first appeared at https://exceleratorbi.com.au/power-bi-apis-for-non-programmers/. The author is Matt Allington

Read More

Read More

This post is to make you aware that there are some serious downsides when you choose to create reports in the Power BI Service rather than Power BI Desktop. The Short Version of the StoryI always recommend to Power BI authors that report creation & editing should happen in Power BI Desktop and to just […]

This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/spVePJJ4GUc/why-you-should-create-reports-in-power-bi-desktop-instead-of-power-bi-service. The author is Melissa Coates

Read More

Read More

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

Blogroll