Forum Discussion

Andy__'s avatar
Andy__
Frequent Visitor
2 years ago
Solved

SQL linked server problem?

Hello   We have a linked server in SQL server that points to an Oracle database.   And we create one view by selecting tables (with joins) in the linked server.   And in Power BI Desktop, we ad...
Need Help
  • Andy__'s avatar
    Andy__
    2 years ago

    Thanks for your information, Yolo.  We changed our strategy by not using the linked server.

     

    Best regards.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Andy__ 

1.Check to see if there is any data in the data source that has been modified, such as a change in the data structure or a change in the column name, which may cause Power BI to not recognize the data, which may cause the visual to not load.

2.You can refer to the followinf link. It describes that, it is better to match the service name.

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server - Stack Overflow

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Andy__'s avatar
    Andy__
    Frequent Visitor
    2 years ago

    Thanks for your information, Yolo.  We changed our strategy by not using the linked server.

     

    Best regards.