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 - [...]

Adam & Patrick Unplugged – EP12017-03-31T09:03:23+00:00

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 https://www.youtube.com/watch?v=0R2wL1oMFrg Questions: 1. Can you use a [...]

PASS Summit 2016 / SQL Clinic Recap2017-03-16T09:01:11+00:00

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.

Moving from the Personal to the On-Premises Data Gateway in Power BI2016-10-11T13:15:18+00:00

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 [...]

Troubleshooting Gateway Performance2016-10-04T07:59:56+00:00

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 [...]

4 Troubleshooting connectivity tips with the gateway2017-03-16T09:01:13+00:00

3 Gateway settings to get you up and running with Power BI

There are 3 gateway settings that I find helps people with getting the On-Premises Data Gateway up and running in their enterprise environment. Issues will come up when companies restrict their network with tools such as firewalls or proxies. These 3 gateway settings will help you to successfully set up and use the on-premises data [...]

3 Gateway settings to get you up and running with Power BI2017-03-16T09:01:13+00:00

3 tips to avoid a missing gateway with Power BI

Have you every run into a missing gateway in Power BI when trying to configure scheduled refresh? You set up the On-Premises Data Gateway but it isn't showing up.                         I've had this discussion with many customers. It may come down to some items [...]

3 tips to avoid a missing gateway with Power BI2017-03-16T09:01:13+00:00

Tips, Gateway, Embedding and Analysis Services – Roundup #57

There were a bunch of items I found this week. From tips for beginners, to some gateway updates and items for Analysis Services. I have a few bonus links down below that weren't included in the video. Top 10 Tips for Getting Started with Power BI (@ExceleratorBI) Translations in Analysis Services 2016 (@marcorus) On-Premises Data [...]

Tips, Gateway, Embedding and Analysis Services – Roundup #572017-03-16T09:01:14+00:00

3 Scenarios to Understand Azure Active Directory Better with Power BI

Have you struggled to understand Azure Active Directory (AAD)? Let's look at 3 scenarios, focused around Power BI, to help understand Azure Active Directory versus your local Active Directory (AD). You may not know the difference between AAD and local AD. Honestly, why does it matter? As long as your reports work and you can do [...]

3 Scenarios to Understand Azure Active Directory Better with Power BI2017-03-16T09:01:14+00:00

On-premises Data Gateway with Power BI

Have you heard of the On-Premises Data Gateway, but aren't sure how it applies to your business? Were you using the Power BI Gateway - Enterprise, an not sure how to get over to the On-Premises Data Gateway? This video is for you. What is the On-Premises Data Gateway? The data gateway is the [...]

On-premises Data Gateway with Power BI2017-03-16T09:01:16+00:00