BI-RoundUp – Power BI (Desktop Update for June, Service Updates for June, Dashboard Email Subscriptions) – Excel (Get & Transform Updates June 2017)
Here is my weekly BI-RoundUp with what has happened and what is new. Power BI – Desktop for June Finally the Power BI Desktop July update is here. So here are the details below of the new updates. Reporting The table and matrix visuals are now generally available. Not only that but they have also made some additional enhancements which…
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…
Updated Power BI Free vs Pro Infographic
With all the changes to Power BI, I have updated my original Power BI Infographic so that it reflects all the changes. As you can see below, there are still some features which you can only use as part of the Pro license. As always if you have got any comments, or if I have left something out, please…
BI-RoundUp – Power BI (June Desktop Update – Data Insights Summit Details – Power BI Embedded Pricing & Details – Power BI Premium Generally Available – Power BI Report Server Generally Available)
I was fairly certain that there were going to be a whole host of updates and additions to Power BI, and I can say that I am not disappointed. There is a whole host of information below, where I will endeavour to try and get it all to you, so this might be a bit long to read, but it…
Data Insights Summit Details – Day 1 Summary
With the Microsoft Data Insights Summit that is currently happening in Seattle the Power BI team has been really busy letting us know what features are coming and what to get excited about in the coming months, so below is a quick overview of what has been released after Day 1.
BI-RoundUp – Power BI (Service Update April & May – Personal Gateway Update – How to Purchase Power BI Premium – Managing Power BI Premium – Memory Consumption in Power BI File – Power BI – Exposing M Code)
It has been a busy week with the start of another month leading into June, so here are the updates. I am pretty confident that with the Microsoft Data Insights Summit happening Monday & Tuesday of next week that the new version of Power BI Desktop, as well as some new features will be revealed then. And I cannot wait,…
DAX – Getting the Previous Year to Date Value up to and including the Current Month Selected – Not the entire Previous Year
So for this example it is best explained with an image below, then some additional context afterwards If you look above we have got the [Sum of Sales] for Dec 2010-11 NOTE: This I selected in the Slicer on the right hand side. Then I have created a Year to Date (YTD) measure which is the running total for the Year…