Data Source Not Supported by Scheduled Refresh, but surely it should work

[MattAllington]

I have a simple PBIX file that I want to refresh automatically online.   I am getting this error

The data is all manually entered using a list of lists in Power Query ={{"item1",4,{"item2",4}}.  There is no other data source and it seems that this data souce should be supported given it is standalone and encapsulated.

Monitor Online Prices.pbix

[Anonymous]

That's interesting.  I came across this error today also for the first time whilst testing a new power query which does paginated API calls as a data source using a custom function.  I came across a forum thread which said that custom functions are not supported within PowerBI Service, so thought it must have been that, or maybe there's another bug of some sort?  

https://community.powerbi.com/t5/Service/Query-contains-unknown-or-unsupported-data-sources/td-p/427...

[v-qiuyu-msft]

Hi @MattAllington,

The query "product list" calls the custom function getProduct(), but currently the custom function is not supported to refresh on Power BI service. You can remove the custom function within your Power Query, then republish it to Power BI service, the issue will be gone. You can vote this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9312540-make-functions-refreshabl...

@Anonymous The issue you encountered is same as @MattAllington, please vote and comment on the idea as well. 

Best Regards,
Qiuyun Yu