Employee table not recognized when editing and previewing reports in SSRS

Version 1

    Details

    When editing or previewing some delivered reports in BIDS/SSRS, error messages are displayed saying the Employee table is not found.


    Note: This only affects tenants created prior to version 2014.2. (pre-MCT)

     


    Resolution

    The database structure for Employee records was different prior to 2014.2, and the Employee table was named Profile. The application should convert this reference when the report is run directly, users will only run into these errors when working in SQL. Doing a search and replace of Employee to Profile should solve the issue with any report they want to be able to update.