Name the different connectivity modes available in Power BI?

There are three main connectivity modes available in Power BI:

  • SQL Server Import: It’s the default and most commonly used connectivity option in Power BI. With SQL Server Import, the user can fully utilize the Power BI Desktop. You can easily connect the SQL Server data with Power BI and run queries on it.
  • Direct Query: Direct queries can be executed on datasets exceeding the recommended size. In this case, Power BI will only store the metadata of the source and execute direct queries on it. However, it limits the operations you can perform to prepare your data for reporting.
  • Live Connections: Power BI Service can be used to connect with live data sources such as SQL Server Analysis Services, Power BI Datasets hosted by Power BI Service, and Azure Analysis Service. In a live connection, all the interactions will be done using direct queries.