Data sources don't support refresh - PowerBI.com error - Power Query Parameters

[Rainar]

Hi,

I have two identical datasets uploaded to powerbi.com. One of them I updated today and while trying to schedule refresh I get an error:

" You can't schedule refresh for this dataset because one or more sources currently don't support refresh."
 (PS: It was working perfectly fine for a month+)!!!

I haven't touched the other dataset and it is still working well. 
I know where the issue is -> I'm using parameters for my SQL Stored Procedure. 

But its extremely annoying. Please let us know if this is a bug or will be a real thing?  

This is from my Power Query editor

*******

let

// Check ExcludeMMFId PQ Parameter
      ExcludeMMFIdParm =
      if ExcludeMMFId = "'N/A'"
     then ""
     else ",@ExcludeMMFIdExternalFilter = @ExcludeMMFIdExternalFilter"
,

// Query based on ExcludeMMFId Parameter

     dbQuery=
      "
     DECLARE @UserID VARCHAR(255); 
     DECLARE @ExcludeMMFIdExternalFilter VARCHAR(4000);

     SET @ExcludeMMFIdExternalFilter = " & ExcludeMMFId & "
     SET @UserID = " & UserID & "

     EXEC [Item_PBI]
     @UserID = @UserID " & ExcludeMMFIdParm & "
     ",

// Get data

       Source = Sql.Database(SQLServerName, SQLDatabase, [Query= dbQuery]),

[v-qiuyu-msft]

Hi @Rainar,

I have reported this issue internally: CRI 65040743. Will update here once I get any information. 

Best Regards,
Qiuyun Yu 

[mmuddasar]

Hi,

I have the same issue, again due to passing a parameter to a SQL query.

Please update here with more information.

I work in a business which is trialling Power BI and this is delaying release of new reports.

Thanks.

[v-qiuyu-msft]

Hi all, 

I got information that the fix will be released on prod by 4/23/2018. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi all, 

Please test again to see if the issue is gone now. 

Best Regards,
Qiuyun Yu