Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Intermediate
How do you add data from another file into your Power BI report?
On the Home ribbon, click on Get Data, select the file type, and browse for the file
On the Home ribbon, click on Edit Queries, select Data Source settings, and browse for the file
On the Home ribbon, click on Recent Sources, then select the file
Don’t know
2
Intermediate
You are in the Query Editor and notice that the top 9 rows of the data you want to import are all blank. How would you remove them?
Go to Home ⇒ Remove Rows ⇒ Remove Top Rows ⇒ 9
Highlight all the columns, go to the Transform ribbon, and click on Fill ⇒ Up
Right click the first column ⇒ Remove Rows ⇒ Remove Top Rows ⇒ 9
Don’t know
3
Intermediate
During your data transformations, you right clicked on the “Products” column and chose to “Unpivot Other Columns”, resulting in 3 columns: Product, Attribute and Value. Now the source system has added another 20 columns to your data. What will happen when your query is refreshed?
The query will still work, and you’ll have 3 columns: Product, Attribute and Value
The query will fail to refresh since you didn’t cater for this data structure
The query will still work, but you’ll have 23 columns: Product, Attribute, Value and the 20 new columns
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement