Can't see a report with another account

[Anonymous]

Hi everybody,

I am in trouble with reports and accounts in PBIRS. I have a SQL Server database where I use Windows authentication and use it in Direct Query mode to build a PBI report with my business account. Finally I upload it in PBIRS, but if I use another account to log in my PBIRS, I get the following error message:

"It has not been possible to connect to Analysis Services server. Verify to have used the right connection string".

Why does it happen? I think I should see it whatever account I use, after uploading my report. Maybe it's a matter of accounts used to create it?

Thank you very much

Nick

[Anonymous · Accepted solution]

Please take a look here:

https://guyinacube.com/2017/02/configure-kerberos-power-bi-reports-reporting-services/

I think that should solve the problem.

[Anonymous]

Thank you @Anonymous, your video talks about my issue.

However I found another solution some minute ago: I changed data sources from every PBI report I wanted to upload. I opened the report, then File --> Options and Settings --> Data Sources Settings --> Change Source. There I changed the server name from my local istance to the IP link I used.

Moreover, in PBIRS for every report I did the following steps: right click on small points on th top-right corner --> Manage --> Data Sources --> here I set the credentials on basic authentication, using sa account.

Hope it useful

Nick