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 your ability to manipulate data on the desktop.