Forum Discussion

GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago

ODBC connection walkthrough help

Hi everyone,   I have searched the internet and the forums and cannot seem to find a clear walkthrough of how to connect to and ODBC. The system I am trying to connect to is a Clarion system using ...
Need Help
GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago

ankitpatira I am currently having issues trying to connect to an ODBC driver. The furthest I can get is the list of tables in the driver in Power BI but if i select a table I get an error message saying;

 

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

 

I can connect to the data in Excel 2016 without an issue.

 

Thanks,

 

Giles

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

@GilesWalker are you connecting by creating DSN adn using that DSN in power bi or straight using connection string for ODBC ? I would suggest to create DSN and use that in power bi.