Working with published data sources

So far, you've already been working with data sources that were published back in Chapter 3, Advanced Report Authoring with SQL Server Data Tools. What if you want to create a new shared data source?

Unfortunately, there is no direct method to create a shared data source within Report Builder. However, we can create it within the Report Portal, and then use it in Report Builder.

Let's see how to do that with this recipe.

Getting ready

For this example, we're going to use the WideWorldImporters database, not the Data Warehouse (DW) version.

We'll use report builder later in this recipe, so go ahead and open report builder if it is not open to bring up the Getting Started window, or go to File | New in order to bring up the New Report or Dataset window. Both windows will achieve the same goal, letting us start a new report.

How to do it...

1. Open your web browser, and navigate to your Report Portal.

2. You should see a folder, Data Sources. Click on it to open it.

3. In...