Gateway is not working when report uses Store procedure.

[Anonymous]

Hi Team,

I have report which uses Store procedures ( EXEC statement ) and it works perfectly in Power BI desktop, when published on service, it returns Gateway is not reachable error. When same report uses Views, Gateway is connecting fine. 

Could you please help me resolve this issue.

Thanks,

Shubham

[v-robertq-msft]

Hi, @Anonymous 

According to your error message, it said that your gateway is unreachable. Have you configured the data source in your gateway and mapped the dataset to the corresponding data source in the “Gateway connection”?

Here’s the Microsoft gateway trouble shooting about this problem, you can take a look:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot#error-power-bi-service-reported-local-gateway-as-unreachable-restart-the-gateway-and-try-again

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.