Category: Power Query

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…

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…

BI-NSIGHT – Power BI (Premium, May Desktop Update, New Pricing 01 Jun 2017, Pride 2017, Azure Consumption Insights Content Pack)

I always anticipate that the start of each month will be busy with the updates to Power BI, but this month is an exception with not only the release of the May Power BI Desktop Update, but also a new pricing and capacity model with regards to Power BI Premium. So let’s get into it shall we. Power BI –…

BI-NSIGHT – Power BI (Community Blog Highlights – Power BI Germany – Latest Updates for Power BI Desktop – How Microsoft uses Power BI to run its Cloud Business – Connecting Datasets to Power BI Service) – SQL Saturday Brisbane (I’m presenting) – SQL Server (SQL Server 2017 – DAX Editor for SSDT – New Get Data Experience for SSDT)

I thought that this might be a quieter week, but once again there are a whole host of updates from Power BI updates, to SQL Server 2017 announcements. Quite a bit to read through so I hope you enjoy it. Power BI – Community Blog Highlights I actively participate in the Power BI Community, as well as when I feel…

BI-NSIGHT – Power BI (Service March Update – New Navigation Experience, Desktop Terms & Definitions – Whitepapers) – BI Survey (BARC BI Survey 2017) – Excel – (Get & Transform Updates for April 2017)

There has been a variety of updates and blog posts in the past week, so here are my BI updates. Power BI – Service March Update There were quite a few service updates for March within the Power BI Service. The first was the granular controls which was a very welcome feature. And I know that something that a lot…

BI-NSIGHT – Power BI (Desktop Update April – Quick Measures Preview – Mobile Apps Summary – Video Gallery & Ask a Partner Anything – View Related Content Pane – Sneak Peak add new Columns from Example – Tracking Adoption via Power BI Audit Logs)

There has been a whole host of updates and interesting things in Business Intelligence in the past weeks, so please find below the updates. Power BI – Desktop Update April This month’s Power BI Desktop update for April has a whole host of great updates and new features this month, which I will highlight what I think is most relevant…