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
When you first connect to a data source, Power BI will sample the top couple of hundred rows of that data and try and infer the data type for each column. But it doesn't always get it right, and sometimes maybe if your data changes after a few hundred rows, we may not sample all of the data before choosing the data type. And it's easy to correct that and change it if you need to. So just as an example, I loaded this table in, and loaded them all in as text. So you can see that we have this little ABC icon across the top of each column header to show that it's been treated as text. Now, obviously things like the date should be a different data type. The revenue should be a different data type as a unit. And it's really easy to go and change these. All I need to do is select the column that I want to change, and click that little ABC column or the other icon that you'd get in the same spot. And you can see the different data types supported in the query editor. So for a date, I obviously want to select the date. Now, if I had information in this column which had a time stamp as well, then I could choose date time.. If I was just interested in the time bit of that date/time combination, then I can choose time and it would strip the date piece out. If you had data that also supported a UTC time zone offset, then you can apply that, or a duration like a certain number of seconds or minutes, you can choose that one. So, this one is a date, and you'll see that Power BI has passed the YYY-MM-DD dates and turned it into a date format. Let's do the same thing for numeric fields. So units is a whole number, we only have a ship whole unit, but revenue, that's a dollar amount. So we can either choose a decimal number, which would give us a float end point decimal, or a fixed decimal where we have a certain amount of decimal places. And by default, it will treat it like currency and have four decimal places. I can go and customize that as well if I want to to specify the number of decimal points to use. So changing the data type of your columns is really simple, just click that little icon at the top of the header, or you can use the data type option in the ribbon here on the home tab. It's really simple just to select those if Power BI doesn't get it right for you at first as you load the data.

Video Details

Duration: 2 minutes and 34 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 38
Posted by: csintl on Aug 15, 2016

if this is a duplicate, please ignore ----- (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.