Select Page

In The Trenches

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

Not long after I started my career in FP&A, I became interested in KPI development. It’s a natural progression I think: you get the budgeting, forecasting, and reporting under control, and then you begin to dig a little deeper. When… This post first appeared at https://powerpivotpro.com/2018/09/using-dax-to-create-a-kpi/. The author is Matthew MowreyRead More

Read More

Level: Beginners Power Query is a product that allows business users to extract data from any source, cleanse and transform that data, and then load the modified data to a new location, typically into an Excel spreadsheet or a Power BI data model.  Power Query is very easy to learn, and most tasks can be […]

Read More

In this new series, we will answer common questions that many organizations ask, as they start deploying Power BI in massive scale, and consider the adoption of the Custom Visuals: What are the risks of using Custom Visuals? This post first appeared at https://datachant.com/2018/08/31/governing-custom-visuals-power-bi-1/. The author is Gil RavivRead More

Read More

It’s another terminology post! Earlier this week I was having a delightful lunch with Angela Henry, Kevin Feasel, Javier Guillen, and Jason Thomas. We were chatting about various new things. Partway thru our conversation Jason stops me because he thought I was talking about Power BI Dataflows when I was really talking about Azure Data […]

Read More

Last year I blogged about how to use the Text.BetweenDelimiters() function to extract all the links from the href attributes in the source of a web page. The code was reasonably simple but there’s now an even easier way to solve the same problem using the new Html.Table() function. This function doesn’t seem to be […]

Read More

I wanted to share my experience more as a thank you than as a technique to share. About a year ago, I moved into a new role in health care as a clinical performance analyst.  My previous experience easily qualified… This post first appeared at https://powerpivotpro.com/2018/08/thank-you-p3/. The author is Hanna VesseyRead More

Read More

Power BI is about making informed, data driven decisions and we believe this should include how you maintain your assets in Power BI. Now we are very pleased to announce the launch of the Premium… This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-monitoring-capabilities-for-power-bi-premium-capacities/. 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-august-update-2018/. The author is Read More

Read More

Recently I was teaching a private course on Power BI to one of our clients. We were learning about the ALL() function and how to use it to get % of total calculations. After demonstrating how to get an individual… This post first appeared at https://powerpivotpro.com/2018/08/sort-by-columns-all/. The author is Ryan BergstromRead More

Read More

Evaluation contexts in Power BI DAX I was in Seattle, USA in the last week of July participating in the Microsoft Business Applications Summit. I love attending conferences like this and it was a privilege to present on a few topics over 3 days.  One of the presentations I gave was on the topic “Evaluation contexts […]

Read More

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

Read More

Since my post last week on using the Google Image Charts API to create sparklines and small multiples in Power BI has proved very popular, I thought I would do a follow-up showing how to use the Azure Maps API to create map small multiples. Here’s an example of what’s possible, a table from a […]

Read More

Way back in 2014 I decided to check out what Google Trends had to say about Power Pivot and Power Query global Interest. In case you don’t know, Google Trends will show you the relative frequency of people searching for certain words – it is a good indicator of interest in a topic.  I published […]

Read More

Multi-national ISVs and organizations building applications and using Power BI Embedded in Azure to embed analytics into their apps, can now deploy their data in multiple regions across the world to comply to different data residency requirements. This post first appeared at https://powerbi.microsoft.com/en-us/blog/multi-geo-support-preview-for-power-bi-embedded-in-azure/. The author is Read More

Read More

Figure 1 View outside of my home office window May 2nd, 2018 Fairbanks, Alaska. Intro Hello, my name is Matthew Brice and I am guest broadcasting from my home office (via tape delay) in Fairbanks, Alaska.  PPPro put out a… This post first appeared at https://powerpivotpro.com/2018/08/dax-back-to-the-basics/. The author is Matthew BriceRead More

Read More

Level: Intermediate Matt: This is the second article in a series from Parker Stevens where he talks about using R with Power BI.  If you missed the first article, you can read it here. Parker: Power BI comes with a ton of built-in features but eventually you might find yourself wanting more. I sometimes see […]

Read More

For those of you who may have missed the announcement last week, the Power BI team has made the ‘Ask A Question’ feature inside the Power BI Desktop globally available. For those of you who have yet to try this out, this new capability allows you directly place the ask a question box within your […]

Read More

With the release of Python inside Power BI, we, the Power BI team have come together to show you some of our favorite python packages. Python is a great addition to the Power BI family by providing you the ability to perform quick data transformation or plot cool data visualizations. You can even expand your […]

Read More

Power BI now offers enhanced filtering capabilities that let you define more complex report-level filters as query string parameters directly in the report URL, as the following screenshot… This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-url-filter-improvements/. The author is Read More

Read More

I’ve just come across an interesting new project from Microsoft Research called Charticulator.  It’s described as a tool for the “Interactive Construction of Bespoke Chart Layouts”, and you can use it for creating some very nice data visualisations like this: So I had a play with it, was quite impressed, and then I watched the […]

Read More