My problem was with permissions to the folder access in Report Manager. If I recall correctly the users that were having problems only had access to a folder under Home where their Models reside. The SQL data source lives in different folder under Home. Once I gave users Browse access to Home then it eliminated the error, seemed like a pathing situation related to permissions.

Hope this helps.