Forum Discussion

Power_It_Up's avatar
Power_It_Up
Icon for Helper II rankHelper II
8 months ago
Solved

Denodo causing ODBC error

Afternoon.   I have a Denodo script which has run perfectly well until I added this statement:   CAST( CASE WHEN g.caseid = '1234' AND r.priority = 'Y' THEN '1234Y' WHEN g.caseid = '1234' TH...
Need Help
  • Power_It_Up's avatar
    Power_It_Up
    8 months ago

    cengizhanarslan Thank you for replying. I tried the refresh preview prior to executing the query but it still shows the same error.

     

    Edit: I opened a fresh workbook and placed my query in that and it's working fine! I can't re-create the whole workbook, but this is interesting.

     

    Edit2: I added a duplicate Denodo query in the existing problematic workbook and this one is executing fine.  So something is causing the original query to fail.

Power_It_Up's avatar
Power_It_Up
Icon for Helper II rankHelper II
8 months ago

cengizhanarslan Thank you for replying. I tried the refresh preview prior to executing the query but it still shows the same error.

 

Edit: I opened a fresh workbook and placed my query in that and it's working fine! I can't re-create the whole workbook, but this is interesting.

 

Edit2: I added a duplicate Denodo query in the existing problematic workbook and this one is executing fine.  So something is causing the original query to fail.

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
8 months ago

Hi Power_It_Up,

Thank you for the update. We appreciate your efforts and are glad to hear that the issue has been resolved.

Your findings are valuable and will certainly help other community members who may encounter similar behavior related to cached metadata in Power BI.