Please be aware of that fact that PowerBI has issues if you use an "umlaut" ((the two dots above the vowel) within your credentials.
PowerBI will not be able to authenticate successfully against the Backend of OfficeExpert (although the credentials just work fine if you authenticate directly against OfficeExpert )