Forum Discussion

GFRO's avatar
GFRO
Frequent Visitor
2 years ago

Native Database Query Error

I'm having this Expression.Error: This native database query isn't currently supported.

I declared some variables to update some dates in the Main Query.

Does anyone have an idea what's wrong here? It works fine when I run it in SQL Server.

 

 

DECLARE @Start_Date DATE, Anonymous_Date DATE, @Update_Date DATE, @Pay_Date DATE, @NextStart_Date DATE;

SELECT
@Start_Date =   dateadd(day, -1 * DATEPART(dy,SYSDATETIME()) % 14 , SYSDATETIME())
SET Anonymous_Date = dateadd(DAY , 13,@Start_Date)
SET @Pay_Date = dateadd(DAY , 19,@Start_Date)
SET @Update_Date = dateadd(day,-7, Anonymous_Date )
SET @NextStart_Date = dateadd(day,14, @Start_Date)


IF @Update_Date >= convert(date, SYSDATETIME() ) AND @NextStart_Date <= convert(date, SYSDATETIME()) 
BEGIN
<Main Query here>
END

 

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, GFRO 

     

    Is the problem occurring in Power BI Desktop or Power BI Service?

    Please check if  this thread helps:

    Solved: Native Database Query Error - Microsoft Fabric Community

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.