Forum Discussion

Tom-ADV's avatar
Tom-ADV
Frequent Visitor
3 years ago

Getting "Bad Request" for BindToGatewayInGroup() although nothing seems to be wrong

I'm working on an automation which should export an existing report, import it to a new workspace and bind it to a new Datasource.   The problem is that when executing the BindToGatewayInGroup, I g...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Tom-ADV ,

I found some links which has the similar problem as yours, please check if their solution. Hope they can help you resolve the problem.

powerbi-powershell/bindtogateway.ps1 at master · Azure-Samples/powerbi-powershell · GitHub

 

Solved: Enterprise Gateway refresh error to on-premise SQL... - Microsoft Power BI Community

the Tech Staff told me that 400 error was about a PowerBIErrorCode: DMTS_CanNotFindMatchingDatasourceInGatewayError.

 

The enterprise gateway was not able to find all datasource, even if on the first check it was.

 

Solutions is to manually check all the datasource of the report and all the datasource on the enterprise gateway.

Re: gateway "not configured correctly" - Microsoft Power BI Community (Check message 10)

 

Solved: Re: Power Bi gateway "not configured correctly" - Microsoft Power BI Community

I have found out the issue. There were two data sources in my dataset. One onpremise sql server and other one is excel file stored in one drive. 

In Gateway Cluster Settings I have not ticked "Allow user's cloud data sources to refresh thorufh this gatway cluster" option. After ticked it and saved it. I was able to setup the gatway connection. 

Best Regards