Forum Discussion
Getting OLE & ODBC error on refresh
Hi,
I had this report which was working fine . Then I made a few edits in the SQL query in Google BigQuery (basically added a new column in there) and since then I'm unable to refresh this report. Its showing me weird error i'm unable to resolve.
Also, I tried importing it in a new File but that did not work as well. I tried looking at similar issues but nothing worked for me in the solutions provided.
4 Replies
newpi You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".Greg_Deckler The problem is when I load other tables data its working fine. Only this particular table which I had edited and now have mostly reversed those edits is causing an error.
So that tells me its something related to my table data or data type. But the query is working is fine in Big Query.newpi does the error occur if removing all the edits that may have caused this error? Could you please check if there is any error in Applied Steps of the Power Query Editor? If so, remove or correct the error steps.
