Forum Discussion

Ethanhunt123's avatar
Ethanhunt123
Icon for Helper IV rankHelper IV
6 years ago

Dataload in PBI desktop

I am trying to load data in import mode from SQL server and it gives me this error "Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Microsoft SQL...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Ethanhunt123 - OK, and now what authentication are you using? And I suppose you might want to check the basics like whether or not you can connect to it via something like Microsoft SQL Server Manager, etc., can you ping it, etc. The error looks like it is timing out trying to communicate with the SQL Server.

  • Ethanhunt123's avatar
    Ethanhunt123
    Icon for Helper IV rankHelper IV
    6 years ago

    Yes I can connect to that DB and query that view in the DB