Data Connection Methods in Power BI
There are three different ways to connect to data sources in Power BI.
- Import Data
- In this method Power BI extracts data from source and stores it in the in-memory engine called xVelocity. xVelocity engine is optimized for data storage and performance.
- Import data offers superior performance and enhances the overall design experience.
- DirectQuery
- In DirectQuery Power BI directly connects with the data source and no data is imported into Power BI.
- DirectQuery has certain limitations, including the lack of support for certain data sources and the incomplete compatibility with all Power Query features.
- DirectQuery provides scalability and enables seamless data updates.
- Live Connection
- Similar to DirectQuery, Live connection in Power BI does not involve importing data into the Power BI.
- However, Live connection surpasses DirectQuery in terms of query performance, primarily because it exclusively supports Microsoft data sources such as SQL Server Analysis Services database, Azure Analysis Services database, and Power BI datasets.
- Live connection provides performance, scalability, and enables seamless data updates.
0 comments:
Post a Comment