Hi,
I transformed the data and stored in excel sheet which I wanted to use for Power BI. However, when we store data in excel, some columns have truncated headers and values and thus, I used the following code to have clean columns or auto-adjust widths for column
setColWidths(wb, "tab_name", cols = 1:6, widths = "auto")
#using library(openxlsx)
Excel sheet looks fine. But Power BI doesn't accept this file. However, if I manually adjust the excel sheet by double-clicking on the column line, Power BI accepts it.
Is there anyway to avoid adjusting the column width so that Power BI can accept such file.
Thanks!