Custom SSRS report throws dataset error when using Live datasource

Custom SSRS reports works in Report Builder, but throws a dataset error after switching to Live datasource

• SSRS Reports

• SaaS hosted clients

• EERP all versions

Dataset error is caused when the SQL query used in the dataset is using deprecated views or base tables. 

In order to resolve this error, review the existing query in the dataset and replace any deprecated views or base tables with TRS views.

If a TRS view could not be used, please reach out to EERP Reporting Services Support team as additional permissions will need to granted manually in SQL database server.