BI-RoundUp – Power BI (Power BI World User Group Tour – On-Premise Gateway Update for July 2017 – Featured Data Stories for May and June – Certified Custom Visuals and why it Matters)
After last week there was not any updates worth blogging about, so here is this weeks updates.
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 %…
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…
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….
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…
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…
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…
Power BI Quick Tip – Using Parameters in Power Query Filters
I have been working lately quite a bit in Power Query and having to shape and re-create data based on the requirements. They had a requirement to make the data dynamic and immediately the Parameters in Power BI came to mind to create the solution. Now as we know using Parameters in Power BI has a lot of advantages. But one quick…