Directquery - Study guides, Class notes & Summaries
Looking for the best study guides, study notes and summaries about Directquery? On this page you'll find 47 study documents about Directquery.
Page 3 out of 47 results
Sort by
![Power BI Pl300 Certification Test | Complete Questions & Answers (100% Correct)](/docpics/3413670/64feb3badeb73_3413670_121_171.jpeg)
-
Power BI Pl300 Certification Test | Complete Questions & Answers (100% Correct)
- Exam (elaborations) • 72 pages • 2023
-
Available in package deal
-
conceptialresearchers
-
- $13.99
- + learn more
Power BI Pl300 Certification Test | Complete Questions & Answers (100% Correct) 
Power BI Pl300 Certification Test | Complete Questions & Answers (100% Correct) 
 
You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.) 
The data has the following refresh requirements: 
 Customer must be refreshed daily. 
 Date must be refreshed once every three years. 
 Sales must be refreshed in near real time 
. SalesAggregate must be refreshed once per week. You need to select th...
![PL-300 Exam Questions with Verified Answers Latest Update 2025 Graded A+](/docpics/7257804/67aec17f746f9_7257804_121_171.jpeg)
-
PL-300 Exam Questions with Verified Answers Latest Update 2025 Graded A+
- Exam (elaborations) • 42 pages • 2025
-
TutorJosh
-
- $9.89
- + learn more
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...
![PL 300: Power BI MS Data Analyst practice exam questions fully solved & updated](/docpics/4456991/65c5ba47bffc3_4456991_121_171.jpeg)
-
PL 300: Power BI MS Data Analyst practice exam questions fully solved & updated
- Exam (elaborations) • 7 pages • 2024
-
GUARANTEEDSUCCESS
-
- $16.49
- + learn more
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...
![PL-300 PowerBI Exam Questions and answers already graded A+ 2024](/docpics/4457112/65c5bf2981b76_4457112_121_171.jpeg)
-
PL-300 PowerBI Exam Questions and answers already graded A+ 2024
- Exam (elaborations) • 33 pages • 2024
-
GUARANTEEDSUCCESS
-
- $15.99
- + learn more
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...
![DA-100 All Possible Questions and Answers 2025](/docpics/6520213/6721280d7c673_6520213_121_171.jpeg)
-
DA-100 All Possible Questions and Answers 2025
- Exam (elaborations) • 6 pages • 2024
-
ACADEMICMATERIALS
-
- $8.39
- + learn more
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 Prep 2 with 100% correct answers](/docpics/4457317/65c5c7a13c246_4457317_121_171.jpeg)
-
PowerBI Certification Exam Prep 2 with 100% correct answers
- Exam (elaborations) • 12 pages • 2024
-
GUARANTEEDSUCCESS
-
- $15.49
- + learn more
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+)](/docpics/3413833/64fec1112e330_3413833_121_171.jpeg)
-
Microsoft Power BI 70-778 Certification Exam | Questions & Answers (Rated A+)
- Exam (elaborations) • 18 pages • 2023
-
Available in package deal
-
conceptialresearchers
-
- $10.99
- + learn more
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...
![Power BI Essential Training exam with complete solutions](/docpics/4457426/65c5cb3588355_4457426_121_171.jpeg)
-
Power BI Essential Training exam with complete solutions
- Exam (elaborations) • 13 pages • 2024
-
GUARANTEEDSUCCESS
-
- $15.99
- + learn more
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...
![PL-300 MIcrosoft Power BI Certificate Exam with complete solutions 2024 latest update](/docpics/4457272/65c5c67ceffec_4457272_121_171.jpeg)
-
PL-300 MIcrosoft Power BI Certificate Exam with complete solutions 2024 latest update
- Exam (elaborations) • 65 pages • 2024
-
GUARANTEEDSUCCESS
-
- $17.49
- + learn more
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 ...
![Microsoft Power BI 70-778 Certification Exam questions fully solved & updated 2024](/docpics/4456808/65c5b4e3d9ebc_4456808_121_171.jpeg)
-
Microsoft Power BI 70-778 Certification Exam questions fully solved & updated 2024
- Exam (elaborations) • 23 pages • 2024
-
GUARANTEEDSUCCESS
-
- $14.49
- + learn more
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 ...
![Verkoop je kennis op stuvia](https://www.stuvia.com/hosted-imgs/app/stock-fotos/banner_seller_big.jpg)
Did you know that on average a seller on Stuvia earns $82 per month selling study resources? Hmm, hint, hint. Discover all about earning on Stuvia