Forum Discussion

Shiva799's avatar
Shiva799
Frequent Visitor
8 years ago

Error converting data type varchar to date.

Hi, I'm trying to write an m code for an sp to take parameters dynamically. It goes as let Source = Sql.Database("servername", "dbname", [Query="exec [SP_GetReport] 'Status','All','Frequency','Busines...
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Shiva799,

 

Could you try using the query below to see if it works? :smileyhappy:

let 

bDate = BusinessDate

Source = Sql.Database("servername", "dbname", [Query="exec [SP_GetReport] 'Status','All','Frequency','"&bDate&"'"]) 

in Source

 

Regards

  • Shiva799's avatar
    Shiva799
    Frequent Visitor
    8 years ago
    Nope Expression.Error: We cannot apply operator & to types Text and Date. Details: Operator=& Left=exec [SP_ReportModel_Policy_Summary_Base_Template_AA_RA_Parm] 'Status''Frequency',' Right=12/7/2017 Also it gave me error without comma let bDate = BusinessDate, Source = Sql.Database("servername", "dbname", [Query="exec [SP_GetReport] 'Status','All','Frequency','"&bDate&"'"]) in Source