Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
HI . I have a problem with a report that was created some time ago by somebody else.
Here is the premise:
Other reports who does not use wiews are refreshed fine.
We migrate some data from SQL server to a new one and we had a new gateway installed on the new server.
The data for the report is in SQL MS server as views and tables but the underline data is comming from Oracle.
The tables are created using SQL jobs from Oracle linked server and some views are coming from oracle linked server using OPENQUERY.
When the report is refreshed from Power BI desktop there is no problem but when published and refreshed on the service I have this error,
then below are the linked server options
Thank you
Solved! Go to Solution.
Hi @Anonymous
It would appear that the Gateway cannot connect to the instance with the OLE DB Provider driver on the gateway. I would make sure to have it installed on the gateway server.
Hi . I figure out at the end. The problem is that on the new SQL server under Linked Servers - Providers , under OraOLEDB.Oracle the Allow inprocess was not checked- see pics
Hope will help others with this issue
Tkanks all
PS. Make sure to restart the database services to see the change.
Hi . I figure out at the end. The problem is that on the new SQL server under Linked Servers - Providers , under OraOLEDB.Oracle the Allow inprocess was not checked- see pics
Hope will help others with this issue
Tkanks all
PS. Make sure to restart the database services to see the change.
Hi @Anonymous ,
On the server(s) that houses the gateway inside your system you need to have the ODBC/OLE drivers installed. I have seen this error when the drivers and setup is fine on your computer (where you are running desktop) but not on the servers housing the gateway software.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @Anonymous
It would appear that the Gateway cannot connect to the instance with the OLE DB Provider driver on the gateway. I would make sure to have it installed on the gateway server.