Directquery - Study guides, Class notes & Summaries

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

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

You have a Power BI Desktop dataset that includes a table named Salesperson. The table includes a column named UPN. UPN contains the user principal name of the salesperson's Microsoft Entra ID account. You need to ensure that each salesperson will only be able to see the rows in the Salesperson table where the UPN column value matches their User Principal Name. Which two actions should you perform? Each correct answer presents part of the solution. Add a DAX expression to filter to the S...

Power BI 70-778 - Exam Review | Questions & Answers (100% Verified) Power BI 70-778 - Exam Review | Questions & Answers (100% Verified) 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? - ANSWER - 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 sa...

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