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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
leesm1thy
Frequent Visitor

"Key length 40" error only in PBI Desktop "App" version

Hi,

I have a number of PBIX files that return an error message I don't understand when opened in the Power BI Desktop "App" version installed from the Microsoft Store, but work fine in the standard installer version.

 

The specified key is not a valid size for this algorithm. Parameter name: key Key Length: 40

 

Key length 40.PNG

 

It makes me nervous to install the very latest version but I will have to at some point.  In all cases the data is being pulled from a SQL Server instance. 

 

Does anyone know what this error is and how to resolve it?

 

Thanks in advance.

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

For the benefit of Googlers with this same issue, I did indeed (eventually) log the issue with the Power BI support team. The advice given to me was delete everything at the following two paths:

 

C:\Users\%username%\Microsoft\Power BI Desktop Store App\Cache

C:\Users\%username%\Microsoft\Power BI Desktop Store App\CEF\cache

 

Doing so resolved my issue where the PQ editor woudn't return anything from a SQL Server database, but I suspect from my own searching on the subject that this error message may present itself in a number of scenarios.

View solution in original post

3 REPLIES 3
v-kelly-msft
Community Support
Community Support

Hi @leesm1thy

 

Try to downgrade the version of desktop to the release in Feb 2020 via below link ,it seems a version incompatibility issue.

https://microsoftapc-my.sharepoint.com/:u:/g/personal/v-kellya_microsoft_com/EXKbx2sMjQxFhboQX1-9GpU...

 

 


 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

Greg_Deckler
Super User
Super User

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

For the benefit of Googlers with this same issue, I did indeed (eventually) log the issue with the Power BI support team. The advice given to me was delete everything at the following two paths:

 

C:\Users\%username%\Microsoft\Power BI Desktop Store App\Cache

C:\Users\%username%\Microsoft\Power BI Desktop Store App\CEF\cache

 

Doing so resolved my issue where the PQ editor woudn't return anything from a SQL Server database, but I suspect from my own searching on the subject that this error message may present itself in a number of scenarios.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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