Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |