The On-Premises Data Gateway and Power BI – Revisited

In this video, Adam revisits the On-Premises Data Gateway to help get you up and running with it. This was looked at a year and a half ago and things have changed. The On-Premises Data Gateway can be used with Power BI along with other services like Azure Analysis Services, Microsoft Flow, and PowerApps. Install [...]

Azure Analysis Services, Power BI, and the On-Premises Data Gateway

In this video, Patrick looks at when you need the On-Premises Data Gateway when using Azure Analysis Services (Azure AS). Do we need it with Power BI? Or just Azure AS? What's the difference? Patrick also shows you why your gateway may not show up in the Microsoft Azure portal.

Power BI & SQL Server Always On Availability Groups

In this video, Patrick shows how you can successfully connect to your SQL Server Always On Availability Group (AG) Secondary Read Replica using Power BI Desktop and the On-Premises Data Gateway. Adam jumps in to show you what the connection string looks like when you use this approach. Configure Read-Only Routing for an Availability Group [...]

Free book, Updates for SSRS and SSAS and an updated Power BI gateway

Online Book: Analytics with Power BI and R (@leila_etaati) When to Use SUM() vs SUMX() (@ExceleratorBI) Model Comparison and Merging for Analysis Services SQL Server 2017 Reporting Services Release Candidate now available Power BI On-premises data gateway – July Update is now available! BONUS ITEMS: Value.Compare in Power BI, An Advanced Power BI Class Excerpt [...]

Dynamic Power BI reports using Parameters

In this video, Patrick shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report. This uses M Functions within Power Query and a second source that has the key values to pull. Then using a gateway to enable refresh.

Adam & Patrick Unplugged – EP1

In this video, Patrick and I talk about what is on our minds. We take a look at some custom visuals within Power BI and also talk about the On-Premises Data Gateway. What is Adam and Patrick Unplugged? 0:24 Custom Visuals on Office Store - 6:22 Play Axis Custom Visual - 10:43 Gateway updates - [...]

PASS Summit 2016 / SQL Clinic Recap

Last week was PASS Summit 2016, and I spent a lot of time in the SQL Clinic answer your questions! I wanted to highlight a few of the questions that I was asked in the Clinic and share that out with everyone. PASS Summit 2016 / #SQLFamily montage Questions: 1. Can you use a [...]

Moving from the Personal to the On-Premises Data Gateway in Power BI

I get the occasional question about how to move a dataset from using your Personal Gateway to using the On-Premises Data Gateway for scheduled refresh or refresh now within Power BI. There are a few things to consider when trying to do this and I try to cover that in this video.

Troubleshooting Gateway Performance

I walk through what I know about troubleshooting gateway performance. This can be useful for Power BI, PowerApps, Microsoft Flow or Azure Logic Apps. This includes two main areas. 1. Performance Counters 2. Tracking query duration within the gateway logs. Hopefully, this will help you dig into what the gateway is doing, and how to [...]

4 Troubleshooting connectivity tips with the gateway

I have four tips for troubleshooting connectivity with the On-Premises Data Gateway on Power BI. These tips apply to any client application. Troubleshooting connectivity For this post, we will use an example of getting an error when trying to connect to a SQL Server named instance. In this case, we get an error when [...]