PL-300 Exam Question 131

You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power Bi dataset
You need to ensure that the dataset can be refreshed in powefbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
  • PL-300 Exam Question 132

    You have a Microsoft Power Bl dashboard.
    You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.
    What should you use?
  • PL-300 Exam Question 133

    Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • PL-300 Exam Question 134

    You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains the following columns:
    * Customer ID
    * Customer Name
    * Phone
    * Email Address
    * Address ID
    Address contains the following columns:
    * Address ID
    * Address Line 1
    * Address Line 2
    * City
    * State/Region
    * Country
    * Postal Code
    Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. You need to create a query that has one row per customer. Each row must contain City. State/Region, and Country for each customer. What should you do?
  • PL-300 Exam Question 135

    You have a query that returns the data shown in the following exhibit.

    You need to configure the query to display the data as shown in the following exhibit.

    Which step should you use in the query?