Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
EMcEwen
Frequent Visitor

Error when refreshing/adding any Access data sources

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

3 REPLIES 3
CahabaData
Memorable Member
Memorable Member

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.

www.CahabaData.com
EMcEwen
Frequent Visitor

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.