cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nick93 Member
Member

Error updating Power BI Service dataset from SQL table through Direct Query

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:

 

Immagine.png

 

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

4 REPLIES 4
quentin_vigne Senior Member
Senior Member

Re: Error updating Power BI Service dataset from SQL table through Direct Query

Hi @nick93

 

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.

 

- Quentin

nick93 Member
Member

Re: Error updating Power BI Service dataset from SQL table through Direct Query

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.

quentin_vigne Senior Member
Senior Member

Re: Error updating Power BI Service dataset from SQL table through Direct Query

@nick93

 

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 ?

 

- Quentin

nick93 Member
Member

Re: Error updating Power BI Service dataset from SQL table through Direct Query

I have it on my PC, I installed it here.

When I turn my PC on, why doesn't it update 15 minutes later instead of 4 hours?