Reactivated Players DAX Pattern
I had a requirement where my customer was looking to gain some insights into their data relating to reactivated players. The definition used for a reactivated player is a player that has previously played but has not played for a certain number of days. The player then comes back and plays again. So, by this definition the player is reactivated….
Resetting Page back to Defaults using the New Buttons Feature and Bookmarks in Power BI
In this blog post I am going to show how to use the new Buttons feature to reset your page back to all the defaults, using the new Buttons and Bookmarks I have started implementing this on report pages and find it very handy for end users to just reset the page and not have to concern themselves with de-selecting…
BI-RoundUp – Power BI (Drill up, Drill Down Mobile App – USA Facts on Financial Data)
Here is the weekly BI-RoundUp, not too much going on this week, which gives me a little time to breathe! Power BI – Drill Up, Drill Down on Mobile App The Power BI Mobile App has been updated to so that now it is a lot easier to drill up or drill down on the visuals on the mobile platform….
Azure Analysis Services or SSAS Tabular 2017 – How to put in Custom TSQL Server Queries using the SQL Server Window
I have recently been working on SSAS Tabular 2017 for the current customer I am consulting at. Along with this I am starting to see that Power BI Premium features are appearing to lean more towards SSAS, so I personally feel that getting into SSAS Tabular 2017 is a great way to understand and work with a similar version of…
BI-Roundup – Power BI (Service & Mobile Update for March – Power BI is Hiring – Edit the Linguistic Schema for Q&A)
Here is the weekly BI-RoundUp. Power BI – Service & Mobile Update for March There were quite a few updates in the Power BI Service for March which was awesome. There are now persistent filters, so that users can keep their own filters that they select on each report, which now works on both the Web and Mobile App Organizational…
How I keep ontop of Power BI Support Issues
When working with Power BI on a daily basis, as well as chatting to various customers or users, one thing that I have missed in the past was to be aware of any Power BI Support Issues that are happening. So what I did was to build a Power BI Support Issues page, which I refresh daily, and then using…
BI-RoundUp – Power BI (April Desktop Update)
Here is the weekly BI-Roundup, and with the release of the April Power BI Desktop update, there are always some new features to explore. Power BI – April Desktop Update Reporting As with the image above there are some additional options for Q&A Explorer, which will enable your end users to be able to explore Q&A with some questions already…
BI-RoundUp – Power BI (Business Applications Summit – HITRUST CSF certification)
Here is the weekly BI RoundUp, which I feel is the quiet before the awesome Power BI storm which will be hitting us next week. Power BI – Business Applications Summit Finally they have announced the dates for the Microsoft Business Applications Summit, there is not much more details as it currently stands. All that is available is to sign…
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev, Test & Prod)
As I am sure a lot of people noticed if you now go into the settings of your dataset there is an additional option which says Parameters. What I wanted to test out was to see if I could change the connection strings using the Parameters in the Power BI Service. The advantages of this working in my opinion is…
BI-RoundUp – Power BI Spring Roadmap (SSRS in the Cloud, Common Data Service for Analytics, Incremental Refresh & more) – Power BI Report Server Update – Building the Opioid Power BI Report
After last week, it appears that the Power BI team is still very busy, and after the announcement yesterday and the download of the Spring Roadmap there is a whole host of amazing things coming in the next few months! Power BI Spring Roadmap I will be going through the Power BI specific sections below to make it easier to…