How do I resolve PowerQuery permission errors?

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 are using the correct Client ID and Secret for the API Client you created in RiskLens.

The PowerQuery privacy levels need to be reset

This article from Microsoft Office support should explain how to set privacy levels.

The scenario or risk assessment you’re selecting does not exist

Be sure the ID for the risk assessment or scenario exists.

Credential Issues

Try going to Data Source Settings and reset your permissions.