The three major connectivity modes in Power BI are: Direct Query: The method allows direct connection to the Power BI model. The data doesn’t get stored in Power BI. Interestingly, Power BI will only store the metadata of the data tables involved and not the actual data. The supported sources of data query are: Amazon Redshift Azure HDInsight Spark (Beta) Azure SQL Database Azure SQL Data Warehouse IBM Netezza (Beta) Impala (version 2.x) Oracle Database (version 12 and above) SAP Business Warehouse (Beta) SAP HANA Snowflake Spark (Beta) (version 0.9 and above) SQL Server Teradata Database