No projects were returned by this project source

If no projects are returned by MicroStrategy these could be reasons.

1. Run License Manager and check that you have MicroStrategy Desktop and MicroStrategy Architect among Installed Products.
2. You enabled anonymous authentication. The Guest user is a member of the Public group. By default, this user group does not have access to any projects in the project source. Revert back to Standard authentication, Administrator -> User Manager -> Public/Gest -> project Access. Set the access and privileges desired for the guest login.
3. You are trying to connect to a Microsoft Access database with database authentication. Microsoft Access does not support database authentication.
4. Similar to #2, LDAP user ID and password blank would lead to no project(s) when using LDAP authentication.

Sometimes a faulty installation is needed to be repaired.

But mostly, I have found the issue to be user not given right privileges, not connecting to right Project source or metadata corruption.

Migrating a 2 tier project source to a 3 tier source

Technically, you don't really require anything to make a 2 tier, just configure it using configuration manager (your access file). 2 Tier connection is also possible for a Oracle, SQL Server, or any other database.

There are two ways one can migrate a 2 tier (access) based project to Excel.

1. Project duplicate using Project duplication wizard or Object manager.
2. Import the access database into your relational database (Using ETL)