Forum Discussion

pang22's avatar
pang22
Icon for Helper III rankHelper III
2 years ago

cannot auto refresh PBI in computer - personal gateway

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.

 

 

Need Help

8 Replies

    • pang22's avatar
      pang22
      Icon for Helper III rankHelper III
      2 years ago

      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?

    • Uzi2019's avatar
      Uzi2019
      Icon for Community Champion rankCommunity Champion
      2 years ago

      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

    • pang22's avatar
      pang22
      Icon for Helper III rankHelper III
      2 years ago

      Uzi2019 Thank you.

       

      We use SQL Server Management Studio to store the data.

      • Uzi2019's avatar
        Uzi2019
        Icon for Community Champion rankCommunity Champion
        2 years ago

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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      pang22
      Icon for Helper III rankHelper III
      2 years ago

      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