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