How should you configure the connection to the data source?

Correct Answer for the Question – How should you configure the connection to the data source? is given below You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users in your organization.The … Read more

What should you include in the recommendation?

Correct Answer for the Question – What should you include in the recommendation? is given below Your company has a security policy stating that proprietary data must not be transferred over the Internet.During a security audit, auditors discover that executives use the Power BI service for reporting.You need to recommend a solution to ensure that the … Read more

What should you do in the model before you create the relationship?

Correct Answer for the Question – What should you do in the model before you create the relationship? is given below You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart.The date value in ActivityDate is a number column named … Read more

Which DAX formula should you use?

Correct Answer for the Question – Which DAX formula should you use? is given below You have a Power BI model that contains the following two tables:Assets (AssetID, AssetName, Purchase_DateID, Value) Date (DateID, Date, Month, Week, Year)The tables have a relationship. Date is marked as a date table in the Power BI model.You need to create … Read more

What should you install first?

Correct Answer for the Question – What should you install first? is given below You need to create a custom visualization for Power BI.What should you install first?References: https://docs.microsoft.com/en-us/power-bi/service-custom-visuals-getting-started-with-developer-tools jQuery Node.js Microsoft Azure PowerShell Microsoft.NET Correct Answer The Correct Answer for this Question is Node.js Explanation The Question – What should you install first? has been … Read more

Which DAX function should you use?

Correct Answer for the Question – Which DAX function should you use? is given below You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales.You need to compare the year-to-date sales with the previous year for the same time period.Which DAX function should you use?References:https://powerpivotpro.com/2016/01/year-to-date-in-previousprior-year/ DATEADD TOTALYTD DATESYTD … Read more

What should you do before you publish the report?

Correct Answer for the Question – What should you do before you publish the report? is given below You are creating a Power BI Desktop report that has several bar charts and a date slicer.You need to create a slide show that can be viewed from the Power BI service. Each slide must display the charts … Read more

What should you do to resolve the issue?

Correct Answer for the Question – What should you do to resolve the issue? is given below You have a Power BI Desktop project that uses DirectQuery to access an on-premises Microsoft SQL Server database.From Power BI Desktop, you can query the database.When you publish the Power BI Desktop project to the Power BI service, the … Read more

Which command should you use?

Correct Answer for the Question – Which command should you use? is given below You have the following two queries in Power BI Desktop:• A query named Query1 that retrieves a table named SMB_Customers from a Microsoft SQL Server database• A query named Query2 that retrieves a table named Enterprise_Customers from an Oracle Server databaseBoth tables … Read more