How to easily remove a Power BI On-Premise Data Gateway from a Cluster
In the past when I had to remove a Power BI Data Gateway from a cluster, I had to use PowerShell with a couple steps which was rather complex. I recently found out that this can now be easily achieved using the Power BI Admin Centre in the steps below. Viewing the Current Gateway with the Cluster Members The first…
How to enable the Power BI On-Premise Data Gateway to Stream data immediately
Below is a quick blog post on how to stream the data immediately when using the On-Premise Data Gateway. Currently as far as I understand it the On-Premise Data Gateway will wait and buffer some data before sending it through to the Power BI Service. By changing the setting below in the On-Premise Data Gateway, it will start streaming the…
Power BI RoundUp – Service & Mobile update for Feb 2019 | On-Premise Gateway Update | Update on New App Workspaces V2 | Power BI Embedded at Power Platform Summit | Multivariate reporting
Welcome to this weeks Power BI RoundUp, it is a little late this week. I have been fortunate enough to make it to Redmond and attend the MVP Summit, it was once again an amazing summit! Here are this week’s updates, which might be a bit shorter than normal due to being at the airport about to leave for home….
Power BI RoundUp – Dataflows Data Lineage | MBAS 2019 | On-Premise Data Gateway Update | Colour Theme Survey
Hi there, another week, another Power BI RoundUp with more awesome features from the Power BI Team Power BI – Dataflows data lineage When you are using dataflows there now is an option to view the data lineage. What this means to me is a visual representation of where and how your data is flowing within your dataflows. This is…
Power BI RoundUp | Time-Based Scheduling for Email Subscriptions | Power BI Report Server Update | On-Premise data gateway in the Power Platform | Monetization option for Power BI Custom Visuals
It is great to be back and already into the swing of a new year. 2019 has already started with a lot of new features already coming into the Power Platform. I am looking forward to the year ahead and no doubt will see a lot of new features coming. Here is this week’s Power BI RoundUp Power BI –…
Power BI – How to Configure “Send Refresh Failure Notification email to Distribution List (Multiple Users)” for Dataset refreshes
As it currently stands when I setup a dataset refresh it only emails me when it fails. I was recently at a customer where there is a team of Power BI Developers, and I wanted to find a way that all the developers would get a copy of the dataset refresh failure email. This would ensure a single point of…
Power BI RoundUp – Help Shape the Future of Power BI – On-Premise Update for Nov 2018 – Modeling View – Analysis Services is 20 years old!
Here is my weekly roundup, and whilst it has not been as busy as the past few weeks, there are still some awesome updates. Power BI – Help Shape the Future of Power BI I always think it is really important to provide feedback, especially when they are asking for assistance. You can click on the link above to take…
Refreshing data in Power BI from SQL Server Read-only or Secondary Replica’s
I have seen a lot of questions in the Power BI Community asking how to connect to a SQL Server Read-Only or Secondary replica, and whilst this is not currently available in the Sql.Database M connector, it is available in the OLE DB connector. NOTE: This could potentially be used for a whole host of other OLE DB providers NOTE…
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…
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:…