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
ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

GilesWalker we have odbc before to connect to firebird database using firebird odbc driver. process was quite simple as we first created system DSN and tested out ODBC driver and then connected to that DSN using power bi ODBC connector. since you're dealing with files i would suggest you create DSN and test out your ODBC driver first before using it with power bi. Power BI also gives you option to enter in connection string and connect that way if you don't want to create DSN. Both ways have worked fine for me using firebird odbc driver.

 

  • 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.

  • vmsouza30's avatar
    vmsouza30
    Helper I
    9 years ago

    Hi,

    Do you have the documentation about conecction between Power Bi and ODBC Firebird?

     

    Tks