Forum Discussion
Auto refresh dataset from MariaDB without personal computer
Hello, I need help to set auto refreshing dataset from MariaDB even when my computer is offline.
Is it possible. What should I do? I got Power BI Pro license.
Hi dzhan
If you want to refresh your dataset in Power BI Service, you need install the gateway on a computer running 24 hours . When you configure the gateway successfully , you can add MrriaDB data source in Manage gateways .Currently , Service supports the data source you used. Since I don't have the same database as you, there is no way to provide the steps. But you can refer to the configuration method of SQL data source, I have provided the link to you .
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql
One more thing to note : Not all computers are suitable for installing gateway, you can find some restrictions and requirements for installing getaway from the link below.
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi dzhan
You should look at installing On-Premises Enterprise gateway on a VM which remains online 24*7, also I believe you will be using Custom connector for MariaDB so have a look at below post on how you can configure it:
https://community.powerbi.com/t5/Service/Mariadb-connector-in-on-permise-Gateway/m-p/1446167
Hi dzhan
If you want to refresh your dataset in Power BI Service, you need install the gateway on a computer running 24 hours . When you configure the gateway successfully , you can add MrriaDB data source in Manage gateways .Currently , Service supports the data source you used. Since I don't have the same database as you, there is no way to provide the steps. But you can refer to the configuration method of SQL data source, I have provided the link to you .
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql
One more thing to note : Not all computers are suitable for installing gateway, you can find some restrictions and requirements for installing getaway from the link below.
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
