Forum Discussion
Setting up an Odata connection for Cornerstone API Reporting connector
Can you confirm you have the two scopes below selected for the App on the Cornerstone side. My issue was similar where it was working in Postman but not in PowerBi until I enabled the scope reportingmetadata:view. Another thing you could try for troubleshooting is setting the app to a user that has full permissions in Cornerstone with all the scopes enabled. If it works then it would just be narrowing it down to the permissions you are missing.
I was able to connect succesfully using the method in the first article you mentioned, https://csod-external.force.com/supportcentral/s/article/How-do-we-integrate-Power-BI-with-the-Reporting-API?language=en_US.
I originally had the same error but fixed it by ensuring the scopes and permissions are set correctly in Cornerstone. In my case I was missing the scope for the Metadata.
Hi Richard,
I thought that the problem was the same as you mention in your message... if you try to connect to the reporting API, you should specify the "read" term at the end of the view i.e. vw_rpt_users:read.
Unfortunately I still can't connect... I can connect and obtain data using the simulation of the "Webservice practice lab" at https://csodapi.com/... but not trhough Power BI... maybe I need to try with other scopes in other environment. I will tell you soon if I can advance with the correct way.
Thank you very much for your help,
JC
Can you confirm you have the two scopes below selected for the App on the Cornerstone side. My issue was similar where it was working in Postman but not in PowerBi until I enabled the scope reportingmetadata:view. Another thing you could try for troubleshooting is setting the app to a user that has full permissions in Cornerstone with all the scopes enabled. If it works then it would just be narrowing it down to the permissions you are missing.
Yeah!! Good news!!
Now I can retreive the views of the scope correctly. As you told me, the "reportingmetadata:view" is mandatory to get access to the views of the scope. I really appreciate your help Richard, so thank you very much to solve a problem that CSOD neither PowerBI solved it.
Kind regards,
JC