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

Lab-1-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
>> Enter Data is a feature that allows users in Power BI desktop to create new tables by either typing a table manually or by pasting in table contents from their clipboard. This feature can be accessed from the home tab in the ribbon. When you click enter data, we're going to show you a new dialogue called create table, that will basically allow you to interact with a data grade where you can either create tables manually. For instance, we can specify a column name and we can specify a second column such as the age. And now we're going to specify the values for the rows. So we could say for instance... In the first row we could define a second row. We can define a third row. And so on so forth. The next thing that we could also do here is change the name of the table that we're going to create. You can call it people. And we can decide whether to load the data or add it as a query so that you could filter and apply further transformations to this table before loading. In this case, well just go and click load. Once we do that we're going to load this table into the data model in Power BI desktop, and the table will be available for you within the fields list, the fields pane so that you can actually drag and drop into the canvas to visualize data in your report. The second way of creating new tables through the enter data dialogue is by pasting in data from the clipboard. We support various different clipboard formats including text, but most importantly Excel. So you can actually go into an Excel spreadsheet where you have some data that you would like to capture just as static data. You can select the interesting data range and click copy. And when you come back to the create table dialog you can just do a control-V. I think I didn't copy the whole thing. So we could copy, and paste. So as you can see now that I paste it, we automatically detect that the first row looks like the column headers because in the case of a quantity column, all of the values within this column look like numbers, except for the first one. So we actually use that to infer that the first one was actually the headers. So we automatically promote them for you. We show you this little warning. If you wanted to undo that, it's just as easy as clicking undo headers. And then you can then start adding new columns as well. The moment you add a new change to the grid, you see that warning going away. And then you can add something else. So for instance we could add a price column. Something like that. And from here you can load that table as well. You could say fruits, and load. And that creates the new fruits table with the three fields, the two that came from the Excel spreadsheet, and the one that we just created manually in the grid. As you can see, enter data is a very useful feature for you to create static tables that either came through manual input or through the clipboard from a different program. And it will allow you to compliment date in your Power BI desktop report and open up for lots of new opportunities and possibilities for you to work in your reports.

Video Details

Duration: 3 minutes and 32 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 38
Posted by: csintl on Feb 23, 2016

----- (Please provide translations for these languages: 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.