Directquery - Study guides, Class notes & Summaries

PowerBI Certification Exam (2023) | Questions & Answers (Graded A+) PowerBI Certification Exam (2023) | Questions & Answers (Graded A+) If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery - ANSWER - B) DirectQuery Explanation: When you use DirectQuery, no data is imported into Power BI Desktop. As you create or interact with a visualization, PowerBI Desktop queries the underlying data source, i.e. ...

PL-300 Exam Questions with Verified Answers Latest Update 2025 Graded A+ Import the data to Power BIl Desktop. Create a role definition Publish the report Assign users to the role - Answers 123 Conditional formatting: Format by: - Answers Background color Rules Customer: Date: Sales: SalesAggregate: - Answers Dual Dual DirectQuery DirectQuery You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.You need t...

D (Visual2 and Visual5) You plan to embed multiple visualization in a public website. Your Power BI infrastructure contains the visualizations configured as shown. Visual1; characteristic: Uses row-level securitv (RLS) Visual2; characteristic: Uses a dataset that is stored in Microsoft OneDrive for Business Visual3; characteristic: Contained in a report that was shared to your user account Visual4; characteristic: Is a custom visual Visual5; characteristic: Uses a dataset from an on-premis...

Which query language do you use to extract data from Microsoft SQL Server? DAX T-SQL MDX T-SQL You're creating a Power BI report with data from an Azure Analysis Services Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect? Connect Live Import Direct Query Connect Live What can you do to improve performance when you are getting data in Power BI? Only pull data into the Power BI service, not Power B...

The table has a datetime column named Date. You need to reduce the size of the data model. - ️️Split the Date column into two columns, one that contains only the time and another that contains only the date. >Increase compression abilities You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity. - ️️Visualization: A scatter plot of Quality Ordere...

You plan to get data for a Power BI dataset from flat files. You need a location type to store the files. The date must NOT automatically synchronize between the original file and the dataset. Which location type should you recommend? Local File The local file option will result in importing the file contents without providing automatic synchronization between the original file and the dataset. SharePoint - Team Sites, personal OneDrive accounts, and OneDrive for Business provide the abili...

Microsoft Power BI 70-778 Certification Exam | Questions & Answers (Rated A+) Microsoft Power BI 70-778 Certification Exam | Questions & Answers (Rated A+) You have a Power BI model for sales data. You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period. Which DAX function should you use? a) PARALELLPERIOD b) SAMEPERIODLASTYEAR c) DATESYTD d) PREVIOUSYEAR - ANSWER - c) DATESYTD You have a Power BI report...

Role Hierarchy ADMN, Member, Contributor, Viewer Admin Role All responsibilities Member Role Same as Admin but cannot assign roles, delete workspaces, or change metadata Contributor Role Can create, update, and publish and set refreshes for content and reports but cannot publish apps, delete reports change metadata or assign roles Viewer Role Can only view information Auto Date Hierarchy Day, Month, Quarter, Year Lineage View Shows last refresh an...

You have a Power BI model for sales data. You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period. Which DAX function should you use? a) PARALELLPERIOD b) SAMEPERIODLASTYEAR c) DATESYTD d) PREVIOUSYEAR c) DATESYTD You have a Power BI report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category. You ...

You are planning to configure the relationship between Chart of Accounts and Predicted Sales to meet the security requirements. You need to be able to apply the security filter in both directions. What should you do? Set the Cross filter direction option to Both You need to create a table containing unique countries, and a table of unique combinations of countries and territories. Which DAX expressions should you use? Country = VALUES ('Predicted Sales '[Country]) Territory ...