Power BI RoundUp with SQL Pass updates – Dataflows – Paginated Reports (SSRS) – Premium Metrics App with Data Flows & Paginated Metrics – Paginated Reports in Mobile App – Mobile & Service Update for Oct – Bonus features coming to Power BI Desktop
As expected this week with SQL Pass, there has been a whole host of new capabilities and features in Power BI, so please see my roundup below with the relevant links below. And even though there is a lot of announcements here, we are still waiting for the update to Power BI Desktop!! Power BI Dataflows One of the biggest…
DAX Measure – Getting Difference between 2 values in a table
I had a requirement where the customer wanted the difference between 2 values in a table. The challenge here was that because the values are already part of the table, I had to find a way to get the unique value for each item. This would then allow me to calculate each value separately and then calculate the difference. This…
Power BI RoundUp – Webinar on Advanced Data Prep – Data Flows in Power BI – On-Premise Data Gateway Update – New Power BI Regions in Azure – General Availability of Custom & Certified Data Connectors
Here is my weekly Power BI related round up, I hope that you find this information relevant and keeps you up to date with everything that is happening with regards to Power BI. Power BI – Webinar on Advanced Data Prep with Dataflows https://community.powerbi.com/t5/Webinars-and-Video-Gallery/10-23-18-Webinar-Advanced-data-prep-with-Power-BI-data-flows/m-p/534100 There is an upcoming Webinar on 13 November 2018, where Anton Fritz will introduce you to…
Running Power BI Reports or Dashboards in Fullscreen without the Buttons
I had seen some questions in the Power BI Community when asking how to run reports or dashboards in a browser screen so that they cannot see they buttons on the bottom left hand side. In my example I am going to use my existing dashboard that I want to display where it does not show anything from Power BI,…
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 RoundUp – (Desktop Update Oct 2018 – Aggregations for Petabytes Scale – Webinar Ask Anything on Power BI Premium – Power BI Report Server Timing)
I am sure that there were a few people who were eagerly waiting for the Power BI Desktop Update for October 2018. I sure was one of them and it was well worth the wait. Please read all the details below, as well as other updates that happened in the past week. Power BI – Desktop Update Oct 2018 There…
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 RoundUp – (Power BI Preview Features in Action – Developer Update for Sept – Webinar on Power Query & M for Calendar Tables)
Welcome to another week of the weekly Power BI RoundUp, I hope you enjoy catching up on the latest content below. Power BI – Power BI Preview Features in Action In this blog post by Chuck (Charles) Sterling he goes into details on all the preview features that are going to be shown at the last 3 stops of the…
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 RoundUp – (Premium Capacity Metrics App – Power BI Home & Global Search)
I have decided to rebrand or change the name of my weekly round up from BI RoundUp to Power BI RoundUp, because it is almost always about Power BI. And with the new direction from Microsoft this makes perfect sense. As always please find the latest updates below. Power BI – Premium Capacity Metrics App This new app is great…