Nullable object error message on almost all tables but ERP dev can access on their end?

Hello!

I'm having this same error message occur on most of my tables trying to access the data. I can view pretty much any "view" but when I try to access a "table" the below error message occurs (first pic). I was able to access these at one point however they stopped working and have not been able to use them since. We've coordinated with our ERP developers and they are able to access the data tables on their end using our same credentials. Specifically this what they said "I’ve configured the ODBC on my end and within Excel I am able to successfully access both Tables and Views with the xxxx User". I've attached the picture of him showing me this works. He has said that he believe it's a Power BI issue. 

Does anyone have advice on how to resolve this? The "views" don't provide the same information necessarily as the tables do. And some tables I can access - but the majority do not. I don't want to extract to excel because that would defeat the purpose of having power bi connect to the data base. If I did it the excel way I'd have to manually update the excel sheet instead of it just refreshing with the latest data straight from our ERP.

Thank you in advance!