Forum Discussion
Power BI
What is the difference between Import mode, Direct Query and Live mode? Please explain their advantages and disadvantages as well.
Import mode: Data is ingested into the Power BI native Vertipaq storage engine. Best performance for report users and slowest for report developers.
Direct Query: Data stays at the data source, and every user interaction with the report results in a new query. Slow for report users, better performance for developers. No size limitiations, some ability to add measures and calculated items.
Live mode: You are connecting to an OLAP cube or SSAS tabular model with no control or flexibility. What you see is what you get. No ability to add any logic.
1 Reply
Import mode: Data is ingested into the Power BI native Vertipaq storage engine. Best performance for report users and slowest for report developers.
Direct Query: Data stays at the data source, and every user interaction with the report results in a new query. Slow for report users, better performance for developers. No size limitiations, some ability to add measures and calculated items.
Live mode: You are connecting to an OLAP cube or SSAS tabular model with no control or flexibility. What you see is what you get. No ability to add any logic.