Login
Remember
Register
Ask a Question
What are the different modes of connectivity in Power BI?
0
votes
asked
Jan 26, 2024
in
PowerBI
by
GeorgeBell
What are the different modes of connectivity in Power BI?
powerbi-interview-questions-answers
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jan 26, 2024
by
GeorgeBell
There are three different types of connectivity in Power BI, which are as follows:
Import Mode : Import mode is the default mode that is used most frequently. It delivers fast performance and can be easily integrated with the data sources. Imported data gets stored in the disk and is loaded while refreshing or querying.
Direct Query Mode: It is another method that helps in importing data with a query to retrieve data easily from the pre-existing source of data. You can use DataQuery to avoid refreshing data when the data volume is large.
Composite Mode: This mode is the combination of both the import and DirectQuery modes. Composite mode helps calculate tables, which DirectQuery cannot.
...
