This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
While in the Transform stage, you realize that you used a value of 2277333 instead of the Shipped value. How would you replace the 2277333 value with Shipped?
Open the data in Excel and use the Find and Replace feature.
Select the column header and then use the Replace values feature of Power Query.
Let everyone on your team know that 2277333 means Shipped because you can't replace values.
During the data ingestion, you discover that some event log rows are missing the timestamp values. You decide to remove all rows that don't show timestamp values. How would you achieve this task?
Use the Remove empty feature of Power Query.
Manually delete all rows that are missing the timestamp value.
Filter out rows that are missing the timestamp values because you can't remove empty values.
You want Dataflow to only load data from a specific time window. What refresh type would you select?
Periodic refresh
Leave the default refresh setting
Incremental refresh
You must answer all questions before checking your work.
Was this page helpful?