Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
Please take a look here:
https://guyinacube.com/2017/02/configure-kerberos-power-bi-reports-reporting-services/
I think that should solve the problem.
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
User | Count |
---|---|
9 | |
9 | |
5 | |
2 | |
2 |
User | Count |
---|---|
13 | |
9 | |
7 | |
2 | |
2 |