Forum Discussion
The Report Data do not Display in the Power BI Brawser.
Adding more information to this topic. The the PBI Report Server was setup using Integrated Securify, and the reports have been setup to impersonate the user using the Admin Credentials; however, when I check the logs for the PBI Report Server the information is as follow:
2017-10-19 12:22:46.8775|ERROR|94|Failure in conceptualschema| RequestID = 421658bb-3a44-e511-af00-ff289aba1946 ClientSessionID = 5c6a5d97-4083-4291-ad29-b2ec7b237099 Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'EntityDataSource'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Either the user, 'INTERAMERICAN\jjerez', does not have access to the 'MultidimensionalProject1' database, or the database does not exist.
2017-10-19 12:22:46.8775|INFO|85|Sending response. Response code INTERAMERICAN\jjerez 200, Elapsed time 0:00:00.6207624| RequestID = 421658bb-3a44-e511-af00-ff289aba1946 ClientSessionID = 5c6a5d97-4083-4291-ad29-b2ec7b237099
SO this sudgest that the external user account INTERAMERICAN\jjerez, do not have acces to 'MultidimensionalProject1'. It is like the impersonation setup in the report Item is not actually working.
ANY SUDGESTION???? THANK YOU!!!
Problem solved, no need to answer. When you go to the report item in the portal, and click (...), them Manage, them Data source, if you check the box - Log in using these credentials, but then try to impersonate the user viewing the report -. The Analysis Server denied access to the cube. So when you setup admin credentials to impersonate the user, do not check that box. At lest in my didn't work as expected. Once I uncheck the box, the final user was able to load data and visualize the report in the browser.