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.
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 ...