After going through different methodes I found online, I found that adding the override property to the load_dotenv() like this load_dotenv(override=True) resolved my issue.
load_dotenv()
load_dotenv(override=True)