PL-300 Exam Questions

You have a PBI dataset that gets data from a table in a SQL Server database. From which view in PBID can you modify the storage mode of the table?

Model view Page view is an option available from within the Report view

You need to create a PBI dashboard. Which tool should you use?

The PBI service

You plan to create a report in PBID. You need to create a visualization to display a running total. The solution must meet the following requirements: - The initial and the final value columns must start on the horizontal axis - The intermediate values must be floating columns. Which type of visualization should you use?

waterfall

In PBID, you plan to use M-language to define a common date table spanning a period of 10 years. You need to identify the M language function that would allow you to specify that rows in the table should represent consecutive days within the date range you designated. You solution must minimize administrative effort. Which syntax should you use?

#duration

In PBID, you plan to use M-language to define a common data table spanning a period of 10 years. You need to identify the M language function that would allow you to specify that rows in the table should represent consecutive days within the date range you designated. You solution must minimize administrative effort. Which syntax should you use?

#duration Allows you to specify the datetime values that will be entered into individual rows of a date table.

You manage a PBI workspace in a shared capacity. The workspace contains a dataset named DS1. You plan to schedule a refresh of DS1. What is the number of consecutive refresh failures of DS1 that will automatically disable the refresh schedule?

4

You have a PBI Premium per user workspace. What is the max number of refreshes that can be scheduled each day?

48

You need to create a histogram that will display ranges of integers in groups. Which two resources do you need to create the histogram?

A Bin group type A Numerical column The Bin group type is an auto grouping of items into bucketed bins (groups). A DateTime column isn't required to display histogram type data against a numerical column. A List group type is a manual grouping of items into new group names/categories. It doesn't create auto (binned) groups.

You have the following PQ M formula that generates a range of dates. = List.Dates(#date(2020,05,31), 365, #duration(1,0,0,0)) What is the resulting date range?

A list of days starting on May 31, 2020 and ending 365 days later

You have a PBID PBIX file that contains a single-page report with multiple visuals. You plan to use Performance Analyzer to evaluate the performance of the visuals. You need to eliminate the impact of visual caching during the evaluation. What should you do?

Add a blank page to the PBIX file

You have a PBID PBIX file that contains a single page report with multiple visuals. You plan to use Performance Analyzer to evaluate the performance of the visuals. You need to eliminate the impact of visual caching during the evaluation. What should you do first?

Add a blank page to the PBIX file Connecting DAX studio to the data model is the first step to clear the data engine cache. Recording should not be started until both the visual cache and the data engine cache are cleared.

You implement the Q&A feature in a report, so users can get answers to their questions on their own. You need to improve your Q&A search capabilities for end-users. Which two configurations can you add?

Add a linguistic schema to the dataset. Add synonyms to model fields.

You have a fact table that contains sales data. The fact table includes a SalesDate column formatted as a Date data type. Auto date/time setting is disabled in both global and current file options. You load the fact table into PBID. You need to ensure that you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. You solution must minimize the model size and administrative effort. What should you do?

Add a separate date dimension table. This is the optimal approach which provides the required functionality, while minimizing the model size and administrative effort. Adding year, month, and week columns to the fact table would increase the amount of administrative effort. Enabling the Auto date/time global or current file option would increase the model size. In addition, it would not provide the ability to describe weekly time periods (only year, quarter, month, and day).

You manage a PBI workspace. You need to delegate the task to update workspace metadata. The solution must use the principle of least privilege. Which role should you use?

Admin

You use PBID to transform a query that retrieves data from an Excel spreadsheet. You need to view and modify multiple steps in all the M code. Which interface should you use?

Advanced Editor in the PQE The formula bar in the PQE provides the ability to edit only one step at a time.

You have a collection of datasets and reports. You need to share the datasets and report together. This solution must NOT send any email notifications to internal users after sharing. What should you create in the PBIS?

An app

You upload reports to the PBI service and pin several visuals to a dashboard. You plan to create alerts rules for several visuals. What are two locations you can view the alerts?

An email The Notification Center

You have several on-premises Microsoft SQL Server databases. You need to provide PBIS users access to the data sources without exposing the database servers directly to the internet. The solution must minimize the configurations that must be performed by each user. What should you deploy?

An on-premise data gateway

Your company has a SharePoint server located in a datacentre in Montreal. You plan to create a report in the PBI service that will use Excel files stored on the SharePoint server. You need to recommend a solution to ensure that the dataset for the report can automatically refresh daily. What should you include in the recommendation?

An on-premises data gateway An on-premises SharePoint server requires the use of a PBI gateway since it's an on-premises data source. VPN-based solutions would provide connectivity to an Azure virtual network, but not PBIS. Azure Data Box is a solution for migrating data to Azure, which is not applicable in this scenario.

You create a data model in PBID that contains DAX-calculated columns and measures. You now need to create a report. In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used?

As a filter in the "Filters on this page" well of the Filters pane As an item in the Fields well of a slicer Unlike a measure, a calculated column can be used in a slicer to place filter options on the report page. DAX measures cannot be placed in the "Filters on this page" well. They can only be placed per visual, in the "Filters on this visual" well of the Filters Pane. Both DAX columns and measures may be used as a visual-level filter. Both DAX columns and measures can be used in the drillthrough well.

You are create a report in a PBID by using a dataset that contains sales data. You need to create a measure that always provides the value of total sales for the year 2022, regardless of which year is selected in any visual in the same report. Which DAX function should you use in combination with the SUM function to override the context and provide the result?

CALCULATE

You have a PBID dataset based on a star schema data source. You need to use a DAX to create a date table in the dataset and populate the table with a range of dates based on the earliest and latest date within the dataset. Which function should you use?

CALENDARAUTO

You have a PBI model. You need to assign items to a display folder. Which three items can be assigned to a display folder?

Calculated column Column Measure

You need to enhance a data model by using PBID. Data for which two model items can be created using the DAX language?

Calculated table Numeric range parameter

You need to develop a quick measure in PBID. Which two elements can you use?

Calculations Fields When creating a quick measure in BID, you apply calculations to fields. You do not explicitly create a DAX query, but you choose calculations and fields, which result in automatic generation of a DAX query. Conditional columns are separated from quick measures. Unlike quick measures, they create a value for each row in a table and are stored in the .pbix file. Power Query M functions are not directly accessible from the Quick Measure interface.

You have a PBI dataset. You need to set the dataset as discoverable. Which two configurations will allow the dataset to be marked as discoverable?

Certify the dataset. Promote the dataset A certified dataset can be configured to be discoverable by for users without access to request permissions to access. A promoted dataset can be configured to be discoverable for users without access to request permissions to access. RLS is not required on a dataset to become discoverable. Premium (capacity or shared) is not required to make a dataset discoverable.

You need to make changes to your data sources. Which three changes are supported by the Data Source Settings in the PQ interface?

Clearing permissions Editing permissions Modifying the file path Any structural changes to a file, such as adding, removing, or renaming columns are not supported by the Data Source Settings.

You plan to run PBID Performance Analyzer. You need to ensure that the data engine cache will NOT impact the test results without restarting PBID. What should you do first?

Connect DAX Studio to the data model DAX Studio, once connected to the data model, can be used to clear the engine cache. The Clear Cache function can be invoked from DAX Studio, once you connect it to the data model. The Refresh Metadata function can be invoked from DAX Studio to update the metadata of the currently selected model. Adding a blank page to the .pbix file and selecting it is the first step in clearing the visual cache, not the data engine cache.

You need to add an analytics line to a visual. The value for the line must equal the result of a DAX measure that always returns a consistent single value. The DAX measure must only be used to populate the analytics line. Which type of analytics line should you use?

Constant line

You manage a PBI workspace. You need to delegate the task to schedule data refreshes. The solution must use the principle of least privilege. Which role should you use?

Contributor

You need to implement a solution that meets the following requirements: - The navigation destination must change based on the output of a DAX measure named [Error Rate]. - If [Error Rate] is greater than 5%, the button must display the text "Error Rate" and navigate to the Error Rate page. - Otherwise, the button must display the text "On-time Rate" and navigate to the On-Time Rate page. What three actions should you perform?

Create a DAX measure that outputs the correct page name based on the value of [Error Rate] Set the button type to Page Navigation and then use conditional formatting to specify the destination Use conditional formatting to set the button text. It is not necessary to set the destination to a specific page since conditional formatting is used to specify the destination.

You plan to publish a dataset from PBID. You need to ensure that a server name can be changed after the dataset has been published to the PBIS. Which two actions should you perform?

Create a parameter From the Data source settings, update the server source to use a parameter A parameter is the only part of a query that can be updated or changed in the PBI service, by accessing the dataset settings. Updating the server source to use a parameter will update all existing queries pointing to the current server to instead use a parameter with that server name. This parameter can now be changed once this dataset is published to the PBIS.

You plan to use the calculated table functionality to add a duplicate table in PBID. Which characteristics of the original table will be duplicated?

Data only

In PBID, you need to create a measure. Which two interfaces can you use?

Data view Report view

You need to create a visual that will display info on a continuous axis. Which two data types can be used to display a continuous axis on a visual?

Date Decimal Number Date data types dispaly well on a continuous (range) axis where report users understand chronological order. Number of data types display well on a continuous (range) axis where report users understand the order between min and max values. Binary data and text (categorical) data cannot be displayed on a continuous axis. Date, time, or numbers are the only data types comparable with a continuous axis.

You plan to use PBID to analyze sales data of your company. You need to identify two types of data you will be able to use for creating bins that group the sales data. Which two data types should you identify?

Date/time Numeric

You have a fact table that contains sales data and two date columns: - OrderDate - ShipDate Both columns have a relationship to the Date column, and DAX measures have been configured to use these relationships for calculations related to order or ship dates. You need to ensure the Calendar table doesn't filter the fact table by default unless it is using a DAX measure that uses these relationships. What should you do?

Disable Make this relationship active for both relationships You can have multiple inactive relationships between two tables in PBI datasets. Dax measures can then use the USERELATIONSHIP function to activate a relationship for calculations. Relationship direction is not required for either the relationships or measures to work in this model setup. Only one active relationship can exist between two tables in a PBI dataset. Applying a security filter in both directions isn't required for this model setup.

You need to create a bookmark that toggles the visibility of a visual. This bookmark must only toggle the visibility state and perform no other action. Which three configurations should you make?

Disable the Data option Disable the Current Page option Enable the Display option

You create a PBI data source which uses a SQL SELECT statement. The statement queries multiple tables in a server database and includes subqueries. When importing the data you get the error message: "Timeout expired"." You verify it is not the network connection and there is good bandwidth and low latency. You need to minimize the occurrences of the issues indicated by the message. What should you do?

Divide the SQL statement into separate data sources.

You have a PBI model with the following fact tables and storage modes. - FactStoreSales (Import mode) - FactOnlineSales(DQ mode) You have a dimension table named DimCalendar that has a relationship to both fact tables. You need to assign a storage mode for DimCalendar. The solution must minimize the time to execute queries that combine data from the dimension table and the fact tables. Which storage mode should you use?

Dual

You need to prevent hidden date tables from being auto generated by PBID for every date or datetime data type column in a dataset. What two tasks should you perform?

Enable Mark as date table for the Calendar table. From the Current File options in PBID, disable Auto Date/Time

You need to create a custom Python visual by using PBID. What do you need to do first?

Enable the script visuals option in the visualization pane of PBID. Installing Python is not required. Configuring global Python scripting options in PBID is not required to create Python visuals. The ability to create a custom Python visual by using PBID has no dependency on enabling preview features.

You have a PBID model. You need to determine when to use implicit and explicit measures. What is a feature of an implicit measure that explicit measure does NOT have?

End-users can change the aggregation type of implicit measure from the Values well of a visual. Implicit measures can select from one of nine aggregations when placed in the Values well of a visual. Both Implicit and Explicit measures can be used as a Drillthrough field, to create quick measures, and with Field Parameters.

You are editing a report in PBID. You need to adjust the behavior of the report by editing interactions. Which two types of interaction behavior can you change between visuals?

Filter Highlight A filter will show you filtered data in this visual. Highlight is the default interaction between visuals. It shows you both unfiltered and filtered values in the visual, for comparison purposes.

You have a bar chart and a column chart visual on a report page. Selecting any column from the bar chart visual filters the column chart data to less than 1% of its unfiltered value. Which type of visual interaction should be used when the bar chart is filtering the column chart to ensure that you can easily see the data?

Filter It will show you the filtered data in this visual. So even when showing filtered data that is less than 1% of the unfiltered value, it will still display well in the column visual.

You need to create a new hierarchy in PBID. What should you do first?

From the Model view, right-click and select Create hierarchy.

You have a query that retrieves data from a table that contains more than 8,000 rows of data. In PQE, you notice that the column stats for each column shows a count of exactly 1,000. You need to ensure that the column stats for each column shows the stats based on all rows that are returned by the query. What should you do?

From the query window, select Column profiling on the entire dataset.

You are analyzing query data by using PQE. You need to ensure that the Column statistics are based on an analysis of the entire dataset. What should you do?

From the status bar, change profiling status to entire dataset.

You plan to create a report in PBID that will display sales opportunities by five sales stages, including lead, prospect, qualified, committed, and transacted. You need to identify the type of visualization that will display a linear process with sequentially connected stages, with one stage transitioning to the next. Which visualization should you use?

Funnel

You decide to start using variables when creating DAX formulas. What are two benefits of using variables in DAX measures over using original expressions?

Improves the overall performance of the resulting DAX measure Improves the overall readability of the resulting DAX measure Variable names are often shorter than the original expressions, and the final variable names included. Varaibles cache the defined calculation, allowing it to be referenced multiple times without additional impacts from recalculations. The function in DAX are universal, and there are no specific functions that can only be used within variables. The data source connection is set in the model and cannot be changed from within a DAX measure

You manage a PBI workspace in shared capacity. The workspace contains a report that uses a dataset named DS1. You need to implement an incremental refresh of DS1. What should you do first?

In PBID, define filter parameters

You need to create a RLS role for a dataset. What should you do first?

In PBID, open Manage roles

When importing data from an Excel workbook into PBI, you receive the error message: "We couldn't find any data formatted as a table." What should you do to resolve the error?

In the Excel workbook, select the data you want to import, create a table, and save the change.

From PBID, you create a data source by importing an Excel file that contains 10,000 rows. You plan to identify data anomalies within the data source. You need to ensure that column distribution considers all rows in the Excel file. What should you do?

In the PQE window, enable the Column Profile view.

From PBID, you create a data source by importing an Excel file that contains 10,000 rows. You plan to identify data anomalies within the data source. You need to ensure that column distribution considers all rows in the Excel file. What should you do?

In the PQE window, enable the Column Profile view. By default, PBI uses the top 1,000 rows for profiling. To ensure column distribution considers all rows in the Excel file, you need to modify the PQE profiling status setting. The PQE settings, Advanced settings, and Permissions settings have no bearing on the profiling characteristics.

You have implemented RLS that restricts access to a PBID dataset for users who are assigned the role named Salespeople. You need to validate that the implementation works. What should you do?

In the Report view, activate the View as feature

You are using PBID to edit a stacked column chart that displays gross sales data with a date hierarchy that contains a year, quarter, month, and day. You need to prevent users from viewing the hierarchy based on the year. What should you do?

In the Visualizations pane, remove the year field from the date hierarchy fields in the X-axis.

You decide to remove unnecessary columns from your data model. What are two potential performance benefits of doing this>

Increasing the refresh speed Reducing the size of the data model

You need to create a custom R visual by using PBID. What do you need to do first?

Install R on your computer.

You have created a PBI dataset and need to create multiple reports. What is a benefit of using a PBI dataset as a data source for multiple reports compared to each report having a separate dataset?

It reduces the number of datasets, refreshes, and storage requirements in the PBIS

You have created a PBI dataset and need to create multiple reports. What benefit of using a PBI dataset as a data source for multiple reports compared to each report having a separate dataset?

It reduces the number of datasets, refreshes, and storage requirements in the PBIS.

You are creating a PBI dashboard. You need to apply a custom theme to the dashboard from another PBI dashboard theme. Which type of file should you use?

JSON

Which native AI visual helps explain correlations for a metric within the dataset?

Key influencers visual

You have a PBID dataset that includes a table named Warehouse. The Warehouse table includes a column named Inventory Count, which contains the current number of items for each row of a particular type on a given day. You have the following DAX query that calculates the sum of all values in the inventory Count column of the Warehouse table: - Current Inventory Count = CALCULATE(SUM('Warehouse'[InventoryCount])) You need to ensure that Current Inventory Count returns only the current total number

LASTDATE Ensures that the SUM function applies only to the last date of the time period, resulting in a semi-additive behavior. The DISTINCTCOUNT function counts the number of distinct values in a column, which results in additive behavior.

You are designing a data model in PBI. You need to avoid introducing ambiguity into your data model design. Which type of cardinality should you avoid?

Many-to-many

You have a designed a star schema to simplify you data. You need to understand the relationship between the tables in the star schema. What is the relationship between the fact table and dimension tables?

Many-to-one For each row in a dimension table there may be multiple matching rows in the fact table.

You plan to create a report in PBID. You need to create a visualization that displays data in two or more dimensions and cross-highlights with other visuals on the same report page. Which type of visualization should you use?

Matrix

You plan to build a PBI report and set up conditional formatting of data fields. You need to identify two visuals that support the conditional formatting functionality. Which two types of visuals should you identify?

Matrix Table

You have a PBI data source that contains the following tables: - ProductCategory: Lists the product category ID and category name - ProductSubcategory: Lists the product subcategory ID, subcategory name, and the related category ID - ProductList: Lists the product ID, name, and subcategory ID You need to optimize the data to create a dimension for use in a star schema data model. How should the tables be transformed before leading into the model?

Merge the queries to create a single loaded table for Product

Azure SQL database with two tables: SalesOrders and SalesOrderDetails The tables have a relationship based upon the SalesOrderID column You must combine the two tables. The solution must meet the following requirements: - Row for every SOD row in table, even if no corresponding SO row. - Every SOD row includes the corresponding SO row data in table if it exists. - Any SO row without corresponding SOD rows isn't in result table. What should you do to combine the two tables.

Merge the tables using the left outer join kind based on the sales order id.

You plan to add data to a PBID from a new data source. You are evaluating whether you should use the DQ storage mode or the Import storage mode. What are two benefits of using DQ instead of Import?

Minimized local disk space usage Minimized need for data refresh

You create a PBID dataset by importing and transforming a data source based on multiple tables in a SQL Server database. You need to modify the relationship between the tables. Which interface should you use in PBID?

Model view

In PBID, you need to create a role. Which two interfaces can you use?

Model view Report view

You plan to get data for a PBI 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?

OneDrive for Business SharePoint - Team Sites A personal OneDrive account provides the ability to automatically synchronize flat files residing in a user's OneDrive and PBI datasets. Since it relies on OneDrive access, it requires the user's credentials of hte corresponding Microsoft account. The OneDrive for Business option uses Azure Active Directory credentials. The SharePoint - Team Sites option uses the same Azure Active Directory credentials as the ones used to access SharePoint Online. For the local file option, no additional credentials are required to access them.

From PBID, you create a data source by importing a Cosmos DB for NoSQL item collection. You connect to the Cosmos DB account, database, and collection, but the preview displays only a list of items named Record. You need to select individual fields from items in the collection that you want to load into PBID. What should you do first?

Open PQE

You need to create a dashboard from a published report in PBI. Which option in the report should you use?

Pin Visual

From PBID, you create a data source by importing an Excel file. You plan to identify data anomalies within the data source. Which interface should you use to display the column distribution and column quality graphs?

Power Query Editor

You need to reduce the cardinality of a column in a PBI dataset. What should you do?

Reduce the number of distinct values

You have a table that contains a column named ProductID. The ProductID column contains values that have a prefix of PD followed by five numbers.. You plan to convert the ProductID values to numbers. You need to remove the leading two letters from the current ProductID values. Which command should you use?

Replace Values

You plan to create a report in PBID that will display the relationship between the number of orders and the number of orders shipped by product category. You need to identify the visual that will clearly identify outliers in the data set by displaying them away from the bulk of data. Which visual should you use?

Scatter

You need to create a report in PBID that will display the sales data of your company such that customers of a similar age will be grouped into clusters. Which visual should you add to the report?

Scatter Creating a scatter visual is the first step of applying the clustering technique that groups data into clusters. Card, gauge, and treemap visuals do not support clustering.

You have a query that has a column named Country and columns for each month of sales data. The names of the sales data columns use the format of Month Year. The month columns contain the Sales Amount values for each month. You need to reshape the table to have all sales amount values in a single column. A new column should also be added and contain the relevant month year for each row of data. What should you do from the PQE

Select the Country column and then select Unpivot Other Columns. This will unpivot all current and future month/year columns into a new sales data column. Transposing will not create a single sales data column. Selecting Unpivot Columns in the first sales data column will successfully unpivot these columns into a new single column for sales data, but other sales month/year columns will not be included in the new sales column. Pivoting takes values on rows in a column and turns them into new columns.

You are designing a data model for PBID. You need to reduce the model size. Which technique should you use to reduce the model size?

Set the Storage Mode property of tables to DQ. It reduces the model size since only schema of the data source is stored locally.

You have multiple Excel files stored in a folder synced with OneDrive for Business. You need to import data from the files. The solution must NOT use a data gateway. Which type of connector should you use?

SharePoint folder The only connector that will allow the import of multiple Excel files stored in a OneDrive for Business folder, without using a data gateway. While you can connect to the folder on an on-premises device, it would require a data gateway to refresh in the service. An Excel workbook would only connect to a single Excel file and would also require a data gateway. A SharePoint list connector only connects to SharePoint lists and cannot connect to Excel files.

You plan to get data from flat files for a PBI dataset. You need to select a location to store the files. Which location requires an on-premises data gateway?

Shared folder on a local network

You plan to use PBID to create a report with multiple visualizations. You need to create a visual that supports the following: - Filters other visuals on the same report page - Allows users to search for values by which to filter the other visuals. Which type of visualization should you use?

Slicer

You plan to use PBID to analyze sales data for products sold by your company. You need to create a DAX formula that will list 10 best-selling products sorted by their total sales. Which DAX function should you use?

TOPN The MAXA function returns the largest value in a column. The MAXX function evaluates an expression for each row and returns the largest value The RANKX function returns ranking of a number in a list of numbers for each row of a target table.

You plan to certify a PBI dataset. You need to identify at which level within your organization the permissions to certify a dataset are assigned. Which level should you identify?

Tenant

You have a visual that is being cross-highlighted. By default, what data will be displayed in a report tooltip?

The filtered (cross-highlighted) data Report page tooltips need to be manually created and are not assigned to a visual by default.

You import an Excel file into PBID and begin to analyze the data in PQE. You need to identify outliers in a text column within the data source. Which info should you use from PQE?

The top and bottom entries in Value distribution They identify outliers, which appear, respectively, the greatest and smallest number of times in that column. The value of the Distinct entry in Column stats indicates the total count of different values. The value of the Unique entry in Column stats indicates teh total count of different values that appear only once. The min and max values in the Column profile of a text column designate the entries which appear first and last in alphabetical order.

You need to use DAX quick measures to generate results to use in a report. Which type of DAX quick measure calculations will NOT work against a DQ table?

Time intelligence They have performance implications and are disabled for quick measures against DQ tables. Mathematical operations, aggregate per category, and X-functions are all supported against DQ.

You plan to create a report in PBID. You need to identify the type of visualization that displays data as a set of nested rectangles. Which visualization should you use?

Treemap

You have a RLS role in a dataset called User Security Group. This role needs to filter a RLS table that contains a column with the emails of users in the following format: - [email protected] Which function should be used in the code for the RLS role to match the users Microsoft Entra ID login credentials with the emails contained in the RLS table column?

USERPRINCIPALNAME

An Excel spreadsheet contains Year, 2021, and 2012 columns. The entries in the first column are names of the months in a year. The other two columns contain sales amount each month for corresponding year. You import data into PBID. You need to transform the data so it will consist of three columns, with the first one containing month, the second containing year, and the third containing the sales amount for that month and year. Which transformation should you use first?

Unpivot It will allow you to shape the current table into the one with the year, month, and sales amount columns, which will need to be renamed afterwards. Pivot would be applicable in the opposite scenario, in which flat data needs to be reorganized into one containing aggregate values for each unique value in each column. Transposing would switch rows and columns. Removing columns would result in a table with insufficient data to perform unpivot.

You create a PBI data source which uses a SQL SELECT statement. The SQL statement queries multiple tables in a SQL Server database and includes subqueries. After you import data from the data source into PBI, you notice that one of the columns in the resulting dataset appears blank. You verify that the source table does include data. What should you do to resolve the issue?

Use the CAST function in the SQL statement the issue indicates that PBI is incorrectly interpreting the data type used by the source column. To resolve it, you need to explicitly specify the intended data type, which can be done by using the CASE function. DATALENGTH displays the number of bytes used to represent an expression. Clearing permissions could prevent PBI from being able to access the target database. Setting the privacy levels of the data source would have no impact on addressing the issue of missing data.

You have PBID. You need to determine query timings for a report page visual. Which method should you use?

Use the Performance Analyzer

You connect PQE to a database table. You need to remove the Row ID column. Your solution must ensure that new columns do NOT display in the table model during a scheduled refresh in the future. What transformation should you use?

Use the Select Columns command and choose the columns to keep.

You need to assign an app workspace role for users who consumer reports. Users should only have permissions to examine the report. Which role should you assign to users?

Viewer role

You plan to create a PBI workspace. You need to ensure that you will be able to configure a Microsoft 365 group whose SharePoint Online document library is available to workspace users once the workspace is created. Which setting should you configure when creating the workspace?

Workspace OneDrive The Allow contributors to update the app for this workspace setting is meant to provide additional permissions for workspace contributors. The Develop a template app setting allows you to choose between Pro, Premium per users, Premium per capacity, and Embedded licensing.

You plan to optimize the performance of PBID queries against a remote data source. You need to disable the default behavior that automatically applies cross highlighting and filtering of visuals within the same report. Which option should you configure in PBID?

the Reduce number of queries sent by Query reduction setting The Slicers Query reduction settings allow you to instantly apply slicer changes and add an Apply button to each slicer. The Filters Query reduction settings allow you to instantly apply basic filter changes. The Persistent filters of Report settings allow you to prevent users from saving filters in the PBIS.