AnsweredAssumed Answered

Power BI Report Server, PIOLEDBENT and Linked Server execution problem.

Question asked by jamespr Champion on Sep 19, 2018
Latest reply on Sep 20, 2018 by jamespr



I'm trying to figure out a connection problem in our of our environment. Currently we have a server running Power BI Report Server. In this server I have configured a Linked Server to our AF Database, which is in another server. Using the Report Builder tool I have no problem testing an stored procedure using the Linked Server. All the data is displayed in the Design and Run Mode. But when I try to run the same report using the Web Client, event from the local server I got the following error:


An error has occurred during report processing. (rsProcessingAborted)

Query execution failed for dataset 'sp_Events_Collection'. (rsErrorExecutingCommand)

Cannot initialize the data source object of OLE DB provider "PIOLEDBENT" for linked server "LINKEDAF".



I followed all configuration settings available in the documentation (for PI OLEDB Enterprise, SQL, Power BI, etc) but for some reason using the web client triggers the above error. Any idea why?