After upgrading PBIRS to jan 2023, can't use report server configuration manager "Provider load failure"

Question

Hi,

I upgraded Power BI report server to the latest version (January 2023), after that I launched the report server configuration manager, I have the server name which is the name of the server where PBIRS is installed but the instance field is grayed out when I click on find I get the error message "Provider load failure".

I’ve tried to uninstall PBIRS and install it again but i get the same error, I even installed the older version may 2022 and I got the same error.

NB:  my sqlserver database is on another server but it was working fine, I checked if I can still connect from sqlserver management Studio from the server where PBIRS is installed to the one where the database resides and it works just fine.

please if anybody can help out.

Answer 1

Hi @Tammame AZZAROUAL

This may be that the RS WMI DLL is not registered correctly. I found some similar threads, maybe you can use them as a reference.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b2f9f70b-ea45-46da-8b30-85be73a0eba2/quotprovider-load-failurequot-in-ssrs-configuration?forum=sqlreportingservices

https://social.msdn.microsoft.com/Forums/en-US/9763ff22-584c-4d69-adb7-1e4ded081eec/provider-load-failure-in-management-studio?forum=sqlreportingservices

Best regards,

Aniya