Forum Discussion
Date Load errors
DanielDiAngelo
Have you try update the ODBC connector and Personal gateway to new versions.MySQL :: Download Connector/ODBC
Power BI Gateway | Microsoft Power BI
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.YES! it was a networking issue. We had a switch that was limiting throughput. The common feature to our failing queries was record counts. The big stuff would fail. Infrastructure opened up the bandwidth filter and we have been stable since. We are usinging a personal gateway so everything goes through our local network on its way to the MS servers.
Good luck.
I got the same problem, do you have any updates?
YES! it was a networking issue. We had a switch that was limiting throughput. The common feature to our failing queries was record counts. The big stuff would fail. Infrastructure opened up the bandwidth filter and we have been stable since. We are usinging a personal gateway so everything goes through our local network on its way to the MS servers.
Good luck.
I'm having the same issue as well. How do you open up the bandwith filter to let more data to load? I'm using my work laptop to refresh which is where my on premise gateway is.
It was a firewall in our network hardware. our infrasctructure team is who handled the fix. if you are responsible for the hardware also, try searching the internet for your model/software.
Note a laptop for auto refreshing isnt always the best, as the gateway needs to be on the network when doing the updates.. wifi, VPNs etc are all now in play as pinch points if you are not hardwired.
