Forum Discussion
Power BI refresh error
Hi
I have problem with Power BI refresh.
When I refresh data "On demand" status is "completed".
When I schedulet refresh i have status "Failed" with error - Your data gateway is offline or couldn't be reached.
| Processing error: | Your data gateway is offline or could not be reached. Ensure the computer running the gateway is on during the refresh period. |
| Cluster URI: | WABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net |
| Activity ID: | 9bb2eff9-3eaf-4069-b304-a4f1abc600af |
| Request ID: | 19d2b000-5ffb-4c6c-9c7f-aed2d3485ca9 |
| Time: | 2024-09-23 03:02:11Z |
This error start two weeks ago. Before that everything was OK.
I hope you can help ?
Arnis
Hi, Anrijs
You can configure your credentials as shown below. Scheduled refresh will work only if your credentials are configured correctly:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
10 Replies
Hi Anrijs, Can you please share the detail about which type of gateway you are using, is it
- On-premises data gateway (standard mode)
- On-premises data gateway (personal mode), known as a personal gateway.
- Virtual network (VNet) gateway service.
Hi
I use
- On-premises data gateway (personal mode), known as a personal gateway.
Arnis
Please check your data gateway where it's installed. Is it on some server?
Solved: Your data gateway (Power BI – personal) is offline... - Microsoft Fabric Community
Hi
Yes, is it on the same server.
Arnis
click on your online workspace or where you are loaded your semantic model.then click on your semantic model schedule refresh.then click on gateway and cloud connection and then manager connections and gatewy.under connection heading click check status, click on round arrows if they are not online then contact your database support team or check your database connection.
Hi
All my connections is on.
Still i have random refresh problem.
Work and dont work.
Any suggestions ?
Arnis
Hi
1) I use Personal mode Gateway on-premises.
2)Gateway is in local network(server)
3)
I think i need remove data source (in red) and then plan data refresh.
Any other ideas ?
Arnis
Thank you Kaviraj11 ， 123abc and anmolmalviya05
Hi, Anrijs
Since On-premises Gateway Personal Mode does not run as a service, if your computer is shut down and restarted, it usually does not run automatically, and you need to manually open the On-premises data Gateway Personal Mode software.
I did a simple test on this:When I open the On-premises Data Gateway Personal Mode and log in to the relevant account:
And then in the power BI service, you'll see that our connection is online.
You can refer to the official documentation below:
Use a personal gateway in Power BI - Power BI | Microsoft Learn
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
- PC with Gateway is always on.
- All my "Manage Connections and Gateways" connections is on.
- When i scheduled refresh i have error and when i start on-demand(manual) no error. Why?
Why so random refresh work normal un then error ? Any suggestions ?
Arnis
