I created a Power BI Desktop report using SQL Server table with a direct query data connection and then I brought it in Power BI Service choosing planned update every 15 minutes. When my PC is on it works fine, but when I switch it off and then turn it on the following morning, I see my dataset (and so my report and my dashboard too) didn't update during the night and I gain the warning message next to the dataset:
An unknown error occurred. Try again. If the problem persists, contact support. Try later or contact support providing following information. (I don't see anything else).
If I open my dashboard, I see warning message next to every graph:
It hasn't been possible to recover data for this graph. Try again later. Try again later or contact support specifying the following information:
I turn my PC off at 6 p.m. and switch it on at 9 a.m. the following morning. I always see last update made at about 6.30 p.m. and the next one planned for about 1 p.m. (I planned updates every 15 minutes). However, at 1 p.m. it updates fine, and if I change update frequency, for example turning it to 30 minutes or changing it and then taking it back to 15, I works fine and the planned time is taken at 15 minutes later that moment and not at about 1 p.m. anymore.
Why does it work this strange way? Am I missing something?
Thank you very much
Where did you install your gateway? On the server or on your computer ?
If it is on your computer it is normal that the refresh stop, because the gateway need to be installed on a place that does not stop.
Thank you Quentin. I am almost sure I installed it on my computer. How can I be sure of it? And how could I install it on the server? Can I do it now? Anyway, I don't understand why it updates 4 hours later than the time I swtich my PC on.
When you turn your computer off, the gateway is off. When you turn it on, it goes back online.
Do you have the personal gateway or the on-premise one ?