October 14, 2007 at 7:08 pm
In sql 2005 Business Intelligence Studio I created a Report Model Project and defined the data source, data source view and a report model. I can preview the data in the BI studio. I selected 3 tables, defined relationsships and added a "named" query. Build succeeded as did deploy. Report builder finds the report model but reports "selected data source does not have any content available"
May 23, 2008 at 7:24 am
Hi - did you ever find the solution to this problem? I'm having the same issue, have already set the primary key as some posts have suggested, and still get the same message..
Thaks a lot
Roney Pate
October 22, 2008 at 12:48 pm
Add the serverName and the database name in Connection string when you create the data source:
Data Source=DatabaseServerName;Initial Catalog=DatabaseName
🙂
Manish Kumar
October 22, 2008 at 3:20 pm
could you tell if the dev database and prod database are the same ? In any case you need to mention database connection values.
Hope this helps,
Rajesh
February 19, 2009 at 9:33 am
I am now having this problem. My models have worked in the past. My connection string has tested successfully and is used in other reports within RS.
What bothers me the most about this issue is that there have been many posts since 2007 and nobody has found a solution.
Sadly I think I can add this feature to my ever growing list of "Does Not Work" regarding Reporting Services.
May 8, 2012 at 1:04 pm
I had similar problem. I fixed one view that did not have PK and deleted model, recreated a new model with same name and rebuild it all and redeploy and all worked fine after that.
I hope that helps.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply