Directquery - Study guides, Class notes & Summaries

You have a custom connector that returns ID, From, To, Subject, Body, and Attachments for every email sent during the past year. More than 10 million records are returned.You build a report analyzing the internal networks of employees based on whom they send emails to.You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.What should you do? A. Implement row-level security (RLS) so that the report recipients can only see results based o...

What are some of the data sources you can use in PBI? Flat files & Folders (csv, text, excel, json, etc). Databases (SQL Access, Oracle, IBM, MySql, etc.). Power Platform (Dataflows, Power BI Datasets, Datavers3, etc). Azure (SQL Db, Blob Storage, Cosmos DB, Data Lake Storage, etc). Online Services (Sharepoint, Github, Dynamics 365, Google Analytics, Salesforce, etc). Others (web feeds, R scripts, Spark, Hadoop, etc.). What let's you shape and transform data? Query editor What is Po...

PL-300: Microsoft Power BI Data Analyst Questions and Answers 100% Accurate Question #14Topic 1 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? A. Add a SQL statement. B. Set the Command timeout in minutes setting. C. Set Data Connectivity mode to Import...

You are implementing Dynamics 365 Finance and evaluating reporting capabilities. The solution must allow business users to view cash flow forecasts as follows: by region across all legal entities in a graphical representation from within Dynamics 365 Finance You need to select a tool to allow the business users to view the cash flow forecasts. Which tool should you use? Power BI embedded workspace A company delivers seafood to retail stores. Refrigeration trucks send temperature an...

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 and can identify st...

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

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

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 to select a location for the files. The location must provide the ability to configure scheduled refresh for the dataset by using Microsoft 365 credentials. Which two location types should you recommend? Each correct answer presents a complete solution. Select all answers that apply. a. local file b. OneDrive for Business c. Personal OneDrive account d. SharePoint - Team Sites b. OneDrive for Business d. SharePoint - ...

Power BI Certification () | Questions & Answers (100% Correct) Power BI Certification () | 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 - Data Gateway What...