Forum Discussion
Odbc Error when refreshing
Hi v-qiuyu-msft,
After a few days of testing, we have found that these have been network issues for within the office - we have some serious IP issues ongoing and as a result, switching the datasource did not help. I even created a new pbix file to use MYSQL database but refresh did not go through, whereas at home, i was able to run it without a hitch.
I have now resolved this by actually switching out from a desktop to a windows server on aws, and a couple of days in and the refresh runs well and takes less one third the time is used to - barring some import errors while publishing which persisted last night, i think this solution is working well :)
Hi S_M,
Both personal gateway and data gateway are available for pro user. In your scenario, if you publish the report to Power BI Service, you need to configure gateway like mentioned above. As both ODBC and MySQL are not in cloud, while the Power BI Service is in the cloud, it requires gateway to communicate each other. If you only refresh report in desktop, gateway is not required.
Best Regards,
Qiuyun Yu
Hi S_M,
Was the issue solved after updating Power BI Desktop version and change to use MySQL database type data source?
Based on my research, the issue may be caused by that the Firewall settings. See: Connect to a remote MySql database with obdc. Also please enable Power BI Desktop trace log files to see if you can find any useful information when the refresh is failed.
Best Regards,
Qiuyun Yu
Hi v-qiuyu-msft,
After a few days of testing, we have found that these have been network issues for within the office - we have some serious IP issues ongoing and as a result, switching the datasource did not help. I even created a new pbix file to use MYSQL database but refresh did not go through, whereas at home, i was able to run it without a hitch.
I have now resolved this by actually switching out from a desktop to a windows server on aws, and a couple of days in and the refresh runs well and takes less one third the time is used to - barring some import errors while publishing which persisted last night, i think this solution is working well :)
Hi S_M,
Glad to hear you find the solution of ODBC error. By the way, to publish the report to Power BI Service, you need to configure corresponding ODBC or MySQL data source under data gateway.
To publish the report, you can use Publish feature in desktop directly, or you can also get .pbix file in Power BI Service via Get Data->Files->Local Files.
Best Regards,
Qiuyun YuThanks v-qiuyu-msft!
Do i need to do the above configuration even if i am a free user ? Because i currently dont use a personal data gateway, as i am not a pro user, but i am facing a '(FailedToRefreshpackageAfterimport)' atleast once a day (i have data refreshing on an hourly basis and the data size is not large)
Hi S_M,
Both personal gateway and data gateway are available for pro user. In your scenario, if you publish the report to Power BI Service, you need to configure gateway like mentioned above. As both ODBC and MySQL are not in cloud, while the Power BI Service is in the cloud, it requires gateway to communicate each other. If you only refresh report in desktop, gateway is not required.
Best Regards,
Qiuyun Yu
Hi,
I have the same error, but i check connection with the server and don't exist any problem.
Hi,
I have the same problem, but on my case don't exist any problem of connectivity with de server.
something else can i check?
