Cannot schedule refresh for Google Spreadsheet

[Anonymous]

Hi,

Recently I have been trying to schedule refresh the dataset (Data source: Google Spreadsheet) but have been facing issues.

System states that data source don't support refresh.

Please help!! Thanks in advance!

[Anonymous]

@Anonymous,

Could you please post the M code in Advanced Editor of your query in Power BI Desktop? 

Currently, it doesn't support to refresh dataset in Power BI Service when the data access happens inside a function and the data source is dependent on parameters to the function . There is an idea about this issue, please vote it up.

Regards,
Lydia