Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]),
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.