Forum Discussion

johncpratt's avatar
johncpratt
Icon for Advocate III rankAdvocate III
8 years ago
Solved

Unable to view/edit scheduled refresh and data source with October 2017 GA update

With the newly installed PBIRS October 2017 GA, I created a scheduled refresh for an existing report that uses data imported from SQL Server and which had previously been manually refreshed in the De...
Report Server
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi johncpratt,

     

    From your description, it seems the report Agency Revenue Insights exists before you upgrade the report server to October version, right? 

     

    If it is, please redeploy the report then check if you can edit credential and create a schedule. See: https://christopherfinlan.com/2017/11/02/tips-when-upgrading-from-the-august-preview-to-the-october-release-of-power-bi-report-server/

     

    Note: Do mask sensitive data before uploading.

     

     

    Best Regards,
    Qiuyun Yu

  • johncpratt's avatar
    johncpratt
    8 years ago

    v-qiuyu-msft, yes, all 3 of my prototype reports were created in the August 2017 Preview, including this one that I was trying to get the data refresh to work for.  As I indicated in my UPDATE 2 above, redeploying the report from my desktop to the server "unlocked" the data sources menu item, allowing me to reenter the credentials.  I then was able to see the existing refresh schedule.

     

    I checked just now after having the refresh schedule running for 2 days, and it is working successfully.  I confirmed that new data was loaded.

     

    Given these results, I would say that this issue is closed, with the solution being to redeploy the report and then enter data source credentials followed by setting up a refresh schedule.

     

    Thanks for your help!

johncpratt's avatar
johncpratt
Icon for Advocate III rankAdvocate III
8 years ago

UPDATE:  After I got a separate report deployment issue resolved, I resaved the report from my desktop app to the server.  When I did that, the "Data sources" menu item was unlocked and the "Scheduled refresh" screen shows no schedules set up, even though your query STILL returns the same row.

 

Just to be safe, I queried "select * from dbo.Catalog c where c.Path LIKE '%Agency Revenue Insights'" and only got back one row.  So I have a phantom report schedule that does not appear on the browser screen and data source credentials that have disappeared.