<img alt="" src="https://secure.hims1nice.com/151009.png" style="display:none;">
Skip to main content

How-To Connect To A Local Data Source

How-To Connect To A Local Data Source

The Advanced Analytics Group can help you unlock the full potential of your data.

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.


From database architecture and design to the deployment of best in class data platforms and business intelligence tools, the Advanced Analytics Group can transform complex data into insights which drive digital transformation.

At its core, you’ll gain access to our architect’s depth of experience and wealth of knowledge in Microsoft 365 solutions and capabilities with a focus on management, security, and compliance.

We want to hear from you! If you have any questions about our services, our culture, employment at KiZAN, or need support, click the button!