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.
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.
All items updated. No change in behavior.
We have been successfull in getting some queries to run by removing a table. not a specific table, just a table. i feel like our sql server may have seen an update and now some joins are causing issues.. they arent complicated joins. Worse yet i had some working, and now they are failing.. is there some kind of log that is filling up somewhere?
Thanks for any suggestions.