This topic has been closed due to inactivity. If you would like to discuss this topic further, please start a new post.
You can reference this topic in your post by adding this link:
We are trying to use Excel - Power Query - to get data from PSB using the API.
we put in the key + URL but we are getting an error.
any advice would be appreciated.
It seems that Power Query does not support REST API (according to https://support.office.com/en-us/article/Introduction-to-Microsoft-Power-Query-for-Excel-6E92E2F4-20...).
But it should be possible for you to terminate the REST API, extract the JSON content and input to Power Query.
We have not made an integration with Power Query, so that is just our understanding.
Please let the community know if this approach works.