Forum Discussion

Jaspertje's avatar
Jaspertje
Frequent Visitor
6 years ago

Operation returned an Invalid status code 'Unauthorized' (User owns data)

All,   I'm stuck in calling the PowerBi API from my project. What I did was create a MVC application, login with AzureId for the whole site, get a token for PowerBi and get a report. All goes well,...
Need Help
ivilasboasEner's avatar
ivilasboasEner
Regular Visitor
5 years ago

Hi Jaspertje 

Did you manage to solve this?
I'm having the same problem.

Best Regards

Jaspertje's avatar
Jaspertje
Frequent Visitor
5 years ago

Yes we have, but I'm not sure what the correct solution was anymore. I Believe it had to do with the application not having access to the datasource (which seems obvious)

 

We added a mapping for the Application created in Azure to a hardcoded user.

 

To do so, go to the "Manage Gateway" screen. Select the gateway you use in the report you want to show. Select the Users and click the "Map user names" button below.

 

Change the rule for this datasource to "CustomData" and add the ObjectId! as Replace and a existing user with right to the datasource as With.

 

The ObjectId is not the one you can see in the overview via App registrations, but the one shown when you click the link behind "Managed Application in local directory" (The objectId for the Enterprise Application)

 

If you created an Enterprise application you should be able to use that one I suppose