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 Record.'

I have this issue intermittently both on Power BI Web and Desktop.

I reproducted on Desktop today by:

  • Create new Power BI file
  • Get Data > Azure Cost Management
  • Scope: Manually Input Scope
  • Scope Identifier: /providers/Microsoft.Billing/billingAccounts/{billingAccountId}
  • Number of Months: 6

I then got the error:

So at this point, I have not touched the data tables at all, or done any visuals etc.

Any idea what I can do to resolve this intermittent issue or who I should contact?

Need Help

5 Replies

  • 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