Excel sheet name after overwrite with Excel Writer Node
Hi all,
hope everybody is well!
In our team we use Knime to clean and manipulate different Excel file to uniform them, so basically our workflows start with an Excel Reader and end with an Excel Writer node; after that we use the final Excel file in Power BI. In the last few months we have been encountering something weird with the output of our Excel Writer node, meaning that, after overwriting the file Power Bi doesn’t recognize the sheet name anymore, even if we don’t change it.
As of today we have found a workaround in which we open the overwritten excel file, we double click on the name of the sheet and then everything works just fine. As you can imagine, this is not sustainable in term of not being able to automatize the update of our dashboards.
Has someone else encountered the same problem? Are we doing something wrong?
Thanks in advance to anyone who helps!