Watch videos with subtitles in your language, upload your videos, create your own subtitles! Click here to learn more on "how to Dotsub"

2017_02_02_Power_BI-7-5a

0 (0 Likes / 0 Dislikes)
  • Embed Video

  • Embed normal player Copy to Clipboard
  • Embed a smaller player Copy to Clipboard
  • Advanced Embedding Options
  • Embed Video With Transcription

  • Embed with transcription beside video Copy to Clipboard
  • Embed with transcription below video Copy to Clipboard
  • Embed transcript

  • Embed transcript in:
    Copy to Clipboard
  • Invite a user to Dotsub
One of the most important things once you've published a report up to Power BI and built your dashboards is to keep that data up to date and make sure it's refreshed so that you can track changes in the data over time. If you've connected your Power BI reports to an on-prem data source, to a SQL server or even a set of files that exist on your machines inside your organization, you can use the Power BI gateway to connect the Power BI service up to those data sources. The Power BI gateway comes in two flavors—there's a personal gateway and an enterprise gateway. I'm going to focus on the personal gateway here. And this is something that you can just install on any machine in your organization, and it just runs as a little agent that communicates between the Power BI service and those on-prem data sources. Anybody can set it up, and it's then used just by you with your credentials to connect to the data sources that you want to refresh. That's an important thing to understand, that it is a personal gateway—that's why it's named so— that it uses your credentials when you want to go refresh that data. You download that from the Power BI website, configure it and install it on your machine, and then there's a little set-up process that I'll walk you through to get it connecting and refreshing that data. So let's take a look. So I've logged into Power BI here, and the place that you can go to to get the Power BI gateway is off this downloads tab in the top right-hand corner. You'll see a link to data gateway. This will take you to the download page, and like I said there's two different types of gateway. These are listed out and the differences are explained at the bottom of this page. So you can see that personal gateway only works with Power BI. It doesn't work with things like PowerApps or Azure Logic Apps or Microsoft Flow. You'll need to full on-prem data gateway if you want to use those. But personal gateway lets you set up that scheduled data refresh. It can run as an app. You don't even need to be an administrator on your machine. And like I said, it runs just as a single user using your credentials. So it's a very simple little app that runs. So hit download and it'll pull down the installer. And we'll start running that. So there's a few set-up steps that you need to go through to start that installation. And you'll see there's a few warnings on here about making sure that this is connected and this is installed on a machine that's always on and that's always connected to the Internet. So if you install this on a laptop it'll work and it's fine. But just be aware that when that refresh kicks off, it needs to be able to connect to that laptop, so it needs to have an Internet connection and it needs to be turned on. So if it's a machine that goes to sleep after a certain number of hours, if the machine's asleep the refresh won't work. So it's just downloading the rest of the personal gateway now. And after a couple of seconds it'll start installing. Okay, let's step through this. So like I said, you'll get those warnings about refreshing over a laptop. But also if you're connected over a wireless network, the refresh may take longer. It is going to be sending data up to the Power BI service, so it's going to be based on your bandwidth. Accept the license agreement. Choose where you want to install it. And it'll go ahead and install. Okay, we're done. So I'm going to launch the gateway itself and finish the configuration. So the first thing you'll need to do when you're configuring this is sign into Power BI through the gateway. So this is hooking up this little gateway agent using your credentials up to the Power BI service. Typically this happens in the background but you might get prompted to put in your credentials again. If you've already logged into Power BI once, it'll just connect it automatically. Okay, successful. The gateway is up and running. And now what we need to do is go and configure our data sources to use this gateway when they're refreshing. So if I go back to Power BI, let's take a look at the data sources that I've got access to. These are my different data sets. Here's my different data sets, and this is the one that I'm going to refresh here. So I'm going to go into the settings for this data set. And you can see I can choose the connection that I want to use. So it's picked up that it's going to use my own new data gateway, so this is a personal gateway. And you can see that it's online and it's running on my machine. So if the machine that you were running on was turned off or didn't have a connection to the Internet, this would show as offline and you'd need to go fix it on that machine. And when you start setting up the refresh schedule, et cetera, for this data source, you'll need to go and re-enter the credentials for this. So it's actually just pointing at an Excel workbook, and it's just a workbook on my local directory, on my local computer. And that's another thing that's important to understand. If you're connecting to a local computer when you're building your reports, you're connecting just through c:/ whatever, that Power BI gateway needs to be installed on that same machine. It's just going to be looking for that absolute power. If you're connecting to a network share, then obviously that can be installed on a different machine and the gateway will just go and look for that network share when it needs to connect. So because this is using Windows, I can just sign in and it'll go and connect to that automatically. And once I've set up all of those different data source credentials, if I was connecting to a SQL server I might need to put in the SQL server connection. If I was connecting to some other application I'd need to put in those credentials. Now I can start scheduling my refresh. So I can choose how often I want to schedule it, at what time, and I can have multiple refreshes per day and decide whether I want to get an email notification if that ever fails. So you can see now that having gone through all those steps of downloading and installing the gateway, then going to Power BI, choosing a data set, and saying I want to connect through a gateway and setting up the schedule for the refresh and putting in the right credentials. That report and the data set and the dashboards built off that are all going to get kept up to date and refreshed so that you've got data being updated automatically. You can track all those metrics over time. So it's really simple to use that personal gateway to keep those things up to date and track your business through Power BI.

Video Details

Duration: 6 minutes and 37 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 8
Posted by: csintl on Mar 7, 2017

You already have the ENglish transcript. Please use that to MT. DO NOT CREATE A NEW ENGLISH transcript/CC!!!!!!!! ----- (Please provide translations for these languages: Chinese (Simplified) (chi_hans), Chinese (Traditional) (chi_hant), English (eng), French (France) (fre_fr), German (ger), Italian (ita), Japanese (jpn), Korean (kor), Portuguese (Brazil) (por_br), Russian (rus), Spanish (spa).)

Caption and Translate

    Sign In/Register for Dotsub to translate this video.