Hello and welcome to TAIK
I am Mohammed Adnan
and in this video we are going to discuss
about
Power BI Interview questions and answers part
6
If you are new to this channel or if you haven't
subscribe yet
just click on the subscribe button and also
press the bell icon
to get the latest notifications, now lets
get started
26. What is RLS...?
Row-level security (RLS) in Power BI can be
used to restrict the data access for the users.
Restrict data access happens at the row level,
and you can define filters within roles.
Be aware that in the Power BI service, if
the members of a workspace have access to
datasets in the workspace,
then RLS doesn't restrict this data access,
because they already have full access to that
dataset.
27. Can
I use RLS to limit the columns or measures
accessible by my users?
No, if a user has access to a particular row
of data, they can see all the columns of data
for that row.
RLS works on row by row, not column by column.
28. Difference between Quick Measure & Measure...?
Quick Measures are Pre-built measures,
We do not have to write any DAX
We just need to input the fields in the dialog
box,
Power BI will write the DAX for you and you
can use the measure
If you're importing your own date table, make
sure to mark it as 
a date table
Measure which we create DAX functions manually.
We can create DAX Measure or DAX Columns.
Not necessary, but best practice
29. What is Calculated Table in Power BI...?
In general we create tables by importing
data into the model by using get data (Excel,
SQL, web).
But calculated tables let you add new tables
using (DAX formulas) based on the data you've
already loaded into the model.
Just like other Power BI Desktop tables, calculated
tables can have relationships with other tables.
Calculated table columns have data types,
formatting, and can belong to a data category.
You can name your columns whatever you want
& add them to report visualizations just like
other fields.
Calculated tables are recalculated if any
of the tables they pull data from are refreshed
or updated
Calculated tables are best for intermediate
calculations and data you want to store as
part of the model, rather than calculating
on the fly or as query results. For example,
you might choose to union or cross join two
existing tables.
30. Can we use Calculated Table in Direct
Query...?
Yes, we can use Calculated table in Direct
Query.
The table will only reflect the changes, after
the original dataset has been refreshed.
if you like this
video just click on the big thumbsup button,
if you are new to this channel or haven't
subscribe yet
just click on the subscribe button,
and also press the bell icon to get the latest
notifications
but make sure you turned on the notifications
on you devices
share it with your friends and colleagues,
If you have any queries and feedback just
post it on the comment section below.
thanks for watching. keep learning see you
in the next video.
