What are the different connectivity modes in Power BI?
Deepaverma
0
10
Power BI offers several connectivity modes that define how it interacts with data sources, allowing users to access and visualize data in various ways. Each mode has its specific use case depending on performance, data refresh needs, and data size. Below are the main connectivity modes in Power BI:
1. Import Mode
- Description: In this mode, Power BI imports the entire dataset from the data source into its internal memory. All the data is stored in the Power BI model, and users can interact with the dataset without needing to reconnect to the source for queries.
- Performance: This mode provides high performance since the data is loaded in memory, allowing fast response times for queries and interactions.
- Data Refresh: The data needs to be refreshed periodically (manual or scheduled refreshes) to keep it updated. This is especially important for static or semi-static data sources.
- \
