21. What are all the connectivity modes available?
- Import
- Direct Query
22. What are all the benefits of using variables?
Variables will make unconstrained DAX expressions which are consistent to interpret with data. Variables can’t be shared among queries or be characterized at the model level.
23. What are the ways to create a bar chart?
Drag any one measure into the worksheet and drag one more dimension along it. Now you go to the show me pane, and choose the bar chart tile.. it can be both vertical and horizontal
24. What are the types of Data Refresh in Power BI?
By choice there are 4 different types of refresh that can happen. They are,
- Package refresh
- Model or data refresh
- Tile refresh
- Visual container refresh
25. Write a Sample formula for DAX syntax
For the measure named Total Sales, calculate = SUM of values in the [SalesAmount ] column.
- Measures
- equal signs
- DAX syntax
- Parenthesis
- Reference Table and
- Column name
26. Do I need to sign up with my work email?
It does not support email addresses provided by regular email services or telecommunications providers. So you should sign up using your professional address. List the work email addresses that are supported. Working email addresses ending in .edu and .org are always supported. Those ending in .gov are not currently supported.
27. What is xVelocity in-memory analytics engine?
The main engine, xVelocity in-memory analytics engine. This machine can handle large amount of data as it stores data in columnar databases and in enhances memory analytics which results in faster processing of data as it loads all data to RAM memory.
28. Is Power BI available within campus?
No, Power BI is not available as a private or an internal cloud service. However, with Power BI and Power BI Desktop you can connect to your own on-premises data sources. With the On campus Data Gateway, you can connect to your on campus SQL Server Analysis Services server as well.
29. Where else can we view on-premises?
- SQL Server with the Power BI iOS.
- SQL Server on the iPhone.
- SQL Server on the iPad.
30. What are the Power BI mobile devices?
Power BI has its own apps for Android phones, iOS devices, and Windows 10 devices. Download Power BI apps from below:
- Apple App Store
- Google Play and
- Windows Store
31. What are the Connectors to databases and other datasets?
Azure SQL Database and SQL Server Analysis Services.
32. What are the Organizational content packs?
BI professions and system integrators use this tool to build their own content packs to share purpose-built dashboards, reports, and datasets within their organization.
33. What are the different BI add ins?
- Power Query
- Power Pivot
- Power View
- Power Map
34. What do I need to install in order to use Power BI?
Just a Web browser and email. You can use Power BI Desktop for free up to 60 days.
35. Where can you download the Power BI mobile apps?
- App Store
- Google Play and
- Windows Store
36. What are the policies for on-premises?
Power BI Desktop’s use rights do not limit you to one copy of Power BI Desktop for each individual user at the company may install and use one copy on their premises.
37. Where do I get started with Power BI?
- Power BI Blogs
- Seminars
- Getting started videos on YouTube Channels
- Join a community and ask questions
38. Does Power BI meet national, regional, and industry-specific compliance requirements?
Without a doubt, and to learn more about Power BI compliance, at the Microsoft Trust Centre.
39. What has happened to the Power BI Office 365 experience?
It has been dropped.
40. How can we create a dashboard?
First upload a dataset and then upload the same, create multiple reports and infuse everything together as an appealing dashboard.
