Refresh Native Query

[adamh1]

Hi Guys - Happy New Year

I'm connecting Desktop to  a SQL database 

have set up a number of queries to import data into desktop - the queries include some T-SQL example below

each time teh data is refreshed I'm prompted to authorise the refresh of  each Native QUERY" manually

is there any way to automate this ?

= Sql.Database("XX.XXX.XX.XX", "Database",(Query=Select SE_Start_Date, Service_ENC_REC_ID,DIM.Diagnosis

#(If) #(If) WHERE

SE_Start_Date>= ' "&Startdate&" '

#(If) And

SE_Start_Date<= ' "&Enddate&" '

" ])

have already tried changing the last line to  

" , CreateNavigationProprerties=false])           but this has no impact

Many thanks in advance Adam

[DataInsights]

@adamh1,

Go to File --> Options and settings --> Options --> Global --> Security, and uncheck "Require user approval for new native database queries".