Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I've suddenly started getting the below error message when refreshing/adding any Access data sources. Any ideas?
Error Message:
The specified key is not a valid size for this algorithm.
Parameter name: key
Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: The specified key is not a valid size for this algorithm.
Parameter name: key ---> System.ArgumentException: The specified key is not a valid size for this algorithm.
Parameter name: key ---> System.ArgumentException: The specified key is not a valid size for this algorithm.
Parameter name: key
at System.Security.Cryptography.AesCryptoServiceProvider.CreateEncryptor(Byte[] key, Byte[] iv)
at Microsoft.Mashup.EngineHost.Services.EncryptedPersistentCache.EncryptedStorage.EncryptPage(Byte[] input, Int32 count, Byte[
Thanks in advance
E
I could not link/get-data from an Access table that was an Office 32 bit installation where the PBI installation was a 64 bit installation.
I set up a work-around by exporting the Access table to Excel, and for some reason the 32 bit install involving Excel did not bother PBI.
I was never able to clarify why Excel is okay but Access not okay in this scenario.
Possibly your original set up was with Access/Office 64 bit and there was a change to a different PC with a different install?
Perhaps this helps.
It looks like it's a problem with my version of Access so I've temporarily gone back to the previous PowerBI version until I hear back that the issue is solved.
Hi @EMcEwen,
As you said, it seems that the issue related to your Access version, so why do you gone back to the previous PowerBI version?
Regards,
Charlie Liao
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |