Forum Discussion

JamesGordon's avatar
JamesGordon
Icon for Helper II rankHelper II
6 years ago
Solved

Unexpected error: The specified key is not a valid size for this algorithm.

Hi all,

 

For some reason all of my PowerBI file come up with this error in  Power Query " Unexpected error: The specified key is not a valid size for this algorithm."

 

I have found other posts with the same issue - they mention deleting some cache folders.

 

Can someone shed any further light on this? Do i delete the entire folder or just the contents?

 

The only cache folder i can find is this one: C:\Users\<username>\AppData\Local\Microsoft\Office\16.0\PowerQuery\Cache

 

Are there other Cache folders i need to delete also?

 

Any help would be appreciated as this appears to be affecting all of my Powerbi reports!!

Need Help
  • JamesGordon's avatar
    JamesGordon
    6 years ago

    Hi Pragati11 ,

     

    I have deleted both:

    C:\Users\James\AppData\Local\Microsoft\Office\16.0\PowerQuery\Cache

    and

    C:\Users\James\AppData\Local\Packages\Microsoft.MicrosoftPowerBIDesktop_8wekyb3d8bbwe\LocalCache\Local\Power BI Desktop

     

    Deleted the files when Power BI was closed. Then re-opened but the error is still active?

     

    Would it be of assistance if i posted the entire error?

  • JamesGordon's avatar
    JamesGordon
    6 years ago

    Hi Pragati11 

     

    Thanks for you help. The error has now gone - i found some more Cache Files. For summary incase anyone else has this issue i deleted:

     

    C:\Users\(username)\AppData\Local\Microsoft\Office\16.0\PowerQuery\Cache

    and

    C:\Users\(username)\AppData\Local\Packages\Microsoft.MicrosoftPowerBIDesktop_8wekyb3d8bbwe\LocalCache\Local\Power BI Desktop

    And

    C:\Users\(username)\Microsoft\Power BI Desktop Store App\ExtensionCache

     

     

11 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    Hi JamesGordon ,

     

    You can just delete everything inside Power BI folder on the following location:

    C:\Users\<username>\AppData\Local\Local\Microsoft\Power BI Desktop\

     

    Then re-start Power BI and try again.

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

     

    • JamesGordon's avatar
      JamesGordon
      Icon for Helper II rankHelper II
      6 years ago

      Hi Pragati11 

       

      Thank you for a quick reply. I have tried to look for that folder but to no avail? Screenshot of my files below

      Would there be anywhere else the folder could be?

      • Pragati11's avatar
        Pragati11
        Icon for Super User rankSuper User
        6 years ago

        Hi JamesGordon ,

         

        Are you on Windows10 machine? Also, try un-hidding any folders in this location.

        I am using a Windows 10 machine and I have this folder.

         

        If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

         

        Thanks,

        Pragati