Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
johncpratt
Advocate II
Advocate II

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 Desktop tool.  When first setting up the scheduled refresh, I was required to enter credentials for the data source connection, which I did and tested successfully (Windows credentials already established on the source SQL Server).

 

A few minutes later, I went back to the report to look at the scheduled refresh parameters in order to get a screenshot for my documentation, and was instead presented with the following UI, which says there is no scheduled refresh.  Access to the Data sources menu item is disabled.

Oct2017_ScheduledRefresh_PBIRS_UnableToSeeEditExistingRefresh.png

 

I took a look in the ReportServer DB, and after a couple minutes of poking I found the Schedule table with a row clearly representing the one Power BI data model refresh I had set up.

Oct2017_ScheduledRefresh_PBIRS_RecordInDB.png

 

The expected bahavior is that I can see and edit both the scheduled refresh I set up and the data source parameters.

2 ACCEPTED SOLUTIONS
v-qiuyu-msft
Community Support
Community Support

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-...

 

Note: Do mask sensitive data before uploading.

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

johncpratt
Advocate II
Advocate II

@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!

View solution in original post

9 REPLIES 9
johncpratt
Advocate II
Advocate II

@v-qiuyu-msft, yes it can be closed.  I just confirmed that the 2 scheduled refreshes I set up have been running successfully.  Thank you for your help!

v-qiuyu-msft
Community Support
Community Support

Hi @johncpratt,

 

As the issue is solved now, may I close this thread? 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
johncpratt
Advocate II
Advocate II

@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!

v-qiuyu-msft
Community Support
Community Support

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-...

 

Note: Do mask sensitive data before uploading.

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
johncpratt
Advocate II
Advocate II

UPDATE 2:  Since the Data sources item was unlocked, I reentered the credentials and tested them successfully.  I left that screen and went back to make sure they were there (they were).  I then clicked "Scheduled refresh and Voila!, there was the report schedule.  So this is looking more like a problem with saving/accessing the data source credentials than an issue with the actual refresh schedule.

johncpratt
Advocate II
Advocate II

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.

 

johncpratt
Advocate II
Advocate II

The query you provided generated the following results.

Oct2017_ScheduledRefresh_PBIRS_ReportSchedules.png

 

The highlighted report is the one I created the data refresh schedule for.  The Manage UI for the report still looks the same as my original screenshot, which means I still cannot view or edit the data source I set up as well as see the refresh schedule.

Vicky_Song
Impactful Individual
Impactful Individual

 
v-qiuyu-msft
Community Support
Community Support

Hi @johncpratt,

 

I'm not able to reproduce this issue on my side. In your scenario, are you sure the you have created schedule refresh plan for the report Agency Revenue Insights? 

 

Please run this query in report server database to check if you really created schedule for the specific report: 

 

q3.PNG

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.