Error pulling data VIA Denodo ODBC connection

[vibhav92]

I am able to connect via Denodo ODBC connection, and preview the data as well. But when I try to pull in the data I get an error. Please see attached screenshots. Thank you

[vibhav92]

Thanks for the response. But if you see the screenshot I attached, the message says "Connection successful". The link you provided gives solution to fixes the issue of connection being unsuccessful.. 

[Anonymous]

Hi @vibhav92 ,

There's a document talking about this similar error.

(Class not registered) error when updating PowerPivot data - Office | Microsoft Learn

This issue generally occurs under the following scenarios:

• You try to update the data with the most current data from the back-end server by using the Refresh All option in the Refresh menu.
• You try to import data by using one of the connections under the Existing Connection option in the Design tab.

This behavior is by design. It occurs when the provider that is defined for the data connection for PowerPivot data doesn't exist on your system.

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.