You build a report to analyze customer transactions from a database that contains the tables shown in the following table.
You import the tables.
Which relationship should you use to link the tables?
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 two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)
Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You attempt to publish a Microsoft Excel file to Power BI, and you receive the error message shown in the exhibit. (Click the Exhibit button.)
The file is in c:\data\.
You need to ensure that you can publish the file to Power BI.
What should you do first?
