Forum Discussion
how to schedule refresh for the dataset using on-prem sql database with option 'Import'
THEG72 It should work especially if you were the one that set up the Gateway. Did you remember to add the user that is publishing the report to the dataset you created on the gateway? Also, ensure that the connection Server/database name that you are using in the PBIX file matches exactly to what you set up as a datasource in the gateway.
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?
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.
HI Anonymous
You do know this is the "Desktop" forum, don't you?
Phil_Seamark I was supposed to do a book review this weekend, I might forget and just focus on answering "Desktop" questions...
