R Markdown HTML data table output

Question

I'm having issues when I knit my R markdown to HTML to have it include the data within the table. It keeps say's no data available in table, but when I do it in regular R, it spits out a table for me. I am using all libraries required- knitR and DT.

price_locked_table <- TEST_Pipeline_extract_NA %>%
filter(SyncedQuote== "Price locked" & ForecastPercent > 50) %>% 
select(AccountName, ForecastCategory, ForecastPercent, CloseDate, OpportunityId, Name, TESTPrice, Renewal)

datatable(price_locked_table)

I know there is data in that variable as I've verified in my R script. Not sure why no data is populating in the table when I call to it in R markdown.

Thank you!