1 of 1 people found this helpful
The behavior you're describing is by design, to prevent users from seeing data they shouldn't while in web edit mode. You can use the following options:
Publish the data source, replace the connection in the workbook with the published data source, and then publish the workbook.
Create an extract connection of the data source before publishing.
Hope this helps,