Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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, @End_Date DATE, @Update_Date DATE, @Pay_Date DATE, @NextStart_Date DATE;
SELECT
@Start_Date = dateadd(day, -1 * DATEPART(dy,SYSDATETIME()) % 14 , SYSDATETIME())
SET @End_Date = dateadd(DAY , 13,@Start_Date)
SET @Pay_Date = dateadd(DAY , 19,@Start_Date)
SET @Update_Date = dateadd(day,-7, @End_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
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
32 | |
26 | |
24 | |
19 | |
16 |
User | Count |
---|---|
52 | |
38 | |
24 | |
20 | |
20 |