Set different credentials in one connection string for cloud data source connection

I understand this is limitation of the cloud data sources that when connecting to the cloud data source, it is not possible to have multiple credentials for a single connection string. But I would like to be able to register multiple credentials. // example 1. Create schema 01, schema 02 in Azure SQL Database 'Database 1', set the users that can be referenced respectively, and separate the data that can be referenced by this schema. 2. Create reports 01 and 02 connected to Azure SQL Database 'Database A' in Power BI Desktop using each schema and publish them to the Power BI service. Database 1 - Schema 01 (user A) <　Use this schema to create report 01 - Schema 02 (User B) < 　Use this schema to create report 02 3. Set their credentials for the dataset associated with each report. 　 (1) Dataset 01 is connected by user A (2) Dataset 02 is connected by user B 4. For dataset 01, the credentials of user B set later are overwritten and the refresh fails.