You create the following step by using Power Query Editor.
=
Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine 1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column .
What will the value be when the step is applied?
HOTSPOT
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?
You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization .
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
