Forum Discussion
Calling a sproc using Incremental Refresh in PBI - MS SQL: Incorrect syntax near the keyword 'Exec'
Hi PBI Team, I was going through a video (GIAC) on Calling a Stored Procedure using Incremental Refresh in Power BI? By doing so, I am able to fold the following NativeQuery however, I am seeing an ...
Hi @Xiaoxin Sheng,
Thank you for the note. I am connected to the dataset through import mode. Please be informed that @StartDate and @EndDate are the sproc parameters and I have created RangeStart (date/time) and RangeEnd (date/time) parameters in the power query editor. Unfortunately, your M query is not working. Thanks.
Did you solved your issue yet? If yes, how did you resolve it?
I think you might need to do like this;
StartDate = Text.From(RangeStart),
EndDate = Text.From(RangeEnd)Thanks,
pthapa
