Naveen Raj

What is Query Setting Pane?

Query Settings pane is where all steps associated with a query are displayed.

SQL Server

Answered Nov 28, 2019 · 1.5K Views Read answer →

What is Power BI Embedded?

Power BI leverages a very powerful method to share reports to Non Power BI domain User named as Power BI Embedded. There are few things about Power BI embedded that I need to know. Licence cost of Power BI embedded is different to Power BI services. Few features of Power BI services does not support in Power BI…

SQL Server

Answered Nov 28, 2019 · 1.5K Views Read answer →

Where incremental licensing refresh feature is accessible?

Incremental refresh feature mainly used for high-end scalability of data by publishing only on that workspace in Power BI Service where Premium capacity is needed.

SQL Server

Answered Nov 25, 2019 · 1.6K Views Read answer →

What is an on-premises data gateway?

There are two types of data gateways. 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…

SQL Server

Answered Nov 23, 2019 · 1.7K Views Read answer →

What is M Language?

M language is Programming language used in Power query.Its a functional case sensitive language which is similar to other Programming languages.

SQL Server

Answered Nov 23, 2019 · 1.7K Views Read answer →

What are the drawbacks of using Power BI?

Here are the main drawbacks of Power BI. Dashboards and reports only shared with users having identical email domains. Power Bl does not mix imported data, which is accessed from real-time connections. Power BI can't accept file size larger than 1 GB. Dashboard does not accept or pass user, account, or other entity…

SQL Server

Answered Nov 21, 2019 · 1.7K Views Read answer →

Difference Between Filters and slicers?

If you are using a normal filter then the user can not interact with Dashboard.On other hand,slicer allows users to have an interaction with Reports as well as Dashboards.

SQL Server

Answered Nov 21, 2019 · 1.7K Views Read answer →

What is Power BI Premium?

Power BI Premium provides dedicated and enhanced resources to run the Power BI service for your organization. For example: Greater scale and performance Flexibility to license by capacity Unify self-service and enterprise BI Extend on-premises BI with Power BI Report Server Support for data residency by region…

SQL Server

Answered Nov 18, 2019 · 1.6K Views Read answer →

How many types of Buttons in Power BI?

There are two types of buttons System defined Buttons Custom buttons Here are few System Defined Buttons

SQL Server

Answered Nov 18, 2019 · 1.6K Views Read answer →

How many types of Connectivity mode in power BI?

There are two connectivity mode in power BI Import mode : Extract data from any data source and pull that into Power BI Desktop. There is a 1 GB limit to the Desktop if you plan on publishing to the PBI Service. Direct Query Mode: Leaves the data in the database and sends queries to pull the information needed. Limits…

SQL Server

Answered Nov 18, 2019 · 1.6K Views Read answer →

What is the Power BI service?

Power BI is a collection of software services, apps, and connectors that work together to help you create, share, and consume business insights in the way that serves you and your business most effectively. The Microsoft Power BI service (app.powerbi.com), sometimes referred to as Power BI online, is SaaS (Software as…

SQL Server

Answered Nov 16, 2019 · 1.4K Views Read answer →

Difference between Import and Direct Query?

Import Extracts the data from your database and pulls it into the Power BI Desktop. Gives you the full suite of transformation and data manipulation in the Desktop. There is a 1 GB limit to the Desktop if you plan on publishing to the PBI Service. Can only be refreshed up to 8x a day by setting up a scheduled refresh…

SQL Server

Answered Nov 16, 2019 · 1.7K Views Read answer →