Forum Discussion

shanjaf's avatar
shanjaf
New Member
10 years ago

how to schedule refresh for the dataset using on-prem sql database with option 'Import'

Hi All, how to schedule refresh for the dataset using on-prem sql database with option 'Import' instead of Direct query. Can some one guide me how to schedule when we use 'Import' data.
Need Help
THEG72's avatar
THEG72
Icon for Helper V rankHelper V
8 years ago

Hi Anonymous


Thanks for your advice it was spot on. One of my queries used local host instead of the server name like the other queries...given i didnt have localsource as a server name in the managed gateway section it greyed out the Refresh options.

 

Can you have localhost as a server name when setting up a gateway? Is it better practice to put the name in or not if localhost works?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

THEG72 Avoid the "Localhost", it will just cause problems (like this use case). Even if it would work, it would require someone else to know what server it is if it did work.

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    HI Anonymous

     

    You do know this is the "Desktop" forum, don't you?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Phil_Seamark I was supposed to do a book review this weekend, I might forget and just focus on answering "Desktop" questions...

      • Phil_Seamark's avatar
        Phil_Seamark
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Oh, I mean ..... Welcome Anonymous, come in and sit yourself down.  Is there anything I can get you?  :D