Power Query - Error in date data from password protected workbooks

[Mysterymachine85]

When I create a query using Power Query (Excel 2016) and try to pull data from a table from a password protected workbook (already opened) there is always an error in the date column (whith any date format data) and plain numbers appear instead of the date in the outcome. I've tried this with several workbooks, and so far the only error occurs in the DATE format data. Do you know a fix for this?