Forum Discussion

newpi's avatar
newpi
Helper V
5 years ago

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...
Need Help
Show and Tell
Tips and Tricks
v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

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.

newpi's avatar
newpi
Helper V
5 years ago

v-jingzhang I tried removing the edits but its still the same. There is this particular column I had added which caused the error in the first place. Now I have even removed this column but it still shows me this error on refreshing as well as when I start over by creating a new PBIX file and load data.

Can't seem to fugure out why this column last_report_logs is the problem. I have removed that column from my query and its still showing that error

 

So I have two quesries in big query.
Query 1: Has all values that I wanted to get &

Query 2: Just the max values from above query 1.