cannot auto refresh PBI in computer - personal gateway

[pang22]

Hello,

I import data from SQL server. Then I build the dashboard and set the personal gateway in my computer for auto refresh.

But it cannot auto refresh. How to fix it?

Thanks.

[Anonymous]

Hi  @pang22 

1. Can you refresh your data in Power BI Desktop? 

2. Is your personal gateway up to date?

3. Did you configure your credentials in dataset settings ? 

4. Did you make sure you are connecting to the data source using Import's connection mode and not DQ's connection mode?

Best Regards,
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.

[pang22]

Hi @Anonymous Thank you

1. Can you refresh your data in Power BI Desktop? - Yes

2. Is your personal gateway up to date? - How to check whether it's up to date?

3. Did you configure your credentials in dataset settings ? - Yes. I have configured the credentials and input the account and password.

4. Did you make sure you are connecting to the data source using Import's connection mode and not DQ's connection mode? - It's import connection

[Uzi2019]

Hi @pang22 
where is your SQL server installed??

[pang22]

@Uzi2019 Thank you.

We use SQL Server Management Studio to store the data.

[Uzi2019]

Hi @pang22 
It must be store somewhere right on Remote server???

If my post helps please give kudos and accept it as a solution!

[Uzi2019]

Hi @pang22 
If your SQL server installed on RDP or on cloud then you need to install Standard mode on RDP server.

If my post helps please give kudos and accept it as a solution!
Thanks

[amitchandak]

@pang22 , Install oledb 12 driver and try again

https://www.microsoft.com/en-in/download/details.aspx?id=13255

[pang22]

@amitchandak Thank you.

I have installed oledb 12 driver and click refresh but still appear the above messagae. Do I need to do any setting on the refresh?