Forum Discussion
Excel data source failing recently - possibly linked to Excel optimisation feature
Hi,
As of this month I am seeing a dashboard fail in desktop and online PowerBI with no obvious reason in the data.
I recieve an .xlxs file each month to update a dashboard. I either derive reporting values from what is listed or create additional columns to report on rule based data.
This month I carried out the refresh and the file loaded while this one sate in a loading phase for a few minutes,
before then generating a lot of errors,
I ultimately had to stop the refresh and saw the failure showing up in the online interface as below.
On reviewing the data there was nothing out of the ordinary and it was only using 1614 cell.
The only thing that looked out of place was that Excel now suggested optimising the workbook and when I carried this out the refresh successfully worked.
Has anyone else experienced this? Have you found a work around? Ideally I would not want to intervene in this process when I look to automate it.
2 Replies
- danextian
Super User
hi chatag05
The screenshot doesn't display the full error, but I assume it says, "Cannot convert the value null to type logical." This could mean that one or more rows in your data contain a null value, which is neither True or False. I recommend reviewing each applied step sequentially in the Desktop to identify where the error originated. If you're unable to resolve it, providing a sample file with the error would be necessary for further assistance.
Hi ,
Based on the testing, it is able to refresh the excel data normally inside power bi desktop.
Try to use power query editor to transform the data and use the replace values function to find null value. Then, check the data in the excel file.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
