Permission errors in Microsoft Excel PowerQuery can be caused by multiple reasons and unfortunately the errors generated by Excel lack guidance. Here are common causes and resolutions for errors using PowerQuery with the RiskLens Export API
Your API Credentials are incorrect
Be sure you arr using the correct Client ID and Secret for the API Client you created in RiskLens.
The PowerQuery permissions need to be reset
Andrew Fouquette (Unlicensed) can you supply more info?
The scenario or risk assessment you’re selecting does not exist
Be sure the ID for the risk assessment or scenario exists.