Forum Discussion

lmoranian's avatar
lmoranian
Regular Visitor
4 years ago

PowerBI Report Server Report Refresh

Hi,   Is there a way for reports on the web page associated with SSRSPBI to refresh the data?  I have reports using direct query and import and have scheduled refresh on the web page.  The refresh ...
SSRS. Power BI
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi lmoranian ,

 

To refresh data in your Power BI report in Power BI Report Server, you must create a scheduled refresh plan.

You need the necessary permissions to create a scheduled refresh plan. Permissions are defined in the role definitions for the report server. See Role definitions - predefined roles in the SQL Server Reporting Services documentation for details.

Prior to creating a schedule data refresh plan, you need to set the credentials for each data source used in your Power BI report.

Then you can follow these steps to create a scheduled refresh plan.

  1. In the web portal, right-click on the Power BI report and select Manage.

  2. In the left menu, select the Scheduled refresh tab.

  3. On the Scheduled refresh page, select New scheduled refresh plan.

  4. On the New Scheduled Refresh Plan page, enter a description and set a schedule for when you want your data model to be refreshed.

  5. Select Create scheduled refresh plan when done.

For more,you can refer to ：How to configure Power BI report scheduled refresh 

 

Also，you may check this thread ：Scheduled Refresh with Web Source Not Working 

 

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • lmoranian's avatar
    lmoranian
    Regular Visitor
    4 years ago

    We have a couple of scheduled refreshes set up and the credentials are there, but the report is not refreshing.  We have two versions on the report server, one using import and one using direct query.

    • rgiltner's avatar
      rgiltner
      Frequent Visitor
      4 years ago

      Is the DirectQuery report not displaying the updated data ?  The way I understand it, DirectQuery data sets pull in the latest data every time you open the report, no refresh needed.

      For the report using Import, what type of credentials have you supplied for running the refresh ?  A SQL account, or a Windows Account ?  And if a Windows Account, I'm not 100% certain but I imagine the service account running the Power BI service must be able to delegate to the account trying to perform the data refresh.  If they are one in the same, totally clueless.  

      If you check logs on your target SQL server, do you see anything about failed logins etc. ?