Forum Discussion

CookieMonster's avatar
CookieMonster
Helper I
4 years ago

Azure Cost Management connector causing error 'We cannot convert the value null to type Record.'

Ref: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management Azure Cost Management connector causing intermittent error 'We cannot convert the value null to type...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, CookieMonster 

 

Do you replace {billingAccountId} with real data? 

Does this problem only occur occasionally? Have you successfully connected and used this data source?

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,

Community Support Team _ Janey

CookieMonster's avatar
CookieMonster
Helper I
4 years ago

Yes I replaced {billingAccountId} with my acutal {billingAccountId}.

 

Yes it only occurs, occasionally, sometimes it will refresh fine and all data is available as expected, at other times the refresh fails and I get this error.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    Hi,  CookieMonster 

     

    Then it's hard to judge.

    I doubt whether the data in the source data doesn't meet the type of column after updating. Have you checked it?

     

    Best Regards,

    Community Support Team _ Janey

    • CookieMonster's avatar
      CookieMonster
      Helper I
      4 years ago

      I dont have access to the data source, as its Azure Cost Management Connector.

       

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Community Support
        4 years ago

        CookieMonster 

        So, Generally it's a problem of data type. I can only help here.

         

        Did I answer your question ? Please mark my reply as solution. Thank you very much.
        If not, please provide more details and feel free to ask me.


        Best Regards,

        Community Support Team _ Janey