Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello ,
I use Powerbi report server on premise May 2019 version (window server 2012) on Production include 1 database server (sqlserver 2014 std) and 2 powerbi servers.
I prepare the new cluster with backup restore reportserver and reportservertempdb database (sqlserver 2014 std) (backup from production) and config powerbi (May 2019 )to connect reportserver and reportservertempdb on new environment but when i connect new Powerbi web https://<PBIRS-servername>/reports/ and go to datasource . I found that Connection is not show connection string and credential are null even though production have connection string and credentials
Have you found this issue or some case that's similar to my issue ? would you please help?
thank you,
Peach
Solved! Go to Solution.
Did you restored the encryption keys as well ?
Proud to be a Super User!
my issued was solved . I do the step as below
- backup reportserver and reportservertempdb from production cluster then restore on the new cluster
- backup encryption key from production and restore on the new cluster
- Delete unuse hostname
USE ReportServer;
GO
begin tran
DELETE FROM dbo.Keys
WHERE Machinename in ('....')
GO
commit
- Restart PowerBI service
- check Connection string and it's show as the same as production
thank you,
Peach
my issued was solved . I do the step as below
- backup reportserver and reportservertempdb from production cluster then restore on the new cluster
- backup encryption key from production and restore on the new cluster
- Delete unuse hostname
USE ReportServer;
GO
begin tran
DELETE FROM dbo.Keys
WHERE Machinename in ('....')
GO
commit
- Restart PowerBI service
- check Connection string and it's show as the same as production
thank you,
Peach
Did you restored the encryption keys as well ?
Proud to be a Super User!
Im trying but question is when I restore encription key from production ,in the scale-out will show server same as production. Can I delete server (production server) from scale-out on new server (that I just restore).