Forum Discussion
Denodo causing ODBC error
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 BI caches column metadata. After changing the Denodo view/query, in Power Query you may need to:
Clear cache / refresh preview
Or remove/recreate the step that defines the source schema
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.
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.
