Local Gateway and connection - Login error

Hi guys,

I try to build a gateway in my Power BI service.

I use a Power BI Pro license (with an onsitemicrosoft.com account) and it is a local gateway (standard mode). The data sources are a xlxs- and a csv-file and are saved on my local computer. The account for my windows runs under a outlook.com account and not under the onsitemicrosoft.com account.

If I try to connect to the files in the seetings window of a connection (Power BI service), I got alway the message that the login information are invalid.

I already tried all possible option in the authorizations for both data sources in the data source configuration window of Power BI desktop with a corresponding adjustment in the settings for Windows authorization. But nothing worked.

Do you have any idea what the reason for this could be?

Thanks in advance!

Best,

THA