Forum Discussion
OLE DB or ODBC Error:[Datasource.Error] OLE DB: The connection returned error code -2147467259..
Using PBI desktop connecting to a cloud-based source using an ODBC connection.
Has been working fine until one of the views I'm refreshing has started returning the above error message.
I need a definitive "translation"of the error message.
I think it is an issue with the data, and need to be able to locate which data as well.
Suggestions?
9 Replies
Hi rodjarman
This is probably coming from calculated columns or relationship can you go to Options > Data loading > And disable the one that detect new relations and the one that import relations from other sources ?
Then try again
- Quentin
Thanks Quentin.
I've isolated the view into a separate desktop file. There are no relationships and no calculated columns.
Turned off the options you suggested. Attempted import. Still get the same error message. :smileyfrustrated:
So even when you try to import the view in a new PBI file it display this error ?
Can you post a sample of your data so that I have an idea ? (If it's sensitive you can make them anonymous or not post it as you want)
- Quentin
