Forum Discussion

sdjensen's avatar
sdjensen
Icon for Solution Sage rankSolution Sage
8 years ago
Solved

Schedule refresh stopped working.

Hi,   At a customer we have had a Power BI report since august 2016 with no issues with the scheduled refresh. Of course there has been made changes and improvements since, but the last changes was...
Need Help
  • sdjensen's avatar
    sdjensen
    8 years ago

    Apparently Microsoft have made some changed to the service - atleast I am now able to schedule refresh on republished data models.

Framet's avatar
Framet
Icon for Resolver II rankResolver II
8 years ago

I ended up removing all parameters from my queries and functions in an attempt to get this to load reliably but previosuly this hadn't helped. I also had a recursive query across workbook tabs of an excel file which I had to replace with an equivilent SSIS package and point Power BI at a SQL table even though this worked without issue for many weeks.

 

On my issue, I have recently heard back from Microsoft support who indicate something has been "fixed" with the cluster and my reports indeed refresh again so perhaps we have different issues with the same error message?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Framet, instead of creating a full SSIS package to create a table you can always create a view to pull the data into your model. Since you are refreshing on a schedule pulling from a view should not be determinal.