Azure Data Lake refresh issue

I have been working with PowerBI Support over the last month, and I seem to have gotten around the problem that I have been having.  There were 2 things that seem to have an impact on my refresh failures.

First up, the Source statement in the Advanced Editor for the Query. Must not have a second parameter. eg

Source = DataLake.Contents("adl://ourstorage.azuredatalakestore.net/appinsights/processed/v2/Event/DataQuery/"),

not

Source = DataLake.Contents("adl://ourstorage.azuredatalakestore.net/appinsights/processed/v2/Event/DataQuery/", [PageSize=null]),

Considering it is the default when you create a new query to have [PageSize=null] as a second parameter, this is a bit annoying.

Second, was that I removed all the existing published reports that I had in my workspace, and republished. This was one of the steps that Support suggested. I am presuming that there is some caching going on, especially if you have multiple reports using the same source, as I was. 

Since then, I have not had a problem with the PowerBI Service doing a scheduled refresh.

Of course, there may have been some other changes made in the background that I am not aware of (as I mentioned, it took around a month to get this working :-))

Im not sure how feasable it is for others still having this issue to remove existing published reports from the workspace. You could try testing in a different, empty, workspace first, to see if this works for you or not.

Good luck

Jeff