Hi @Anonymous ,
As far as I know, there are three kinds of connection modes in Power BI, Import/Direct Query and Live connection.
Import : Power BI will load all data into data model.
Direct Query: Power BI will only load metadata like column header into data model.
Live connection: Power BI will connect to data source by living and won't load anything into data model. You will need to create the data model in data source.
For the data source which support Direct Query/Live connection, you can convert the connection mode to Import.
This transformation of the connection model is irreversible.
Power BI only supports the composite model of Import and Direct Query. About Import and part of Direct Query, you can refer to AbbasG's blog .
Here are some blogs and I hope they could help you.
For refernece:
DirectQuery in Power BI - Power BI | Microsoft Learn
Connect to Analysis Services tabular data in Power BI Desktop - Power BI | Microsoft Learn
What's the difference between live connections and DirectQuery? - Power BI | Microsoft Learn
Power BI Connection Types: DirectQuery, Live, or Import? Tough Decision!
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
