I am somewhat new to PowerBI. I am trying to use multiple data sources located on the same server. There are two separate databases with different credentials. I am using import mode to connect.
So lets say I have DB1 and DB2 is on server P and each has a user DB1_user and DB2_user.
Once i connect to DB1 with userid DB1, when i try to create a query for DB2 then the query which i created for DB1 says invalid credentials. It gets updated to the credentials of DB2 database. I am not sure how to have two data sources with separate crentials in one report. Is this possible? I am using PowerBI report server version March 2018.