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


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
If you need connected SAP HANA which is an enterprise in memory analytics system, you can do that in Power BI very easily. We have two options to connect. You can either import your data which allows you to use modeling capabilities in Power BI and work remotely, or you can choose to use DirectQuery mode which will let you connect directly to the server and use the power of the server and just use Power BI as your visualization layer. Well, let me show you how. When you're in Power BI in the Get Data screen, you can just search for SAP and you'll find SAP HANA here, and you can hit connect. You enter in your server information and you can choose here if you want to import it or do DirectQuery. I'll do DirectQuery and now I hit ok. If it's your first time it will ask for your credentials, but in my case, it remembered so I don't have to enter them again. Now I can navigate down to find the model that I want to connect to and then I can select the fields that I want. I want returned, sold, color, country, and product. And once I've selected everything I want to use in my Power BI report, I can click load. It will start creating that live connection, and once it's done, I'll see all the fields I selected here in the fields list, and then I can start dragging and dropping them just like any other fields in Power BI. So I'll select country and sold. And I want to make this a bar chart and then I can also drag on color and returned and make this also a bar chart. And just like any other charts in Power BI, I can do things like cross-highlight. These work just like any other Power BI charts. I can go in and mess with formatting, I can do all the kinds of cross-highlighting and filtering and all the other powerful visualization features we have in Power BI.

Video Details

Duration: 2 minutes and 20 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 50
Posted by: csintl on Jan 6, 2017

Names of Microsoft products need to be spelled correctly (DirectQuery) and things that the user "clicks" should match what they see on the screen (capitalization). I deleted the 10 MTed captions, fixed the English. Please use the corrected English cc to re-MT the 10 languages. Thanks. ----- (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.