Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Gateway Issue

  Description: We are encountering a recurring issue with our Power BI gateway. The error message we're receiving is: Data source error: {"error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderOpen...
Need Help
BPino's avatar
BPino
Frequent Visitor
2 years ago

I have the same issue since 28th January 2024: DM_GWPipeline_Gateway_AdoNetProviderOpenConnectionTimeoutError

 

We have one cluster with 2 gateways. I upgraded and restarted both of them.

 

I also tried to make an smaller dataset (with less and simple queries), but the error still appears in most of tests and it seems not to explain the reason of this error.


Has anyone find the cause of this error?

 

Thanks

  • BPino's avatar
    BPino
    Frequent Visitor
    2 years ago

    I couldn't find out the reason for this error but at the end we could refresh datasets correctly!

     

    I try to explain our issue in case it helps someone else:

    We got the mentioned error (DM_GWPipeline_Gateway_AdoNetProviderOpenConnectionTimeoutError) with

    scheduled and on demand refreshes (both via Power BI Service).

    After several days investigating this issue, we configured a flow through Power Automate and the corresponding refresh worked. And after that... surprise! on demand refreshes work again!

    The "x-file" is that when the scheduled refresh is executed again, it doesn't work and the next on demand refresh fails too...

    Conclusion: scheduled refreshes make any other refresh don't work. Why? I don't know...

     

    I enclose an image with some sequential refreshes executed through different ways, where you can see what I've tried to explain.

    Note: the first following API refresh after a failed refresh, failed too but not subsequent ones.

     

    I hope it helps anyone else ğŸ˜‰