Forum Discussion

eromanov's avatar
eromanov
New Member
10 years ago

Filemaker Server ODBC issues

Has anyone managed to successfully import data from Filemaker Server via ODBC yet? I have spent hours trying to set it up today, and all I keep getting is a very useless error message, telling me that there is an error but no description of error has been provided!

 

I can get data out of the database via Excel, architectures of Power BI, ODBC drivers and Filemaker all match... but it just doesn't want to work!

Need Help

8 Replies

  • badr_khamlichi's avatar
    badr_khamlichi
    New Member
    10 years ago

    Hi,

     

    I have the same problem, the ODBC driver is working because i can get the Data from FileMaker Database using MS Query on Excel; but i can't do it with Power BI or Power Query.

    it's unfortunate !   :smileysad:

     

    On Power BI no message error, but on Power Query i have : « Invalid handle. »

     

    If some one can help us !

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      I'm experiencing the same issue...

       

      In PowerBI I receive an "Invalid handle" error.

       

      :smileyfrustrated:

    • tristanstcyr's avatar
      tristanstcyr
      Helper I
      10 years ago

      Hi,

       

      Can you use the "Send a Frown" feature to send us an email and include trace files produced when reproducing the error?

       

      ODBC drivers are often crafted in a way to comply with exactly how Excel uses ODBC instead of the actual ODBC specification. For various reasons, Power Query / Power BI do things slightly differently.It is very likely that we can look at the details of where the error is happening from the traces and fix the issue in an upcoming release.

       

      Thanks!

      Tristan St-Cyr

  • Revathi223's avatar
    Revathi223
    New Member
    10 years ago

    Hello!!

     

    Did anyone succeeded importing the data in to Power BI using FileMaker ODBC  connection?

     

    Thank you,

    Revathi

     

     

    • arify's avatar
      arify
      Microsoft Employee
      10 years ago

      Hi Revathi,

       

      Have you tried using the latest version (the one that released on 7/1)? What kind of error did you get?

       

      Thanks

      • GeoSteven's avatar
        GeoSteven
        New Member
        9 years ago

        This looks to be a dated, but active thread. I'm interested in a solution to this issue as we have an extensive FileMaker solution built. Connecting PBI directly to those tables would be a huge time saver. 

         

        I'm new to Power BI. How can I determine the version I'm using? Are there any specific instructions on setting up a Power Bi to Filemaker connection?

         

        Thanks in advance,

        Steve