what is difference between direct query and import in power bi?
How to connect using DirectQuery. Here are the differences between selecting Import and DirectQuery: Import: The selected tables and columns are imported into Power BI Desktop. ... As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you're always viewing current data.