BI-RoundUp – Power BI (Happy 2nd Birthday) – Azure Analysis Services (Web Designer)

Here is the weekly BI-RoundUp with the latest news.

Power BI – Happy 2nd Birthday

I cannot believe that it has already been 2 years since Power BI was launched. It is amazing to see how many new features and capabilities that keeps on happening.

In the past year they have released 153 new features and updates. That is amazing and I am so excited to see what the next year will bring.

You can read their blog post, as well as watch the video here: Happy Second Birthday to Power BI


Power BI – Using the Custom Data Connector to Connect to Strava

I was very excited when the news came out that there now was a Data Connector SDK Developer Preview, and I started letting customers and people know that there now is the new functionality to literally get data from almost any source.

Then I saw a blog post by Kaper De Jonge where he was trying to get the Data Connector working to connect to Strava data (Building the Power BI Strava data connector). This got me even more excited, as enjoying my sporting activities it would be great to use Power BI to see how I have been doing, as well as if I am improving or getting slower with age!

I followed his simple steps and in almost no time (well actually a bit of time because I had a whole host of new things to figure out) I had my own Strava report.


Power BI – DAX Measures for Excel based “ % of Column Total “ or “ % of Row Total ”

Where I am currently consulting there was a requirement to create a measure like you can in the Excel pivot tables for the % of Column Total or the % of Row Total.

One of the things that you can currently do in Power BI, which I only learnt as part of this requirement is that you can use % of Column Total, or % of Row Total when using a table, as seen below.

But the thing is that as soon as you put that into a visual the only option that you have is the Percent of grand total.

So below are the two measures that I created so that I could then successfully have a % of Column Total (Percent of column total) or % of Row Total (Percent of row total)


Power BI – Using Reports Usage Metrics to create Custom Reports & Leverage them for other App Workspaces

In this blog post below I am going to show you how I created my own Custom Usage Metrics Report.

NOTE: This has been done using my Report Metrics and not the Dashboard Metrics.

NOTE II: I am going to refer to the Reports Usage Metrics as RUM (It has a nice ring to it)

And then how I changed the Connection details, so that I could re-use the same Custom Usage Metrics report in all my different App Workspaces.


Power BI – Connecting to OneDrive for Business from Power BI Desktop & Refresh from Power BI Service without the need for the On-Premise Gateway

In this blog post I am going to show how to connect to a file on OneDrive for Business in Power BI Desktop, then upload to the Power BI Service and configure it to refresh from within the Power BI Service. And as in the title you will NOT need the On-Premise Gateway to enable your data to be refreshed.


  • I have a file that I have already uploaded to my OneDrive for Business called indicator_hours per week.xlsx
  • And this is the file that I am going to use in this example.


BI-RoundUp – Power BI (Data Insights Summit Analytics Challenge Winners – Non-Profits Program)

It has been a quieter week, so here is the BI-RoundUp

Power BI – Data Insights Summit Analytics Challenge Winners

A big congratulations to the people that won the Analytics challenge for the categories “Complex Data Preparation”, “Advanced Analytics” and “Just for Fun”

It is great to see so many people who submitted their entries. Hopefully next year I can dedicate some time to entering the competition.

You can find the blog post here: Congratulations to the Data Insights Summit Analytics Challenge winners!

Power BI – Non-Profits Program

I was unaware that there is special pricing for Non-Profit organizations. This is great to see as very often these companies provide selfless work and really help out people and communities.

If you want to find out more details here is the link: Power BI – Non-Profit Organizations

Power BI – Overview Infographic

I like to keep up to date with what is going on with Power BI.

And with all the recent changes I have spent some time updating my Power BI Overview Infographic to better represent all the new changes.

You will see that I have changed the way that it looks and divided it into 3 sections based on how I typically use Power BI.

Starting with Power BI Desktop, then the Power BI Service and finally connecting to On-Premise data sources.

If you have any questions or anything is missing please let me know.

You can also find download copies of the images here: Power BI Overview Infographic


BI-RoundUp – Power BI (Interactive Custom R Visuals – Community Blog- Data Refresh APIs – Facebook Solution Template – Help Improve Power BI Desktop)

Here is the weekly Power BI Round Up, not too much going on which is a good thing after all the announcements from the Microsoft Data Insights Summit last week.

Power BI – Interactive Custom R Visuals

With R being so popular, as well as it being announced at the recent Microsoft Data Insights Summit, the Power BI team has now enabled the capability to be able to create R Custom visuals that are fully interactive by using HTML as the visual.

They have already created 4 visuals that you can start using now.

You can find the exciting details here: Interactive R custom visuals support is here!