One of my report having database and Sharepoint , while deploying its throwing error DMTS_CanNotFindMatchingDatasourceInGatewayError in the databind.

[mohanraja99]

Describe the issue
few of my reports having database and Sharepoint , while deploying its throwing error DMTS_CanNotFindMatchingDatasourceInGatewayError in the databind.

**Extension **

• Extension: Gateway Bind
• Version: 5.4.54

To Reproduce
Steps to reproduce the behavior:

1. the pbix file having database and sharepoint connections

2. update the parameter
   example : [{ "name": "Server", "newValue": "myserver01" },{ 'datasourceSelector': { 'datasourceType': 'sharePointSiteUrl', 'connectionDetails': { 'url': 'https://my.sharepoint.com/sites/mybuiss/' } } }]

3. try to Gateway Bind

4. we can see the error "DMTS_CanNotFindMatchingDatasourceInGatewayError"

Note:

1. manually able to bind the getaways/datasource for the reports.
2. if only the report has only DB connection, it's working as expected.

Expected behavior
its should bind both DB and Sharepoint gateways/datasources.

We are a few reports having a SharePoint connection.

Situation (please complete the following information):

• Agent type:
• Autentication:
• Extension Version:

Log info
##[error]DMTS_CanNotFindMatchingDatasourceInGatewayError

Additional information

1. We are using Azure devops classic pipeline.
2. multiple workspaces for each environment(around 200 reports).
3. Do we have a yaml script help us to loop the deployment.?

[maikvandergaag]

Which type of authentication are you using?

[mohanraja99]

[maikvandergaag]

Oke user or application

[mohanraja99]

User, we are using a service account and provided admin access to every where

[mohanraja99]

We implemented our extension for one of the US government clients and blocked the two issues. Could you help us with the bugs mentioned below? [image: image.png] --

…

On Wed, Jan 22, 2025 at 12:22 AM Maik van der Gaag ***@***.***> wrote: Which type of authentication are you using? — Reply to this email directly, view it on GitHub <#570 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEC4NFNU3OAVUJIMV7WH45T2L2JPLAVCNFSM6AAAAABVTGCMHGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMMBVGUYDEMJQGQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>

-- *Thanks and Regards,* Mohan Raja (M.v.v.s.g Raja Gajula) (Mobile 1 #) +91 9989777899 (Mobile 2 #) +91 9989697099 (secondary)

[maikvandergaag]

For as far as I know there are limitations when using a data gateway. Did you try exporting the powershell and then uploading the powerbi boards?

[mohanraja99]

We didnt try/used Powershell (due to security issues), previous/existing deployment is manual via powerBi desktop.

…

On Mon, Jan 27, 2025 at 4:53 PM Maik van der Gaag ***@***.***> wrote: For as far as I know there are limitations when using a data gateway. Did you try exporting the powershell and then uploading the powerbi boards? — Reply to this email directly, view it on GitHub <#570 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEC4NFM2OFR5VINH2OTRTMD2MYJMDAVCNFSM6AAAAABVTGCMHGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMMJVGQ4TENRUGM> . You are receiving this because you authored the thread.Message ID: ***@***.***>

-- *Thanks and Regards,* Mohan Raja (M.v.v.s.g Raja Gajula) (Mobile 1 #) +91 9989777899 (Mobile 2 #) +91 9989697099 (secondary)

[maikvandergaag]

Are you able to try an export of the Powershell scripts? Besides that is the agent that deployes able to connect to the gateway?