Learn Power BI

Power BI Report Builder uses Power Query to connect to a data source

Power BI Report Builder allows the user to merge data from multiple data sources, such as flat files, oracle and SQL server databases, and google sheets

Power BI Report Builder imports entire tables. It cannot use SQL queries to aggregate or limit the rows imported.