Functions in Power BI dashboards
Tiles :
• Dashboard contain tiles, we can pin a tile from a report, another dashboard, excel workbook, quick insights, reporting services and so on.
• We can use standalone tiles in dashboards using 'Add Tile' for images, text boxes, videos, streaming data and web content.
Click here for full answer...
What is the default visual interaction in Power BI ?
The default visual interaction in Power BI should be Drill Mode On, we can set this to on off, if we keep off, we have to change the setting every time. Instead set the Default to ‘Drill Mode On’.
What it means to Drill Mode on, if the totals are at yearly level, the drill mode on can enable user to drill down to monthly, weekly, daily and so on. The level of drill downs are only possible based on the data.
Click here for full answer...
What is DAX:
DAX (Data Analysis Expressions) helps in creating new information from existing information (or) data. The existing information can be at detail level, using DAX we can create information such as aggregated, summarized and so on.
Click here for full answer...
To use data refresh, you need a way to pull data from the data source (SQL Server, in this example) and push it directly into the SSAS model generated by Power BI.
Click here for full answer...
Power BI now has all of the information it needs to refresh the data, both on demand and on a scheduled basis. Expanding the Schedule Refresh section, you can define when Power BI attempts to refresh the dataset.
Click here for full answer...
Power BI provides variety of option to filter report, data and visualization. The following are the list of Filter types.
Click here for full answer...
Visual-level Filters
These filters work on only an individual visualization, reducing the amount of data that the visualization can see. Moreover, visual-level filters can filter both data and calculations.
Click here for full answer...
Power BI Desktop
Power BI Desktop is a Windows application (Clinet) running on the local computer. It is more a of client machine which can connect with variety of data sources from your computer to the data in the local computer or the data in the server.
Power BI
Power BI is a cloud solution. We can use web browser to connect with Power BI. We can perform the same development work using either Power BI OR Power BI Desktop.
Click here for full answer...
The following are the Building Blocks (or) Key components of Power BI
- Visualizations
- Datasets
- Reports
- Dashboards
- Tiles
Click here for full answer...
Microsoft Business Intelligence - MSBI
Microsoft product with ETL capability, multidimensional data organizing capability and visualization ability. MSBI comes with three sub components to support earlier mentioned functionalities. The following are the components of MSBI:
MSBI - SSIS
This component works as an Data Integration Service which can perform up to some level of ETL acitivity.
Click here for full answer...