Connecting to data sources within Power BI Report Builder

Power BI Report Builder offers a variety of data source options to meet the diverse needs of its users – whether that is connecting directly to the data source or connecting to a data source that has already been curated and published to the Power BI service. Here is an example screenshot of the connection types available when creating a data source with Power BI Report Builder:

Figure 13.2 – Data Source Properties showing connection types available

This includes the following connectors:

• SQL Server: Connect to Microsoft SQL Server databases, allowing users to pull in data directly from relational databases
• ODBC: Can be used to access data from Excel workbooks, enabling users to incorporate spreadsheet data into their paginated reports
• Power BI datasets: Connect to semantic models in Power BI to integrate published data into paginated reports
• Other databases: Power...