1. Allowing Power BI users to “Publish to Web”
is done from Admin Portal => Tenant Settings.
2. We can manage Embed Codes from … on the top right. Also from Admin Portal => Embed
Codes.
3. Subscriptions are possible to Reports and Dashboards
from their main page. Subscriptions can also be controlled from Settings =>
Settings => Subscriptions.
4. We can Export reports to PDF, PowerPoint, Analyze
in Excel and only Print Dashboards.
5. We can Manage Alerts
only for KPI, Cards, and gauges at the dashboard. Not on live pinned reports on dashboards
or reports.
6. For Dashboard Turn off/on
Q&A box from(if it is also turned on from dataset):
a.
On Dashboard File => Settings
b.
On main ribbon …=> Settings => Settings =>
Dashboards
7. For dataset Turn off/on
Q&A box from:
a.
Choose more options on … on dataset => Settings
=> Datasets =>
b.
On main ribbon … => Settings => Settings =>
Datasets =>
8. To Create Q&A
questions:
a.
Choose more options on … dataset => Settings =>
Datasets=>Featured Q&A Questions.
b.
On main ribbon … => Settings => Settings =>
Datasets Featured Q&A Questions.
9. To Pin Table from Excel
to Dashboard: We should upload the file to Power BI service with Get Data, not
import, if we import, we can’t pin the table. We can do this also with Power BI
Publisher which can be installed in Excel.
10. Test = CALCULATE([Total
Sales], FILTER(Locations, Locations[Name] = "Miami" ||
Locations[Type] = "City"))
If we don’t use the filter function in
this measure, it doesn’t work because we have two columns, if it’s only one
column, it works without using the filter function.
11. Power
BI Embedded is
a Microsoft Azure service which developers
quickly embed visuals, reports, and dashboards into an application.
But if we need others to see it, we should have the premium capacity.
12. Extract function in
Power Query: it doesn’t divide column like split, it keeps(extracts) the part
you choose and delete completely the part you don’t choose inside a column.
13. When we Get Data on Power
BI Service it can only get pbix, CSV, or xlsx.
14. Shared Capacity has
limits of 1 GB per dataset, 10 GB per user, and eight refreshes per day. If you
have chosen to keep the Excel experience, instead of importing the data, the
limit is 250 MB for the dataset. Premium Capacity: 100 TB of storage is
available, the refresh limit is 48x per day, and a dataset can be 10 GB. When
loaded, the model can then be published to a workspace assigned to a Premium
capacity. The dataset can then be refreshed to up to 12 GB in size.
15. Edit => Add a Tile =>
Custom Streaming Data option is on Dashboards. It connects to datasets from PUBNUB,
AZURESTREAM and API.
16. We need a table with the year
month day columns to create a date Hierarchy, only one date column is
not enough to create a hierarchy with dates.
17. Edit Interactions: Highlight
is the default mode. If we want to see the only selected bar(not others as
faded) on the visual we should choose filter mode. The last mode is None. It
disables cross-filtering between visuals.
18. At M Query functions, if
there is ‘IS’ inside the name of the function, it means that functions return True
or False statement.
19. Table.Distinct = Removes
duplicate rows from the table.
Table.RemoveMatchingRows = This one
also does the same but we should specify which rows to remove.
20. Transform => Clean:
Cleans unprintable characters.
21. Junk Dimension is
combination of small dimension tables
22. By default Power BI
automatically Imports Relationships e.g from SQL Server, by default it
doesn’t reflect changes in the SQL. However, we can change it from local file
data source settings.
23. We can use IF in SUMX
function.
24. We should always create Calculated
Columns in M Query because in M Query they are compressed better than Dax,
thus we can have a smaller sized model.
25. After Applied Steps at
Power Query, underlying data doesn’t change, it’s view changes.
26. Column Profile is
the part at down, Column Quality is the part we have valid error empty percentage,
Column Distribution is thin tall bars.
27. After Statistic calculations
at Power Query, it creates a new step with one number as an output at Applied
Steps.
28. When connecting to a data
source using DirectQuery, you can use the Assume Referential Integrity
selection to enable running more efficient queries against your data source.
This feature has a few requirements of the underlying data, and it is only
available when using DirectQuery. Setting Assume referential integrity enables
queries on the data source to use INNER JOIN statements rather than OUTER JOIN,
which improves query efficiency.
29. SEARCH function in
DAX: It doesn’t return the thing you search, it returns the position of the
thing you search. e.g SEARCH("house", "Doghouse", 1,
BLANK()) returns 4 not house.
30. You create a dashboard in
Power BI Service by pinning a visual from a report. You click the Ellipses
(...) => Edit Details => Set Custom Link => Enter a URL => click
Apply. What is the effect of this setting on the functioning of the dashboard? When
you click on the dashboard it takes you to that URL.
31. At Power BI Desktop we have
Refresh. At Power Query, we have Refresh Preview and Refresh
All.
32. On Power BI Service when we can Copy the Report, it copies
it to the same workspace. We can also download pbix or print the page.
33. In Power Query you select a
column of dates. From the Add Column tab
you choose Date, then Age.
What entries does the newly created column contain and how is the column
formatted? The Duration between the current system date and column’s date in
format day hour minute second.
34. When we Upload an Excel File
to Power BI Service it takes it as an Excel file, when you click on it, it
opens it at Excel Online. When we Import an Excel File it takes the
table inside the Excel and takes it as a dataset, we can’t open it at Excel
Online.
35. Types of Gateways.
There are two different types of gateways, each for a different scenario:
a.
On-premises Data Gateway: allows multiple
users to connect to multiple on-premises data sources. You can use an
on-premises data gateway with all supported services, with a single gateway
installation. This gateway is well-suited to complex scenarios with multiple
people accessing multiple data sources. Can be used with other Power
Applications like (Power Apps/Flow/Logic Apps)
b.
On-premises Data Gateway (Personal mode):
allows one user to connect to sources, and can’t be shared with others. An
on-premises data gateway (personal mode) can be used only with Power BI. This
gateway is well-suited to scenarios where you’re the only person who creates
reports, and you don't need to share any data sources with others.
36. Bookmarks are only
for reports, not dashboards. If we make the bookmark default, it opens that
bookmark directly when we go to the report. If we don’t we need to choose it
from bookmarks to see it.
37. We can View Insights
only on Dashboards. We can pin those quick insight visuals back to the
dashboard.
38. Your Scheduled Refresh
has been paused. We’ve paused the scheduled refresh for PSDQ in My Workspace due to
inactivity. No one has viewed dashboards or reports built using this dataset
for two months. To resume it, just visit a report or dashboard built using this
dataset or manually refresh the dataset using the Refresh Now option.
39. Capacity limits:
Workspace storage limits, whether for My Workspace or an app workspace, depend
on whether the workspace is in shared or Premium capacity.
Shared capacity limits: For workspaces
in shared capacity:
a.
There is a per-workspace storage limit of 10 GB.
b.
For app workspaces, the total usage can’t exceed
the tenant storage limit of 10 GB multiplied by the number of Pro licenses in
the tenant.
Premium capacity limits: For workspaces in Premium capacity:
a.
There is a limit of 100 TB per Premium capacity.
b.
There is no per-user storage limit.
40. Paginated Reports
are designed to be printed or shared. They're called paginated because they're
formatted to fit well on a page. They display all the data in a table, even if
the table spans multiple pages. They're also called pixel perfect because you
can control their report page layout exactly. Power BI Report Builder is
the standalone tool for authoring paginated reports for the Power BI service. you
can upload the paginated report to a workspace assigned to at least a P1
capacity.
41. In Power BI Desktop we can get
data from Json, Xml, Power BI Template Apps, etc
42. In Power Query you
use Get Data to connect to an Excel table with the following columns: Date,
CustomerID, Product, Price, Qty. You remove the Product column by selecting the
other columns and clicking Remove Other Columns. You create a data model and report from the
data. The Excel table is later updated and now has these columns: Date,
CustomerID, Product, Price, Qty, Store. Which columns are available in your data
model for reporting? Deleted ones don’t come back, new added ones appear in the query but not in the modal. After refreshing, it appears in modal too.
43. If we have a File As
Source that and if we add new CSV/xlsx to the source, it doesn’t reflect to
the modal without refreshing the modal on desktop(not on Query). The changes we
made at query before adding file also
reflects on the newly added CVS/xlsx.
44. Publish to Web is
supported for the vast majority of data sources and reports in the Power BI
service, however, the following are not currently supported or available with
Publish to web:
a.
Reports using row-level security.
b.
Reports using any Live Connection data source,
including Analysis Services Tabular hosted on-premises, Analysis Services
Multidimensional, and Azure Analysis Services.
c.
Reports using a shared dataset, which is stored
in a different workspace from the report.
d.
Reports shared to you directly or through an
organizational content pack.
e.
Reports in a group in which you are not an edit
member.
f.
"R" Visuals are not currently
supported in Publish to web reports. Exporting Data from visuals in a report,
which has been published to the web.
g.
ArcGIS Maps for Power BI visuals.
h.
Reports containing report-level DAX measures.
i.
Single sign-on data query models. Secure
confidential or proprietary information.
j.
Shared and certified datasets.
k.
The automatic authentication capability provided
with the Embed option doesn't work with the Power BI JavaScript API. For the
Power BI JavaScript API, use the user owns data approach to embedding.
45. On Power BI Service we have
Phone Layout option at Report => Edit and Dashboard => Edit.
46. We can Share Dashboard
from the dashboard menu share option and from the workspace.
47. We can Subscribe to
both dashboards and reports but we cannot subscribe to them if they have
row-level security or the dataset is using a Live Connection to Analysis
Services.
48. Using a Direct Query connection might be slow because:
a.
Interaction with a Power BI report slicing/cross
filtering requires a query to be passed back to the source to be calculated.
b.
Data aggregations have to be performed at the source
rather than being done at DAX engine.
49. Power BI (free):
a.
Access to content in My Workspace
b.
Consume content shared with them
Power
BI Pro:
a.
Publish content to other workspaces,
b.
Share dashboards,
c.
Subscribe to dashboards and reports, share with
users who have a Pro license
d.
Distribute content to users who have free
licenses
50. Text.Start Text.End uses
one number as parameter whereas Text.Range needs 2 numbers for start and
stop points.
51. FORMAT([Date],
"MMMM DD, YYYY") This formula works” We can put 4 parameters inside
format without any delimiter.
52. Dataflows: We can
connect from Power BI Desktop. Dataflows then store that data in a table in
the cloud so it can be used directly inside PowerBI.com. Tables that are created
as a result of the dataflow are stored in an Azure Data Lake.
53. Slowly Changing
Dimension (SCD) is a dimension that stores and manages both current and
historical data over time in a data warehouse.
a.
In a Type 1 SCD the new data
overwrites the existing data.
b.
A Type 2 SCD retains the full
history of values.
54. Personalize Visuals
in a report. With the Personalize this visual feature, make the changes
yourself and when you have the visual the way you want it, save it as a
bookmark to come back to. You don't even need edit permission for the report. To
enable the feature in Power BI Desktop, go to File > Options and Settings
> Options > Current file > Report settings. Make sure Personalize
visuals is turned on.
55. Line Chart X-axis
can be made categorical or continuous. Categorical shows every value like every
date, continuous group them e.g. to months.
56. We can create Drillthrough
pages with measures too.
57. When you create the bar
chart, the regions appear as expected, but the sales amount value displays the
count of sales amount instead of the sum of the sales amount in each region. You need
to modify the query to ensure that the data appears correctly. What should you
do? The reason the visual is counting because it is seeing that column as an Undefined
Default Data Type (ABC123) or text (ABC); changing that to whole number
(123) or decimal number (1.2) from query editor will solve the issue right
away.
58. Sales = CALCULATE(COUNT(Sales[Quantity]),
Sales[Quantity] > 2) or
COUNTROWS(FILTER(Sales,
Sales[Quantity] > 2))
59. To Develop Custom Visuals,
you need to have NodeJS installed with Power BI tools and a server certificate.
60. Azure ExpressRoute
lets you extend your on-premises networks into the Microsoft cloud over a
private connection with the help of a connectivity provider. With ExpressRoute,
you can establish connections to Microsoft cloud services, such as Microsoft
Azure and Microsoft 365. It does not use the public Internet the traffic is not
encrypted. It gives customers their own private connection to Azure.
61. PARALLELPERIOD(<dates>,<number_of_intervals>,<interval>)
PREVIOUSYEAR(<dates>[,<year_end_date>])
62. For Dashboards only Sharing
option is via grant access by entering their email address. For reports, we
have 2 options.
a.
Share => Embed Report => Sharepoint Online
b.
Share => Embed Report => Website or Portal
63. XMLA End-Point Feature
in Power BI Premium allows third party client applications and tools to connect
(read/write) to the data models hosted in Power BI Premium.
64. Workspaces that we use for Deployment
Pipeline should have a premium capacity. Deployment pipelines enable
creators to develop and test Power BI content before the content is consumed by
users. The content types include reports, dashboards, and datasets.
Functionality to have a managed lifecycle for content.
65. Usage Metrics
reports are a feature that the Power BI or global administrator can turn on or
off. Administrators have granular control over which users have access to usage
metrics. They are On by default for all users in the organization. Admin,
contributor, or viewer can view the usage metrics. Usage metrics data show data
only for the last 90 days.
66. If a report has an RLS
and if somebody who is not a member of any row-level security tries to open it,
the report gives an error saying it has restricted data.
67. Question: You plan to use
Power BI Desktop to create a report. The report will consume data from an
on-premises tabular database named SalesDB in Microsoft SQL Server Analysis
Services (SSAS). The report will be published to the Power BI service. You need
to ensure that the report published to the Power BI service will access the
current data in SalesDB. What should you do?
Answer: Deploy an on-premises data gateway
and configure the connection to SalesDB to use the Connect Live option.
Because DirectQuery is for SQL server. For SSAS you need Live connect to get
current data.
68. Publish your Excel
workbook to Power BI To publish your Excel workbook, in Excel, select File =>
Publish and select either Upload or Export.
a.
If you Upload your workbook to Power BI, you can
interact with the workbook just as you would interact using Excel Online. You
can also pin selections from your workbook onto Power BI dashboards, and share
your workbook, or selected elements, through Power BI.
b.
If you select Export, you can export table data
and its data model into a Power BI dataset, which you can then use to create
Power BI reports and dashboards.
69. Publish to Power BI from
Microsoft Excel. With Microsoft Excel 2016 and later, you can publish your
Excel workbooks directly to your Power BI workspace. When publishing a workbook
to Power BI, there are few things to consider:
a.
The account you use to sign in to Office,
OneDrive for Business (if using workbooks saved there), and Power BI must be
the same account.
b.
You cannot publish an empty workbook or a workbook that doesn’t have any Power BI supported content.
c.
You cannot publish encrypted or password
protected workbooks, or workbooks with Information Protection Management.
d.
Publishing to Power BI requires modern
authentication to be enabled (default). If disabled, the Publish option is not
available from the File menu.
e.
Excel supports publishing of local Excel files.
They do not need to be saved to OneDrive for Business or SharePoint Online.
70. You need to create a
measure named YTDPreviousSales that will be used in a table
visualization. YTDPreviousSales must show the year-to-date (YTD) sales of the
previous year for the same month. How should you complete the measure?
TOTALYTD([Total Revenue],
DATEADD('Date'[Date], -12, MONTH))
71. Data Sources Supported
by Reporting Services (SSRS):
a.
Microsoft SQL Server
b.
Microsoft SQL Server Analysis Services for MDX, Microsoft
Power Pivot, and tabular models
c.
Microsoft Azure SQL Database,
d.
Oracle, SAP BW
e.
Hyperion Essbase
------No Excel!!-----
f.
Microsoft SharePoint List
g.
Teradata
h.
OLE DB, ODBC
i.
XML
j.
Microsoft SQL Server
72. Changing the Name of the
Column also changes how the data inside the column is treated. In the data
view simply change the name of the column to country and the visualization
changes, the data category also remains unchanged and set to Uncategorized. i.g.
when acronyms are both states and countries. It changes the map.
73. Column names are not Case
Sensitive in Power BI
74. On-premises data gateway DirectQuery
support: Yes
On-premises data gateway (personal mode)
DirectQuery support: No
75. RelativePosition.FromEnd.
Indicates indexing should be done from the end of the input.
Text.AfterDelimiter("111-222-333",
"-", {1, RelativePosition.FromEnd})
76. SSAS / Tabular = Live
Connection
SQL = Direct Query
77. Embed Power BI Content Into
an Application for your organization. In Power BI, you can embed reports
(Power BI or Paginated), dashboards, or tiles into an application by using user
owns data. To get started, you're required to have:
a.
A Power BI Pro account.
b.
A Microsoft Azure subscription.
c.
You need to have your own Azure Active Directory
tenant setup.
d.
For embedding paginated reports you need at
least a P1 capacity
Register
your application with Azure Active Directory to allow your application access
to the Power BI
REST APIs. If you're embedding reports, dashboards, or tiles for your
customers, then you have to place your content within a workspace.
78. You have a Power BI report
in an app workspace. You plan to Embed a Report from the app workspace
into a line-of-business application by using Power BI Embedded. Which
information should you provide to the application developers?
Access key/token and Report ID. Report ID is
in the URL like workspace ID.
79. Microsoft Information
Protection Sensitivity Labels provide a simple way for your users to
classify critical content in Power BI without compromising productivity or the
ability to collaborate. Sensitivity labels can be applied to datasets, reports,
dashboards, and dataflows. When labeled data leaves Power BI, either via export
to Excel, PowerPoint or PDF files or via other supported export scenarios such
as Analyze in Excel or live connection PivotTables in Excel, Power BI
automatically applies the label to the exported file and protects it according
to the label’s file encryption settings. This way your sensitive data remains
protected, no matter where it is.
80. When you've created dynamic
reports in Power BI Desktop, you can share them by publishing them to your Power BI
site. When you publish a Power BI Desktop file with a Live Connection to
a tabular model to your Power BI site, an on-premises data gateway must be
installed and configured by an administrator.
81. You need to provide a user
with the ability to Add Members to a Workspace. The solution must use
the principle of least privilege. A Member can add members or others with lower
permissions.
82. At Power Query Advanced
Editor we can write to the last row other than the previous step’s name, it
doesn’t give an error.
83. A natural key (also
known as a business key) is a type of unique key in a database formed of
attributes that exist and are used in the external world outside the database. Like
social security number, passport number, flight number. A surrogate key or
synthetic key in a database is a unique identifier for either an entity in the
modeled world or an object in the database. The surrogate key is not derived
from application data, unlike a natural (or business) key which is derived from
application data. A surrogate key is a unique identifier that you add to a
table to support star schema modeling. By definition, it's not defined or
stored in the source data. Commonly, surrogate keys are added to relational
data warehouse dimension tables to provide a unique identifier for each
dimension table row.
84. Roles in the new workspaces:
Admin
a.
Update and delete the workspace.
b.
Add/remove people, including other admins.
c.
Allow Contributors to update the app for the
workspace.
Member
(Mostly App Permissions)
a.
Add members or others with lower permissions.
b.
Publish, unpublish, and change permissions for
an app
c.
Update an app. If
allowed
d.
Share an item or share an app.
e.
Allow others to reshare items.
f.
Feature apps on colleagues' Home
Contributor
a.
Feature dashboards and reports on colleagues'
Home
b.
Create, edit, and delete content in the
workspace.
c.
Publish reports to the workspace, delete
content.
d.
Create a report in another workspace based on a
dataset in this workspace.
e.
Copy a report.
f.
Manage dataset permissions.
g.
Schedule data refreshes via the on-premises
gateway.
h.
Modify gateway connection settings.
85. You import a large dataset
to Power Query Editor. You need to identify whether a column contains only
unique values. Which two Data Preview options can you use? Column Distribution
and Column Profile.
86. Tab Order is the
order in which users interact with the items on a page using the keyboard.
Generally, we want tab order to be predictable and to closely match the visual
order on the page (unless there is a good reason to deviate).
87. Star Schema vs.
Snowflake Schema:
a.
Star schema dimension tables are not normalized,
snowflake schemas dimension tables are normalized.
b.
Snowflake schemas will use less space to store
dimension tables but are more complex.
c.
Star schemas will only join the fact table with
the dimension tables, leading to simpler, faster SQL queries.
d.
Snowflake schemas have no redundant data, so
they're easier to maintain.
e.
Snowflake schemas are good for data warehouses,
star schemas are better for datamarts with simple relationships.
88. Question:You have a large
dataset that contains more than 1 million rows. The table has a DateTime column
named Date. You need to reduce the Size of the Data Model. What should
you do?
Answer: Split the Date column into two
columns, one that contains only the time and another that contains only the
date. In Power BI when we Trim a column, the data size enlarges. When we
split the DateTime column into date and time the data size shrinks.
89. On Dashboard Edit => Add
a Tile => Video options allow only videos from Youtube or Vimeo.
Edit => Add a Tile => Custom
Streaming Data is for real-time data with API PUBNUB or AzureStream. Edit
=> Add a Tile => Web Content works with any type of URL.
90. Row Level Security
Limitations
a.
If you previously defined roles and rules in the
Power BI service, you must re-create them in Power BI Desktop.
b.
You can define RLS only on the datasets created
with Power BI Desktop. If you want to enable RLS for datasets created with
Excel, you must convert your files into (PBIX) files first.
c.
Only Import and DirectQuery connections are
supported. Live connections to Analysis Services are handled in the on-premises
model.
91. If country names in Y-Axis cut off we can make
it entire without making visual bigger by changing the Maximum Size in
format pane.
92. We can Pin a Tile
from one dashboard to another.
93. If we change DateTime
column to Date, it doesn’t give an error.
94. Role-playing dimensions.
A dimension that can filter related facts differently. For example, at
Adventure Works, the date dimension table has three relationships to the
reseller sales facts. The same dimension table can be used to filter the facts
by order date, ship date, or delivery date. If you need to filter them at the same
time without using USERELATIONSHIP, create the additional dimension tables as
calculated tables, using DAX. Using calculated tables, the model can contain a
Date table, a Ship Date table, and a Delivery Date table, each with a single and
active relationship to their respective reseller sales table columns.
95. A Factless Fact
table doesn't include any measure columns. It contains only dimension keys.
96. Many data modeling and data
transformations are available when using DirectQuery, though with some
limitations. When you create or interact with a visualization, you must query
the underlying source. The time that's needed to refresh the visualization
depends on the performance of the underlying data source. The 1-GB dataset
limitation doesn't apply to DirectQuery.
Limitations of Direct Query:
a.
If the Query Editor query is overly complex, an
error occurs.
b.
Time intelligence capabilities are unavailable
in DirectQuery. For example, special treatment of date columns (such as year,
quarter, month, or day) isn't supported in DirectQuery mode.
c.
There's a one-million-row limit for cloud
sources.
97. A dataset is available in
Power BI service online. Would you be able to import data from Power BI Service
online using Get Data => Power BI dataset? Yes
98. Which two field options are
available when creating a Waterfall Chart? Category and Size. NOT x-axis
and y-axis.
99. 1 2020 = FORMAT('Table'[Date],
"M YYYY")
01 2020 = FORMAT('Table'[Date], "MM YYYY")
Jan 2020 = FORMAT('Table'[Date], "MMM
YYYY")
January 2020 = FORMAT('Table'[Date], "MMMM
YYYY")
Just because MMMM part is upper case it
doesn’t return JANUARY it returns January. We can’t change upper or lower with Format.
“
Answer: Page-level filter
101. When
we are editing a report on Power BI Service we have 3 options: Fit to Page,
Fit to Width, Actual Size.
102. Data
Mart is a subset of the data warehouse and is usually oriented to a
specific business line or team. Whereas
data warehouses have an enterprise-wide depth, the information in data marts
pertains to a single department.
103. Personally
identifiable information (PII) is any data that can be used to identify a
specific individual. Social Security numbers, mailing or email addresses, and
phone numbers have most commonly been considered PII.
104. Question:
You use an R visual to produce a map of 500,000 customers. You include
the values of CustomerID, Latitude, and Longitude in the fields sent to the
visual. Each customer ID is unique. In powerbi.com, when users load the visual,
they only see some of the customers. What is the cause of the issue?
Answer:
Too many records were sent to the visual.
105. Create
Power BI visuals using R: By default, Power BI Desktop doesn't include,
deploy, or install the R engine. To run R scripts in Power BI Desktop, you must
separately install R on your local computer. After you've installed R, Power BI
Desktop enables it automatically.
R
visuals in Power BI Desktop have the following limitations:
a. Data
sizes: Data used by an R visual for plotting is limited to 150,000 rows. If
more than 150,000 rows are selected, only the top 150,000 rows are used and a
message is displayed on the image.
b. Output
size: R visual has an output size limit of 2MB.
c. Resolution:
All R visuals are displayed at 72 DPI.
d. Calculation
times: If an R visual calculation exceeds five minutes, it causes a time-out
error.
e. Highlights:
R visuals respond if you highlight other visuals, but you can't select elements
in the R visual to cross filter other elements.
f.
Column renaming: R visuals do not support
renaming input columns. Columns will be referred to by their original name
during script execution.
106. We
can change the Dashboard Theme with Edit => Dashboard Theme. We can
upload or download JSON theme or use URL.
107. The
key influencers Visual helps you understand the factors that drive a metric
you're interested in. It analyzes your data, ranks the factors that matter, and
displays them as key influencers. The key influencers visual is a great choice
if you want to:
a. See
which factors affect the metric being analyzed.
b. Contrast the relative importance of these
factors. For example, do short-term contracts have more impact on churn than
long-term contracts?
108. Scatter
Chart always has two value axes to show: one set of numerical data along a
horizontal axis and another set of numerical values along a vertical axis. The
chart displays points at the intersection of an x and y numerical value,
combining these values into single data points.
109. We
have 2 part in Key Influencers. Key Influencers show attributes that lead to the metric increase or decrease. Top segments show attributes lead to the metric
high/low.
110. Decomposition
Tree visual in Power BI lets you visualize data across multiple dimensions.
This makes it a valuable tool for ad hoc exploration and conducting root cause
analysis.
111. Dataflows
has premium features.
a. Enhanced
compute engine: Perform faster data refreshes.
b. Direct
Query
c. Computed
entities
d. Linked
Entities
e. Incremental
refresh
112. M language query
steps can’t start with a number. If the query step name has space it should be in
speech marks and start with hash.
113. Fill down/up
doesn’t work with empty cells like empty cells in a text column. It works with
only null which is in a numeric column.
114. If your data source is a
CSV stored in One Drive(Business/Personal) it will refresh in Power BI
Service every hour, once the report is published.
115. When connected via Direct
Query to an Azure SQL DB, Dashboard tiles on Power BI Service Refresh
every hour.
116. During Append Queries
if one of the tables has a column that others don’t have, it brings null
values for them.
117. We can’t Create Hierarchies
from the relationship view. We can do it from the report view or data view.
118. We can enable Premium Capacity
for workspaces, not for dashboards or reports, or datasets.
119. “Mean” is a synonym
for average in Statistics, not median.
120. Query Folding is
the ability for a Power Query query to generate a single query statement to
retrieve and transform source data. The Power Query mashup engine strives to
achieve query folding whenever possible for reasons of efficiency. Most data
sources that support SQL queries support query folding. However, data sources
like flat files, blobs, and web feeds typically do not. It is not recommended
that incremental refresh is used when the required query folding cannot take
place.
121. Incremental refresh
enables very large datasets in Power BI with the following benefits: Refreshes
are faster - Only data that has changed needs to be refreshed. For example,
refresh only the last five days of a ten-year dataset. Resource consumption is
reduced - fewer data to refresh reduces overall consumption of memory and other
resources. Incremental refresh policies are defined in Power BI Desktop and
applied when published to the Power BI service.
122. R visuals currently
can only be created in Power BI Desktop, and then published to the Power BI
service. The Power BI service supports viewing and interacting with visuals
created with R scripts. Visuals created with R scripts commonly called R
visuals. R visuals that are created in Power BI Desktop, and then published to
the Power BI service, for the most part, behave like any other visual in the
Power BI service; you can interact, filter, slice, and pin them to a dashboard,
or share them with others. R visuals require a Power BI Pro license to render
in reports, refresh, filter, and cross-filter. R visuals do not display when
using Publish to web.
123. Hyperlink = URL
124. GENERATESERIES(<startValue>,
<endValue>[, <incrementValue>])
125. Power BI Embedded capacity
settings are managed in the Microsoft Azure Portal.
126. For minimal effort, we
should change the source for Data Source settings from the home ribbon, for
every query we can change one by one from the first step too.
Question: You need to ensure that you can Embed
the Report into a custom application that will be accessed by external
users. The external users will NOT have a Microsoft Azure Active Directory user
account or Power BI licenses.
Solution: Purchase Power BI Premium P1, and then configure the app workspace to run in a dedicated capacity.
Comments