Directquery - Study guides, Class notes & Summaries

PowerBI Certification Exam 2023 Verified 100% If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery 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. you're always viewing current data. How do you connect to Excel files that contain target figures? T...

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...

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...

PowerBI Certification Exam 2023 Verified 100% If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery 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. you're always viewing current data. How do you connect to Excel files that contain target figures? T...

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...

PowerBI Certification Exam 2023 Verified 100% If you want your data to automatically refresh as you interact with visualizations, which option should you choose? A) Import B) DirectQuery 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. you're always viewing current data. How do you connect to Excel files that contain target figures? T...

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 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 ...

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 ...

Power BI Certification (2023-2024) | Questions & Answers (100% Correct) Power BI Certification (2023-2024) | Questions & Answers (100% Correct) What lets you connect data to other business applications? - ANSWER - Microsoft Dataverse What lets users connect to pre-wired connections? - ANSWER - PBIDS files What contains sites, document libraries, and folders? - ANSWER - Sharepoint Online What must be used to publish SSAS Tabular live connection data to Power BI Service? - ANSWER - Da...