Forum Discussion
Gateway is not working when report uses Store procedure.
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
1 Reply
- v-robertq-msft
Community Support
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:
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.
