Forum Discussion
Refresh the ODBC data only on request.
I'm working on a Power BI Report. I'm making changes on Power Query.
The data source is with an ODBC connection. I don't have access to the database from home.
My problem is that Power BI refreshes systematically the source and try to connect to the database after each Power Query changes.
Message:
"ODBC:ERROR[HY000][MySQL][ODBC 8.0(w) Driver]Client with IP adress... is not allowed to connect to this MySQL server."
Would it be possible to update the source only on request?
Thank you in advance.
Hi Anonymous ,
Currently in power bi, each time you refresh the data source, power bi will check your credentials connection whether you have access to visit the data source at first.
Update the source only on request based on power bi desktop is not supported for safety.
In addition, based on the error message and you have no access to the data source from home, you can check the firewall first and try to grant permission in mysql like:
GRANT ALL ON *.* to root@'x.x.x.x' IDENTIFIED BY 'your-root-password';You can refer this article for more details: MySQL – Connection Error – [MySQL][ODBC 5.3(w) Driver]Host ‘IP’ is Not Allowed to Connect to this MySQL Server
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
yes its totalle possible, for this you can use a power automate flow that come with a refresh dataset option, you can use any trigger you like from it a email with a specific topic, a power apps botton with the flow on it as trigger etc
here read this article about it:
https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
if this solved your question please mark it as solution for others to find it, and if you liked give some kudos 🙂
not a power bi setting, its a power automate flow, its part of the power plataform of microsoft, inside power bi service on the workspace also you can manually refresh the data, if you want to refresh it without entering to the service the other options are the one I pass on that link, basically you select a trigger, a email, botton on power apps etc and then select witch dataset will be refreshed. the link give a step by step guide on ocnfigurating this.
Hi Anonymous ,
Currently in power bi, each time you refresh the data source, power bi will check your credentials connection whether you have access to visit the data source at first.
Update the source only on request based on power bi desktop is not supported for safety.
In addition, based on the error message and you have no access to the data source from home, you can check the firewall first and try to grant permission in mysql like:
GRANT ALL ON *.* to root@'x.x.x.x' IDENTIFIED BY 'your-root-password';You can refer this article for more details: MySQL – Connection Error – [MySQL][ODBC 5.3(w) Driver]Host ‘IP’ is Not Allowed to Connect to this MySQL Server
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
