Forum Discussion

Chirapath's avatar
Chirapath
New Member
3 years ago

ApiResponseError with Unexpected Error from Microsoft Sustainability Manager in US region

I got this error when I try to connect data from Azure SQL Database or Excel to Microsoft Sustainability Manager in the US region. 

'

---------- Message ----------
Unexpected Error

---------- Stack ----------
ApiResponseError: Unexpected Error
at d.handleLoadEvent (https://us.prod.powerquery.microsoft.com/MashupEditor/scripts/o.a.91edce4d754dea383399.bundle.js:2:27477)
at XMLHttpRequest.<anonymous> (https://us.prod.powerquery.microsoft.com/MashupEditor/scripts/o.a.91edce4d754dea383399.bundle.js:2:28523)

---------- Session ID ----------
bb7dd14d-1c90-4f46-be2a-9002d7e43470

---------- Request ID ----------
5350e52c-07b4-4b92-937b-ffbb0ee6030d

---------- Mashup script ----------
section Section1;

'

I don't know why?!. And when I try in a different account from the Asia region it can connect data without any error. Can anyone help me?

I need this fixed because,

Spoiler
for some reason, Microsoft Sustainability Manager in the Asia region doesn't show insights(Power BI) from new data I have created and I need this for my project.

Thank you to anyone who reads this post and could give me some advice!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Chirapath ,

     

    Are these two accounts under the same tenant? Are other variables such as permissions and roles the same?

    See if helps:

    Use data connectors

     

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data