Forum Discussion

Juanjo_fb's avatar
Juanjo_fb
Copper Contributor
Nov 18, 2019

Power query no funcciona

Buenos días:

 
No he conseguido solucionar mi problema en excel 2016 por lo que les solicito ayuda como mejor corresponda. El problema es que power query no reconoce los datos para subirlos al modelo de datos para procesarlos con power pivot tal como se muestra en la imagen. 
 
 Con esta tabla de 8 x 3 celdas se queda permanentemente "pensando"
¿Que puedo hacer?
 
Gracias
 
Juanjo
excel

7 Replies

    • Juanjo_fb's avatar
      Juanjo_fb
      Copper Contributor
      Dec 11, 2019

      SergeiBaklan 

      Si. El error es de excel. He intentado instalar nuevamente powerQuery 

      pero no me permite. Me indica que ya está instalado; por lo que no se como solucionarlo.

      Gracias por su interés

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Dec 11, 2019

        Juanjo_fb 

        You can't reinstall Power Query for Excel 2016, it's built-in.

         

        Few people reported the same issue with Excel 2016, I guess that's the bug in current build. So far didn't see the solution for this.

      • crazyshoots's avatar
        crazyshoots
        Brass Contributor
        Dec 10, 2019

        Juanjo_fb Hi, I noticed you have an error on table so I set an extra step to remove it (you can change this if you dont want to).

         

        For category, I loaded with no issue. I am suspecting it could be because your multiple queries were running all at a go so memory took a load.

         

        I reloaded all query and all was fine. Also loaded 8x3 table to a worksheet and it is working.

         

        I suggest you go to data tab on your ribbon, look for "show queries" then load that and see if it works for you. 🙂

         

         

Resources