I use the following function from the openxlsx package to export my dataframe to a local folder as an xlsx file:
write.xlsx(data frame, path, overwrite = TRUE)
I want to pull it into a Power BI project, but when I do, I get the following error from Power BI: "The input couldn't be recognized as a valid Excel document."
But when I go into the file, save it and close, it then works fine.
Thank you