Can't use query editor for any query using database A, but Power BI still connects to database A.

[Anonymous]

Reports are still running and A can still be connected to, but I can't use the query editor for any query using A. When I try, I ge the following error message.

DataSource.Error:Oracle:

Details:

DataSourceKind=Oracle

DataSourcePath=A

Message=

ErrorCode=-2147467259

There is no message, just the error code. Googling the code results in several issues, but none seem applicable to my situation.

Thank you for your help

[v-stephen-msft]

Hi @Anonymous ,

What specific operations did you implement that caused the error to appear?

Currently you can try the following solutions:

https://community.powerbi.com/t5/Desktop/Message-ErrorCode-2147467259/m-p/775959

https://community.powerbi.com/t5/Power-Query/Add-Column-with-blocks-of-text-and-columns-values-more-than-once/m-p/1600292

Best Regards,

Stephen Tao

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

[rufengli]

Hi, @Anonymous,

Thanks for reporting the issue.  We need more info from you to diagnose the problem.

1. What connector do you use?  Oracle or ODBC?

2. Do you have ODAC installed?  If yes, what version do you have?

3. Screenshots will help to understand your issue.