Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Azure Cost Management - Editor de Power Query Expression.Error No se puede convertir el valor null

Hey todo, Estoy conectado directamente a la herramienta de administración de costos de Azure desde mi cliente de Power BI Desktop. Todo funciona bien, puedo y manipule todos mis datos cuando me c...
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hey All,

     

    Apologies for the delayed response. I believe that there was no issue with my querie, but rather the Azure cost manager data source bugged out. Sometimes I get the aforementioned error, and sometimes, without changing one bit of code, it works perfectly fine. I wonder if it has to do with my connection. At any rate, I've nested my code in the "try otherwise" loop mentioned above. It doens't fix the error, but it makes it less annoying.

     

    Thanks for the help

     

    Gdurego

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hola @gdurego,

      Puede estar relacionado con la conexión de origen de datos power bi y azure y el estado de servicio correspondiente. Tal vez pueda abrir un contacto de ticket al equipo power bi para rastrear el estado del backend para obtener más soporte.

      submit a support ticketpresentar un ticket de soporte

      saludos

      Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hey Anonymous ,

         

        That would be much apprepciated. I can't seem to wrap my head around why this error occures so sporadically. Even when I don't have any transformation steps there are occasions where the data query returns the same error. Other times - with the same data query and the same Power BI Desktop file - it works perfectly fine.

         

         

        This is my blank query that sometimes works and sometimes doesn't. 

         

        Below is how I connect to the Azure Cost Management tool. For privacy reasons, I have removed the enrollment number. In my query, I use the correct enrollment number, and input 1 for the number of months.

         

         

         

        Thanks,

         

        Giulio