Forum Discussion
Power BI Refresh Needs Local Service – Any Workaround?
Hi Divyanshu15,
Thank you for reaching out to the Microsoft Fabric Forum Community.
Please refer to the following documentation to help resolve the issue.
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
If this information was helpful, kindly mark the response as accepted and give it a thumbs-up, so it may assist others as well.
Best regards,
Prasanna Kumar
Hi Divyanshu15
Yes, you can enable scheduled refresh using an on-premises data gateway installed on the same local machine where the ODBC driver and background service are set up. The gateway allows Power BI Service to access your local setup and refresh the data, even if the database is cloud-hosted but needs a local initiation step. Just make sure the background service runs automatically and the gateway is always online.
Hi Poojara_D12
Thanks for the Reply Poojara_D12 , I've subscribed yourt work on youtube
Yes, I tried to set up the background service. But I didn't get success for the Clickhouse, Postgresql got connected successfully, can you help me with the resources to set up the background service to initialize the connection after the system is on.
Please help with the resources
Best
Divyanshu
Hi Divyanshu15
Thank you for subscribing.
In your case, you're using cloud-hosted ClickHouse and PostgreSQL databases that require a local background service and ODBC setup to connect. While Power BI Desktop works fine after manually running a command to activate the connection, scheduled refresh in Power BI Service fails because it can’t access your local setup. The best workaround is to use an on-premises data gateway, which allows Power BI Service to securely delegate the refresh task to your local machine. To make this work with ClickHouse, you should automate the startup command (the one you currently run manually) using tools like NSSM to run it as a Windows service or set it as a scheduled task at system startup, ensuring it initializes before the gateway attempts the refresh. Use a System DSN and ensure both the service and gateway are always running.
Hi Poojara_D12
I tried the steps that you're suggesting, If you can come up with me on screenshare and troubleshoot for me
It will be very useful for me
So can you help me with the same?
Thanks