Error when refreshing/adding any Access data sources

[EMcEwen]

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

[CahabaData]

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.

[EMcEwen]

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.

[v-caliao-msft]

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