![]() ![]() At the bottom, there are two options–the “load” and “transform data.” For editing the dataset, choose “transform data,” else click the “load” option. Step 5: Select the worksheet name (sales data) where the data resides. Alternatively, we can upload the data as it is. In this, we can edit the data using Power Query Power Query Power Query is an excel tool used to import data from different sources, transform (change) it as required, and return a refined dataset in the workbook. Step 4: The “navigator” window opens, as shown in the succeeding image. Go to the saved folder and select the file. Step 3: Choose the desired file from a location on the computer. Since our data is in Excel format, we choose the same. Select the appropriate option depending on the type of data source. Step 2: In the Home tab, click on the “get data” drop-down list Drop-down List A drop-down list in excel is a pre-defined list of inputs that allows users to select an option. Step 1: Keep the data ready in any of the mentioned file extensions–Excel, text/csv, xml, json, pdf, etc. The steps to upload the given dataset are listed as follows: The succeeding image shows a sample dataset prepared in Excel. Let us learn how to upload the data to the Power BI desktop.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |