What is the minimum number of datasets and storage modes required to support the reports?

You have a Power B1 dataset named Finance that is hosted in a Power B1 workspace.

The finance team at your company is NOT currently a member of any Power B1 workspace roles.

You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset.

What should you do?

You are creating a report in Power BI Desktop. You load a data extract that includes a free text field named coll. You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model. What should you do?

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:

First name

Last name

Email address

State/Region

Phone number

You import the list into Power Query Editor.

You need to ensure that the list contains records for each State/Region to which you want to target a marketing

campaign.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You have a Power B1 report named ReportA. You have a Power B1 tenant that allows users to export data. You need to ensure that consumers of ReportA cannot effort any data from visuals. Which two actions should you perform? Each correct answer presents a complete solution. NOTE Each correct selection is worth one point.