Initial configuration and obtaining data
- Start the Power Desktop application on your computer.
- In the tab or start menu, select ‘Obtain data’.
- In the drop -down menu choose ‘Web’.
Entering the web URL
- Enter the URL shown in the ‘From the web’ Dialog box below or use this link.
- Click ‘OK’ To process.
3. If requested, select ‘Anonymous Access’ To connect to the web content and click “Connect.”
Selecting the appropriate table
- In the browser window, choose the label labeled “Individual factors scores are normalized on a scale of 0-100 …”.
- Click on ‘Transform data’ To open the Energy Consultation Editor.
Working at the power consultation editor
- The power consultation editor will open, showing predetermined actions in the ‘Query configuration’ Low panel ‘Applied Steps’ As a show.
- You can change the name of the table to what you want and the press Get into.
Add and customize columns
- Navigate to ‘Add column ‘ Tape and select “Personalized column”.
- In the custom column dialog box, enter ‘New score’ As the name of the column (or any other name you prefer) and provide the desired formula as shown.
- Make sure the state message at the bottom is configured as ‘Syntax errors’ have not been detected
- Then click ‘OK’.
Applied Steps Review
Verify the panel ‘Consultation configuration’ to see that the recently added personalized step is now listed in “Applied steps”.
Adjust and transform data
Before processing with this query, let’s modify it to better adapt to our data requirements. We will do the following:
- Adjust the classifications by eliminating a column.
- Select the ‘Climate’ column and eliminate it by clicking ‘Eliminate columns’ From the start tab.
2. Click on the right button in the ‘Eliminated columns’ Pass and move it over the ‘It was added custom’ Step to adjust the order of operations as shown below.
Note that the new score column now shows “error” instead of the calculated value.
For more information about each error, select the column and the power consultation editor will show the details.
Two changes are required to correct the error: Eliminate the name of the weather column and change the divisor from 7 to 6.
These can be made of any of the following ways:
- Right click on the “Added or column” Step and select “Edit configuration”. This will open the custom column dialog box used to create the new score column.
- Modify the formula as described previously (that is, eliminate the weather and change the divisor from 7 to 6).
- Select the new punctuation column, then enable the verification box of the formula bar in the view tab to show the column data formula.
- Modify the formula as described previously until it appears as follows, then press Get into.
Order and replace values
- To order data, select the ‘It was added custom’ Step, click on the drop -down menu next to the ‘New score’ Column header and choose ‘Classify descending. ‘
Note how the power consultation editor automatically adds a new step immediately after the applied step currently selected.
- In the applied steps, select the step before the personalized column, that is, the passage of eliminated columns.
- Right click on the cell with Nebraska value of quality of life.
- Select Replace values.
The Power Query editor notifies us that the Subferent steps could break the consultation since we are inserting a new step.
- Replace the data value to 70.
- Select OK. The power consultation editor now replaces Nebraska data.
FINAL CHANGE REVIEW
Note how the power consultation editor appoints a new entry (Replacement column) in applied steps.
- Select the last step applied, ordered rows.
Note that the data has changed with respect to the new classification of Nebraska.
Follow this link to obtain a more step -by -step guide on how to prepare data for a board using data from a spreadsheet application such as Microsoft Excel.
Conclude
This guide has provided a basic overview of the use of power consultation in Power BI to transform and manage data efficiently.
Start with the initial Power Bi Desktop settings and explain how to obtain data from a web source.
Users are guided by inserting a URL, selecting the appropriate data table and sailing through the power consultation editor interface.
The guide also covered the sum and customization columns, including the definition of new columns using personalized formulas.
He explained how to review and adjust the applied steps, eliminate unnecessary columns and reorder the steps to guarantee a precise data transformation.
It also included instructions to handle errors, classify data and replace specific values to meet data requirements.
The process concludes with the review of the final changes to ensure that all data transformations are applied correctly,
This guide must train beginners to take advantage of Power Query’s abilities to create significant reports and obtain valuable information from their data.
