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 [...]
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 [...]
SQL Server has GA'd!!! We also had a lot of updates for Power BI! Creating Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M (@technitrain) Power BI Desktop May Update Feature Summary Smarter Auto-Generated Insights with Complex Filters Power BI gateways – May Update SQL Server 2016 is generally [...]
