Forum Discussion

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

Power BI Report Server : Refresh data on a report

Hi,   I would like to refresh my data on a report hosted on PBI RS. Does the "refresh" button on the interface do that or does it just refresh the uploaded file?   My data comes from a SQL Server...
Need Help
  • Jarrod's avatar
    Jarrod
    3 years ago

    Use Windows Authentication for the data source then.

     

    When you change to SQL, change to "Basic Authentication" and put in your SQL credentials.

Jarrod's avatar
Jarrod
Icon for Helper III rankHelper III
3 years ago

Hi,

It looks as though you have opened the report. Prior to clicking on the report, there are 3 dots. See screenshot. Once you click the 3 dots, you can then click Manage and follow instructions as above.

 

 

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

Hi again

 

I have setup a local SQL instance (developer edition, which has an SQL agent integrated to it) on my machine and created a test PBI file linked to a database I created to try the scheduled refresh. However the refresh doesn't seem to work and the issue is with the SQL connexion (right above the Scheduled Refresh option), although I have a local instance with no username or password, testing the connexion gives an error.

 

Any idea how to bypass this?