Forum Discussion
Error Specified key is not a valid size for this algorithm
So I've been doing some testing using different data sources (Web, Excel File, SharePoint Folder...) and queries that were working previously are now broken. This is the error in Query Editor: ...
Had any luck with this? Having the same issue.
I've found a solution
Essentially, you just go to Source
Change Open As to automatic and click OK
#
Double-click the Excel Icon when it comes up
Insert Step
And it usually fixes it, not sure if this will work on other data sources but, it works for me in Excel
Wouldn't bother with the above, needs resetting everytime the dashboard is opened
Clearing the cache did actually work properly - Adding for Google searchers
Thanks for the suggestions BrianFleming, I have tried clearing the cache - no luck for me yet.
