Power BI – One Measure dynamically made up from multiple measures (To show Month Estimate for current Month)
Where I am consulting there was a requirement where for the current month they wanted to display the Current Month Estimate for the current month they were in, and to show the historical sales for all the previous months. This makes some sound business sense, since currently month would typically start off with a lower sales amount, which would increase…
BI-RoundUp – Power BI (Developer Update – Balanced Scorecard – Deep dive at Data & BI Summit Ireland – Difinity Conference)
Here is the weekly BI-RoundUp, lots of great things happened in the past week! Power BI – Developer Update There is now a developer update for Power BI Developer, and there are a whole host of new updates for the Power BI Developers. I will give a brief overview of each section and if you want more details please click…
Power BI – Losing Disk space when working with Power BI Desktop
I recently had an issue on a customer’s server, where I was developing Power BI Desktop reports. And the C: Drive was running out of disk space, which was attributed to my user profile. Upon inspection I found that the TempSaves directory had a whole stack of temporary files saved in there. Even though I had previously selected to change…
BI-RoundUp – Power BI (January 2018 Update – Power Apps Custom Visual)
Welcome to 2018, and I am sure that everyone is keen and ready to hit the ground running. I am really excited to see what this year will bring, both personally as well as with how things progress specifically in the Microsoft BI (Data and Analytics space). So here is my first BI Roundup for 2018 Power BI – January…
Ask a Question (Q&A) Hidden Treasures in Power BI Desktop
The new Ask a Question (Q&A) in Power BI Desktop really does make it quick and easy to create new visuals. Here is a link to the blog post from the Power BI Team: Q&A for report creation (preview) I have been using Q&A in the Power BI Service for some time, and there are a few hidden treasures that…
Power BI – Turning off (Disabling) Native Database Queries
In this quick blog post I am going to show how to turn off or disable having the dialog box which pops up when using Native Database Queries. This can sometimes be an extra step on something that you have to action when refreshing your data either in the Query Editor or in Power BI Desktop. NOTE: I was often…
BI-RoundUp – Power BI (December Desktop Update – Larger Power BI Premium PBIX – Power BI Bookmarking Contest – Premium Capacity WhitePaper)
Even though it is almost the holiday season, the wonderful people from the Power BI team have given myself (and hopefully you also) some early birthday presents. So please find all the updates below. Power BI – December Desktop Update There was an incredible number of updates in the December edition of Power BI Desktop, so please find below all…
How to enable Excel Pro’s to use Power BI Datasets
In the steps below, I am going to demonstrate how to access your Power BI Dataset through Excel. This is a great example for people who love Excel and use it as their tool of choice, but the company or organization still wants to have a single version of the data. By leveraging the steps below the data is available…
BI-RoundUp – Power BI (Nov On-Premise Data Gateway Update – Weekly Hot Topics – Project Online Content Pack)
After very quiet in the previous week, here is this week’s round up details. Power BI – November On-Premise Data Gateway Update Whilst it might not appear as though there is a lot with regards to the November update to the On-Premise data gateway there IS! The first thing is that they have now implemented High Availability. This is really…
Power BI Embedded InfoGraphic
There has recently been a lot of talk around Power BI Embedded for various reasons. The first being that Power BI Embedded can be used to for Power BI Reporting requirements, where the users are viewing it from an internal application. This can work for existing applications where a business has data. As well as potentially as another avenue to…