Best Answer · By JanBask MS SQL Server Expert
Naveen Raj JanBask Expert
Answered on Nov 18, 2019
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.