cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
robarivas Member
Member

Unable to Schedule Refresh for 1 Particular Workbook

This morning I published an Excel workbook to the Power BI service. When I then went to set up scheduled refresh (as I currently have set up for 2 other workbooks) the page shows as blank/white. I tried refreshing the browser page and even different web browsers to no avail. Why would the Settings page be blank for just 1 particular workbook but not for other workbooks and not for Power BI datasets?

1 ACCEPTED SOLUTION

Accepted Solutions
robarivas Member
Member

Re: Unable to Schedule Refresh for 1 Particular Workbook

I think this is now resolved. One or both of the following seems to have been the culprit.

 

1) The famous “Formula.Firewall: Query 'QueryName' (step 'StepName') references other queries or steps and so may not directly access a data source. Please rebuild this data combination.” error

 

2) The data source of one of the queries was an Excel table from within the file.

 

After addressing these two items I could suddenly see the page with the Schedule Refresh option and such

View solution in original post

1 REPLY 1
robarivas Member
Member

Re: Unable to Schedule Refresh for 1 Particular Workbook

I think this is now resolved. One or both of the following seems to have been the culprit.

 

1) The famous “Formula.Firewall: Query 'QueryName' (step 'StepName') references other queries or steps and so may not directly access a data source. Please rebuild this data combination.” error

 

2) The data source of one of the queries was an Excel table from within the file.

 

After addressing these two items I could suddenly see the page with the Schedule Refresh option and such

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,891)