Easy PL-300 practice questions

You manage a Power BI workspace that contains several reports and a shared semantic model for the finance team. A group of business analysts needs to open and interact with the existing reports (using slicers and filters) but must not be able to edit, delete, publish, or reshare any content. You want to grant this access with the least privilege while assigning a single workspace role. Which workspace role should you assign to the analysts?

You import a supplier delivery table into Power Query. Before building the model, you want a quick per-column indicator that shows what percentage of rows in the preview are valid, contain errors, or are empty, so you can decide which columns need cleaning first. Which Power Query feature should you enable in the View ribbon to see this at a glance?

You import a CSV export from an accounting system into Power Query. The first data row contains descriptive labels like 'Acct No', 'Cost Center', and 'Amount', but Power Query has assigned generic names such as Column1, Column2, and Column3 to each column instead of using those labels. You need the query to use the descriptive labels as the column headers with the fewest steps. What should you do?

You are designing a Power BI report with a bar chart comparing sales across five product categories. Stakeholders complain that the categories appear in a random order, making the chart hard to read, and they want the highest-selling category displayed first. Which action should you take to satisfy this request without changing the underlying data model?

You are cleaning a customer table in Power Query Editor. Your manager asks you to quickly see, for every column at once, the count and percentage of valid values, errors, and empty values before you decide which columns need remediation. Which single feature should you enable to display this summary across all columns simultaneously?