I have SQL Server 2012 with SP 2 and Report Builder 3.0. I've created a shared data source in Report Manager, then created a shared dataset in Report Builder and saved into Report Manager. I can see the shared dataset in Report Manager and it does show the data source under dependencies as does the data source showing the dataset.
When I create a new report in RB, I add the shared data source, test connection and all fine. However, when I go to add a dataset, there is nothing listed in the shared datasets, even though I've created multiple.
If I create an embedded dataset everything is fine but need to use shared as I will be creating many reports. I am logged in as an administrator, my login has full permissions in RM, full access to the database from the datasource etc.
Why can I not see any of my shared datasets?
When I create a new report in RB, I add the shared data source, test connection and all fine. However, when I go to add a dataset, there is nothing listed in the shared datasets, even though I've created multiple.
If I create an embedded dataset everything is fine but need to use shared as I will be creating many reports. I am logged in as an administrator, my login has full permissions in RM, full access to the database from the datasource etc.
Why can I not see any of my shared datasets?