From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Manually entering data

Manually entering data

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Manually entering data

“

- [Instructor] We also have the option to manually enter values by typing or pasting them directly into a new data table. We may find this method helpful when we are getting data from a source difficult to directly extract data from or an unstructured source. In Power BI, the easiest way to manually enter data is to first exit out of this flash screen and then we can edit the queries by hitting the edit queries button at the top of the home screen. This takes us back into the query editor where we can go ahead and enter data right up here at the top. In this dialog box, we are going to enter the data to create this table manually. In column one, we're going to call this time period. I'm going to enter in months one through 10. Then we add the amounts for each of these months. Now we can rename this query by calling it sample set down here at the name box at the bottom. I'm going to go ahead and call it sample…

Contents