The Import storage mode is fully supported with the Q&A and Quick Insights Power BI

services. The Import storage, unlike DirectQuery, does not minimize local disk
space usage and does not eliminate the need for a data refresh. Both the
DirectQuery and Import storage modes support per table configuration

Using the Choose Columns and Remove Other Columns options will allow you to
explicitly select the columns that you want to keep. This enforces the requirement
that new columns will not be automatically added in the future. Using Remove
Columns will delete the existing columns in the table, and new columns that get
added in the future will still be imported automatically. Transpose treats rows as
columns, and columns as rows. It will not limit the number of columns being
imported.

When multiple reports use the same Power BI dataset vs each having their own import
model, you reduce the number of datasets that are needed to be published to the
Power BI service. Fewer datasets mean fewer refreshes, less storage space
requirements, and less overhead for admins.

The Pin visual option allows you to pin the visual to an existing dashboard or
create a new one. The Copy visual as image option allows you to copy a visual as an
image to Clipboard. The Export data option allows you to export data in the xlsx or
csv formats, but not create a dashboard. The Spotlight option allows you to
highlight a visual on the report page, but not create a dashboard.

The maximum number of refreshes per day for a Power BI workspace in a shared
capacity is 8.
If there are 4 consecutive data set refresh failures, the refresh schedule will be
automatically disabled.

The Admin role is the only one that has the permission to update workspace
metadata.

A certified dataset can be configured to be discoverable 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.

Disabling Auto Date/Time for new files from the Current File options will disable
all Auto Date/Time tables in this dataset. Enabling Mark as date table for the
Calendar table will also disable the auto datetime tables in the dataset. Disabling
the Global option Auto Date/Time for new files means that new files will no longer
have Auto Date/Time enabled, but the file containing the current dataset will still
have it enabled until it is disabled. Changing the data

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.

The Report view provides the ability to create measures. To create a measure, use
the context sensitive menu of the Fields list or the Calculations section of the
ribbon. The Data view provides access to data within a dataset and includes the
option to create a measure in the Calculations section of the ribbon. Page view and
Power Query Editor do not include the option to create a measure.

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

A column that has a lot of repeated values and a low number of distinct values will
have a low cardinality. Reducing the number of distinct values reduces cardinality.
Replacing nulls does not change the number of distinct values. A static prefix or
suffix does not change cardinality.

Variable names are often shorter than the original expressions, and the final
variable returned at the end of the measure will be more readable with variable
names included. Variables cache the defined calculation, allowing it to be
referenced multiple times without additional impacts from recalculations. The
functions 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.

he CALENDARAUTO function generates a range of dates based on the earliest and

latest date within the dataset. The CALENDAR function generates a range of dates,
but it requires providing the start and end date. The DATE function returns the
specified date in the datetime format. The DATEDIFF function returns an interval
between two dates.

The #duration function of the M language allows you to specify the datetime values
that will be entered into individual rows of a date table. The #date function
creates a date value based on the date parameters you specify. The [Link]()
combines multiple lists into one. [Link] returns a list of count duration
values, rather than dates.

The CALCULATE function provides the result of the calculation with the ability to
override the context. The IGNORE function modifies the behavior of the
SUMMARIZECOLUMNS function by omitting specific expressions from the BLANK/NULL
evaluation. The FILTER function returns a table that represents a subset of another
table or expression. The SUMX function returns the sum of an expression evaluated
for each row in a table.

A matrix visualization displays data in two or more dimensions and cross-highlights

with other visuals on the same report page. A card visualization displays a single
data point. A scatter visualization is a chart, not a grid. It has two value axes,
with one set of numerical data along a horizontal axis and another set of numerical
values along a vertical axis. A table visualization is a grid that contains related
data in a grid format, with support for two dimensions only.

A funnel visualization displays a linear process with sequentially connected

stages, with one stage transitioning to the next. A slicer visualization is
available in different formats, including list, drop-down, and buttons, but not
sequentially connected stages, with one stage transitioning to the next. A treemap
visualization displays data as a set of nested rectangles. A waterfall
visualization displays a running total as values are added or subtracted.

Matrix and table visuals support conditional formatting. Gauge chart, scatter
chart, and treemap do not support conditional formatting.

The Key influencers visual helps you understand correlated factors impacting a
particular metric. The Q&A visual allows end-users to ask natural language
questions to create AI generated charts based on the questions.

The Decomposition Tree visual lets you visualize data between multiple dimensions
and drill down in any order. The Smart Narrative visual lets you combine natural
language text with metrics from your model in sentence forms.

RLS roles are created or modified from the Manage roles space. You can assign AD
users/groups to an existing role in the security settings, but new RLS roles must
be created in Power BI desktop or other model authoring external tool. RLS
configurations cannot be accessed from any Power Query window. Before you can
assign users to a security group, it first needs to be created for the model in
Power BI Desktop.

To implement an incremental refresh of the dataset, you first need to define filter
parameters, next you would define the incremental refresh policy. An incremental
refresh policy does not require upgrading to a Premium SKU. Publishing the dataset
to the Power BI service is required for the incremental refresh policy to take
effect, so it's the last step of setting up an incremental refresh.

The Contributor role is the least privileged role that grants permissions to
schedule data refreshes. The Member role grants permission to schedule data
refreshes but is more privileged than Contributor. The Admin role grants the
permissions to schedule data refreshes but is more privileged than Member. The
Viewer role does not grant the permissions to schedule data refreshes.

To create a custom R visual by using Power BI Desktop, you first need to install R
on your computer. Configuring global R scripting options in Power BI Desktop might
be required once you install R on your computer. Enabling the script visuals option
in the Visualization pane of Power BI Desktop is done once R is installed and
configured using the global R script options in Power BI Desktop. Creating a custom
R visual by using Power BI Desktop has no dependency on enabling preview features.

Adding synonyms to model fields will help users search for them. For example, you
can give a synonym of (Actuals) for the (Sales) measure. A linguistic schema
describes terms and phrases that Q&A should understand for objects within a
dataset, including parts of speech, synonyms, and phrasings that relate to that
dataset. Composite models are not supported by Q&A today. Organizing fields by
display folders will not impact Q&A search capabilities.

Date/time and numeric data types support bins-based grouping. Binary, Boolean, and
text data types do not support bins-based grouping.

Date data types display well on a continuous (range) axis where report users
understand chronological order. Number 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 (range)
axis. Date, time, or number are the only data types comparable with a continuous
axis.

Activating the View as feature will allow you test the row-level security as
someone with the Salesperson role. A what-if parameter is intended for
visualization and analytics of results of changing a value of a variable, not
validating row-level security. Adding a DAX expression filter to the Salesperson
table is part of implementing row-level security, which is already completed. A
conditional column is computed from other columns or values.
As part of setting up row-level security, it is necessary to create a role. In
addition, it is necessary to add a DAX expression filter to the Salesperson table.
This expression checks for a match between the salesperson's User Principal Name
attribute and the value in the UPN column. If the two match, the salesperson is
allowed to view the content of the corresponding row from the Salesperson table.

A calculated table only duplicates data. Any model configurations such as column
visibility or hierarchies must be recreated if needed.

Fewer columns mean there is less data to import and will reduce the model size and
decrease the time it takes to refresh the model. Since row counts aren’t changing,
the calculation speed of any existing DAX measures won’t change. Report page load
times are primarily determined by number of visuals (objects) on the page, and DAX
performance. Neither of which are impacted by unnecessary model columns.

The Data Source Settings in the Power Query interface supports editing permissions,
clearing permissions, and modifying the path of the data source file. Any
structural changes to a file, such as adding, removing, or renaming columns are not
supported by the Data Source Settings in the Power Query interface.

The storage mode of a table in Power BI Desktop is configurable from the Model
view, not the Data or Report view. Page view is an option available from within the
Report view.

A SharePoint folder is the only connector that will allow the import of multiple
Excel (or CSV) 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.

When importing data from an Excel workbook into Power BI, you receive the error
message: “We couldn't find any data formatted as a table.”
The error message indicates that the Excel workbook does not contain a table. To
create it, in the Excel workbook, you need to select the data you want to import,
press Ctrl+T or choose the Table button, click OK and save the change. Using the
Data Validation button in Excel does not create a table. Organizational and
template apps provide a way to implement functionality within Power BI, but, in
this case, the issue is caused by an absence of a table in the Excel workbook, so
installing an app would have no effect on resolving the issue.

The Advanced Editor in the Power Query Editor provides the ability to work with all
the M code used for shaping data in a query at once. Data view provides access to
data within a dataset. Model view provides access to the data model of a dataset.
The Formula Bar in the Power Query Editor provides the ability to edit only one
step at a time.

Individual filters and slicers cannot be pinned to a dashboard. This is because

dashboards are designed to be an “at-a-glance” perspective. Reports are built to be
filtered and interactive. Custom visuals, ribbon charts, and images can be pinned
from a report page.

By default, notifications are available in the notification center. You also have
the option of sending notifications via email. A dashboard, Microsoft Teams
channel, and a report are not available as the locations of alerts.
Admin users who have permissions to certify a dataset are defined in the Dataset
Certification tenant admin setting.

Calculated tables are generated with DAX queries. Numeric range parameters create a
table and measure, both generated with DAX queries. Hierarchies are helpful for
drilldown and are defined as part of the data model, but they are not generated by
using DAX. Display folders are a way to visually organize measures, columns, or
hierarchies. DAX is not used to create them.

To eliminate the impact of visual caching during a performance evaluation when

using Performance Analyzer to evaluate the visuals, you must first add a blank page
to the report, select that page, and then reopen 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.

The PATH function returns a string with identifiers of all the parents of the
current identifier, which is used for flattening. The PATHITEM function returns the
item at the specified position of a string, which is also used for flattening. The
EXCEPT function returns rows from one table which do not appear in another table,
which would require another table. The CROSSJOIN function returns a Cartesian
product of all rows from all tables that the function references. The RELATED
function returns a related value from another table, which would require another
table.

A ribbon chart places the highest (ranked) value at the top of the stacked column
each month and shows those ranked changes over time. A treemap is not meant for
displaying changes over time and wouldn’t easily show ranked comparisons between
employees. The clustered bar chart can be used to show changes over time, and a
clustered bar chart will show comparisons between employees, but no ranking data is
provided between employees. A scatterplot is typically used to compare a
relationship between two (or more) calculations and their categorical distribution
between each other.