Demonstrate the capabilities of Power BI

A sales manager wants to create a dashboard that shows sales by region and product category. The data is stored in an Excel file that is updated weekly. What is the most efficient way to ensure the dashboard reflects the latest data?

A company uses Power BI to monitor manufacturing efficiency. The dataset includes a column 'RunTime' (in minutes) and 'DownTime' (in minutes). A user wants to calculate 'Availability' as (RunTime / (RunTime + DownTime)) * 100. Which DAX measure should be used?

A financial analyst creates a Power BI report to compare quarterly revenue across years. The data has a 'Date' column and a 'Revenue' column. The analyst wants to display year-over-year growth for each quarter. Which visual and configuration would best achieve this?

A marketing team wants to share a Power BI dashboard with external stakeholders who do not have Power BI licenses. Which sharing method should the team use?

A data analyst notices that a Power BI report takes a long time to load when filtering by a specific date range. The data source is a SQL Server view that contains millions of rows. What is the most effective way to improve performance?

Which TWO of the following are valid ways to connect to data in Power BI Desktop?

Which THREE of the following are features available in Power BI Premium per capacity? (Select three.)

Refer to the exhibit. The JSON represents a Power BI dataset refresh configuration. After deployment, the refresh fails with an error indicating that the data source credentials are missing. Which step must be taken to resolve the issue?

Refer to the exhibit. A Power BI report connecting to the SalesDB database is slow. The exhibit shows a SQL Server activity snapshot. What is the most likely cause of the performance issue?

You are a data analyst at a manufacturing company that uses Microsoft 365 and Power BI. The company has a Power BI tenant with Free, Pro, and Premium Per User (PPU) licenses. Your team has created a Power BI report that visualizes production line efficiency from a SQL Server database on-premises. The report is published to a workspace assigned to a PPU capacity. You need to ensure that all 50 users in the production department can view the report on their mobile devices, with data refreshing every 30 minutes. The users have a mix of Free and Pro licenses. The report uses DirectQuery mode to the on-premises SQL Server. You have configured an on-premises data gateway in personal mode. Users report that the report is slow and sometimes fails to load. What should you do to improve performance and reliability while meeting the refresh requirement?

Refer to the exhibit. A Power BI developer imported the JSON data into a Power BI data model. When creating a report, they notice that the 'Sales' table does not display the product name. What is the most likely cause?

Which TWO actions are supported by Power BI to share a report with external users who do not have an Azure Active Directory (Azure AD) account in the tenant?

You are a Power BI administrator for a retail company. The sales team uses a Power BI report that connects to an on-premises SQL Server database via an on-premises data gateway. Recently, several users reported that the report is showing stale data. The report is configured to refresh daily at 8:00 AM. Upon investigation, you find that the scheduled refresh failed last night at 8:00 AM with an error: 'The data source credentials could not be encrypted using the gateway's encryption key.' The gateway is installed on a server that was rebooted for maintenance at 7:30 AM. The gateway service account is a local service account. The data source credentials were configured using a SQL Server authentication login. What should you do to resolve the issue?

Drag and drop the steps to create a connection between Power Automate and a third-party service like Office 365 in the correct order.

Match each Power Automate trigger type to its description.