Table of contents :
$\color{3D47CD}Pros$ Power BI mainly supports two connection modes : Import and DirectQuery, allowing seamless integration with the Microsoft ecosystem, including Azure and Excel. Power BI offers a wide range of connectors, such as databases, cloud services, and files.
$\color{3D47CD}Cons$
DirectQuery needs a very strong and optimized database underneath.
$\color{3D47CD}Pros$
Tableau Software offers a wide range of connectors, including databases, cloud services, and files, allowing it to connect to data sources either Live or Extract.
$\color{3D47CD}Cons$
The initial setup for connecting to numerous data sources can be complex, and live connections may lead to performance issues when handling large datasets.
$\color{3D47CD}Pros$
Looker Studio is designed to connect directly to data warehouses like Google Big Query. Live connexion will automatically add the updated data from these sources to your report.
$\color{3D47CD}Cons$
Looker studio relies only on live connexion, which may not be suitable for scenarios requiring offline access.