Absolute Free PL-300 Exam Practice for Comprehensive Preparation 

You have a query in Power Query Editor that contains the following data.

You need to transform the data to appear as shown in the following table.

What should you do?  

You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique. In powerbi.com, when users load the visual, they only see some of the customers. What is the cause of the issue?

You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company. You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data. Which report setting should you configure?

You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. Solution: You change the semantic model mode. Does this meet the goal? 

You are reviewing a query that produces 10,000 rows in the Power Query Editor. You need to identify whether a column contains only unique values. Which two Data Preview options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.