You have the CSV file shown in the following table.
You use Power Query Editor to preview the data in the file.
You need to transform the data to meet the following requirements:
* The first column must contain the month.
* The second column must contain the year.
* The third column must contain the order amount for the month and year.
Which transformation should you use first?
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged
contains the date and time each compliant occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?
You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?
With Power BI Desktop, when you connect to your data source, it's always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.
DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you're always viewing current data.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order. What should you configure in Microsoft Power Bl Desktop?
If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools
You create a Power Bl report1 named Summary1 You discover that Summary1 is slow.
You run Performance analyzer to identify performance metrics for Summary1
Which two metrics display the execution duration in Performance analyzer* Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.
