Quick Tips for Aggregations & Composite Models in Power BI
I have been working with a customer on the implementation of Aggregations with Composite Models in Power BI and I have found that there are a few useful tips to assist you with getting it up and running. Tip 1 – Always ensure that queries start off as DirectQuery When starting to bring in the composite models the first thing…
Power BI Gateway – How to remove a Gateway Instance from the Gateway Cluster
I recently was troubleshooting a performance issue for a customer where their LiveConnection was slow when connecting to an On-Premise SSAS Tabular server via the On-Premise Data Gateway. One of the things that I had to do was to remove an existing On-Premise Data Gateway from a cluster, so that I can then move the Gateway onto another server. NOTE:…
Power BI – Modifying the Colours in the Options of the Visual Headers
I was recently consulting at a customer and I was looking to better understand if there was a way to disable the exporting of Underlying data, but whilst investigating this I came across the formatting pane and as shown below I could modify the menu in the Options for Visual Headers which I detail below. The first step is to…
Power BI InfoGraphic Update – Sep 2018
It has been a few months since I have updated my Power BI InfoGraphic and with the speed at which this all changes and updates I have always had a challenge to keep it up to date. The following items have been added with links to more details: Composite Models Buttons Aggregations Comments in Dashboards New App Workspaces Geographic Distribution…
BI-RoundUp – Power BI (Service & Mobile Update for July & August 2018 – User Research Panel – On-Premise Gateway Update for Sep – Webinar on Power BI Dashboard Comments)
Here is this weekly BI-RoundUp where I will detail what updates there have been in the past week. Power BI – Service & Mobile Update for July & August 2018 In the past two months there has been a lot of updates to the Power BI Service and the Power BI Mobile App. All the details are below with links…
DAX – Getting the Start Date of the following Week
I was recently doing some work for a customer where they wanted to compare their date to the start date of the following week. They also had a requirement to persist the data to the dataset. I thought that this would be a good challenge to use DAX with a calculated column. I most certainly could do this using the…
BI-RoundUp – Power BI (Sep Update for Power BI Desktop – Dashboard Comments – Community Contribution to PowerShell Cmdlets – Power BI PowerShell Cmdlets available in Azure Cloud Shell)
Welcome to another week of my Power BI Round Up. And as expected there is another massive Power BI Desktop Update. Power BI – September Update for Power BI Desktop As always I am going to over the new features and highlight what I think is really relevant in terms of what has been released. Reporting With the added support…
BI-RoundUp – Power BI (New Monitoring Capabilities for Power BI Premium – Developer Update for August – Webinar on New Power BI Tools)
Welcome to another week of the BI-RoundUp. Power BI – New Monitoring Capabilities for Power BI Premium As you can see above there now is an App which you can get for Free from the App Source which will get all your capacity metrics which you can then use to better understand how you and your users are using your…
What runs under the cover when I open Power BI Desktop
I am always interested in what happens under the covers when I open Power BI Desktop. So I did a little digging and I got the inspiration from Macro Russo when he did his Webinar as well as presented at the Queensland Power BI User Group on “My Power BI report is slow: what should I do?” What happens when…
BI-RoundUp – Power BI (On-Premise Data Gateway August)
This week has been rather quiet, but I have a feeling that if Power BI Desktop gets released next week, we will be back at it and have a whole host of updates. Power BI – On-premise Data Gateway Update for August In this month’s update there is additional improvements for Custom Data connectors. And it also has got the…