Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |