This error typically arises when PI OLEDB Enterprise is not installed on the same machine that has SSRS installed. I saw in your post that you installed the PI OLEDB Enterprise Provider locally, do you also have SSRS installed locally? If not, I would recommend installing the PI OLEDB Enterprise Provider on the machine running SSRS.
I do not have PI OLEDB Enterprise Provider installed on the machine running SSRS. I will see if it is possible to install on the server hosting the SSRS reports/Report Builder.
I have a few more questions regarding this:
- What would be the cause of the test connection succeeding in the first photo but not in the second? If Enterprise is not installed on the machine, shouldn't both tests fail?
- Why would I have the option to choose PI OLEDB Enterprise Provider if it is not installed on the machine running SSRS? It was not available before installing on my local.