Video Resources

How-To Connect To A Local Data Source

1. Open Power BI Report Builder.

2. Select “Blank Report”.

3. Right click Data Sources.
    - Select “Add Data Source”.

4. Let's connect to a local SQL Server and build out connection string.

5. Enter the Server Name (PBIDEV).
    - Select a database (AdventureWorksDW2017).
    - click “OK”.

6. Test Connection, give it a name (awdw).

7. Right click on “Datasets “.
    - Select “Add Dataset”.

8. Select our new data source and click “Query Designer”.

9. We now have access to a local data source.