Filemaker Server ODBC issues

[eromanov]

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!

[Revathi223]

Hello!!

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

Thank you,

Revathi

[arify]

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]

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

[lazarus]

I am successful connecting Microsoft BI to a Filemaker database via ODBC. This file is hosted on a Filemaker Server 16 (Windows)

Microsoft Power BI Desktop version: 2.50.4859.502 64-bit (September 2017)

Filemaker Server 16 version: 16.0.1.184

Data refreshes as expected.

[greg_davis]

Same issue here. Are there any updates on this?

[tristanstcyr]

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

[badr_khamlichi]

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 !   

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

If some one can help us !

[Anonymous]

I'm experiencing the same issue...

In PowerBI I receive an "Invalid handle" error.