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

Lab-4-6

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
So far we've looked at how you can use Power BI to connect to data sources and then manually publish that or upload it into the Power BI service. However, you're not going to want to do that every time your data changes. And so you can use Power BI to set up a scheduled refresh that will connect to whatever data sources you set up and publish them up into the Power BI service automatically. This also gives you a way to connect the service and that online capability with any on-premises data sources that you've got, whether that's Excel files or access databases or SQL server databases or Oracle or other database platforms like that. We call this the personal gateway, and what that is is a simple application that runs on your desktop or on a laptop and makes that connection for you. So on a scheduled refresh, it'll go and pull data out of those data sources and push them up into the Power BI service for you. Let's take a look at how to install it and configure it now. So I'm logged into the Power BI dashboard here, and up in the top right-hand corner I'll see this little download icon. When I click this, I've got a few different options of things I could download. And the one that I'm interested in here is the Power BI Personal Gateway. When I start downloading this, it will pull down an application onto your desktop. And it will take us through a wizard through installing everything. Like I said, it's an application that actually runs on your desktop. It will run in your system tray in your notification area, and it can either run as a background service or as a user application depending on your admin privileges. So you don't need to worry about being an administrator on your machine. The first thing you'll get is a couple of warnings—or at least you may get some warnings— if you're doing things like installing on a laptop. The Power BI Gateway does need to be on, and the machine that it's running on needs to be connected to the Internet. And it needs to be on when that refresh is scheduled. So you'll get warnings here saying if you're connected to a wireless network, it may take a bit longer. Or if your computer's asleep when the refresh is scheduled, the refresh won't work. I'm okay with it at the moment. I know I'm going to be able to make sure that machine is on all the time. So I'll just accept the license agreement and start installation. I'll choose the default folder. And the installation gets started. Once it's done, you'll actually need to go in through and configure the gateway, as well. So I'll launch that now. The first thing you have to do is sign back into PowerBI.com. So this is connecting the Gateway up to your Office 365 account, the one that you use to sign into Power BI with. So it tells me I'm signed into PowerBI.com. And now I also need to put in the user name and password that it'll run on my machine. So this is my Windows user name and password, the one that I would normally log into this machine with. So now if I go back to my dashboard, I'll see that I've got my VanArsdel Sales data set that we uploaded earlier on. When I click the ellipsis menu from here, I've got an option to schedule refresh. And this will take me through to a screen where I can go and configure this refresh operation. It'll actually tell me, "Hey look—" It's detected the Gateway, and it's found that the one I just installed is ready to go. And it's going to tell me that the data sources that I've connected to need to be updated. It's already detected that we had two data sources that we were connecting to. There's the access database and the folder that we had connected to as part of the early allow. And I need to go and set the credentials for this. So how will the Power BI actually connect to these data sources? So for the access database, I'm just going to use a Windows authentication method, and it will use the Windows credentials that we put in earlier for the Power BI Gateway. For the folder, it's going to be the same thing. So now any time there's an update to the data in the access database. Or any time that any new files arrive in that folder, the Power BI Gateway will be able to go and connect, integrate all that data, and push it up to the Power BI service. So the last thing to say is, what schedule do we want to do that refresh on? Yep, I want to keep my data up to date, and I want to set a frequency. Maybe I want to do this every day, choose the time so I can add in a time. If I want to do multiple times a day, I can do that as well. So maybe we'll do one at 11 pm and one at 11 am. And finally there's a checkbox down here, and you'll actually get an email if there's any problems with the refresh. So for example, it you had it installed on a laptop— sorry, if you had the Gateway installed on a laptop and it had gone to sleep during that refresh period, you'd get an email saying, "Hey, the refresh failed. You need to go and check out what's going on." Hit Apply. Everything gets saved, and now it's ready. The Power BI Gateway is going to sort of fire up on that schedule, connect to those data sources, do all of the integration and all the modeling on that data that we'd assigned before it got uploaded, and then push that data back up into the Power BI service. And we'll see when we start loading these dashboards— we'll see the tiles in this dashboard get uploaded automatically. The data will just start changing as things flow into those data sources and as they get picked up by the Gateway.

Video Details

Duration: 5 minutes and 43 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 49
Posted by: csintl on Jun 29, 2016

----- (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.