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

Lab-5-7a

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
Power BI is a great place to do really simple visual analytics on your data. But for many people, they want to work with spreadsheets and see the numeric information in their data. And so it's actually really easy to connect Excel to your data sets that have been published through Power BI. On the navigation menu for the data sets that you've got in your Power BI account, you'll find this Analyze in Excel button. When you click that two things will happen. At the bottom you'll see that we've downloaded a connection file to this data. And there's also a notification up in the top right that you might need to install some new Excel libraries. These are the libraries that allow you to connect your desktop Excel application to the models in the Power BI service. So let's just run those and get those installed as well. And now we can go ahead and open the ODC, the connection file, up in Excel. You'll get a notification about security, and you'll have to authenticate to log in to the Power BI data set. And now Excel will connect to that data set in the Power BI service and bring it down as a pivot table for me. And you can see over in the field list, I've got all the fields that are accessible through the Power BI service, through the reports, and through the data sets there. And I can start building that pivot table. Let's take a look at our product categories. And let's do our year-to-date revenue on top of that. And you can see I'm building a pivot table over on the left-hand side just as I would do with any other pivot table in Excel. I can do things like showing or hiding particular categories. I can sort things. I can filter things in just the same way as I would do with any other pivot table in Excel. I could even do things like building pivot charts or adding slices and building a dashboard that's live, connected up to the data that's sitting in Power BI. So if that data set gets updated, when I come and refresh the workbook it'll be showing me the latest data here in Excel. I can carry on doing all of the analysis and formatting that I would do through any other Excel workbook.

Video Details

Duration: 2 minutes and 14 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 28
Posted by: csintl on Apr 14, 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.