Forum Discussion

Medmbchr's avatar
Medmbchr
Icon for Helper IV rankHelper IV
3 years ago
Solved

Data Source in Power BI Report Server won't connect

Hi   I would like to use Scheduled Refresh for a PBI dashboard in Power BI Report Server. When I created my Scheduled Refresh and waited for it to be run, it didn't. I checked what's wrong and it s...
Need Help
  • d_gosbell's avatar
    d_gosbell
    3 years ago

    You need to enter a password into the credential settings for the data source in order to run a scheduled refresh. This is because the server is normally running on a separate machine and it needs to be able to trigger the refresh when nobody is logged in to that machine. 

     

    So the normal practice is to get IT to setup a "service account" with a non-expiring password which you can use for this purpose so that the scheduled refresh does not break when you change the password for your user account.

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
3 years ago

You need to enter a password into the credential settings for the data source in order to run a scheduled refresh. This is because the server is normally running on a separate machine and it needs to be able to trigger the refresh when nobody is logged in to that machine. 

 

So the normal practice is to get IT to setup a "service account" with a non-expiring password which you can use for this purpose so that the scheduled refresh does not break when you change the password for your user account.