Forum Discussion
MarkPalmberg
Kudo Commander
Kudo CommanderPower BI Report Builder not passing NULL date parameter value
Hi. I have a stored proc that pulls transactions for a selected date range. Here's what the variable declarations bit looks like: ALTER PROCEDURE [MySchema].[usp_MyProc]
(
@FromDate DATETIME NU...
I tracked this down. Sorry to clutter the forum before I did an exhaustive review on my end! Turns out there was a data sync issue in our DW. šµ Happy Monday!
MarkPalmbergKudo Commander
Kudo CommanderI also tried removing the @FromDate and @ToDate variable settings in the stored proc and then setting the default values in Report Builder as below, but no love there, either.
FromDate:
=DateAdd("d",-8,Now())
ToDate:
=DateAdd("d",-1,Now())