Hi @Yashas Manjunath Thank you for posting your query with us on Microsoft Q&A platform. Happy to help!
I understand that you are using Az consumption usage list and does not seem to work for some subscriptions. I would recommend using either Cost Details API or Exports. You can learn more about which is best for you here.
Cost details best practices - Microsoft Cost Management | Microsoft Learn
Hope this helps!
----------------------------------------------------------------------------------------------------------------------
If the response helped, do "Accept Answer" and up-vote it