Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
Something alarming has just happened.
All was working until this last weekend.
I connect to a FileMaker database and the connection was working so that the automatic refreshes worked. Suddenly failed.
The error message includes this:
ISAMS_Gateway: | Unable to connect to the data source undefined. |
Underlying error code: | -2147467259 |
Underlying error message: | ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified |
NB
In 'Data Source Setting', have put into the Connection string the System DSN.
Appreciate assistance!!
John
HI @John4Roberta ,
It will be help if you provide more detailed error messages.(e.g. refresh history, detailed error message, snapshot..)
In addition, this error message seems related to configured datasource.
Have you try to update your gateway to latest version or remove old datasource and create a new one to instead?
Regards,
Xiaoxin Sheng
Good morning Xiaoxin
Thank you for your assistance.
Tthe fuller error message is:
Thank you Gilbert
Reckon it is ODBC on the Gateway Server that is the issue.
Do you have some guidance/loink to assist me with getting it on the Gateway Server?
John
OK Gilbert
Sounds quite straight forward. Our network manager if unavailable until next week.
Will report back on my progress here then.
Thanks
John
Morning Gilbert
Thank you for your suggestion.
How do I do this?
Presumably MS have recently tightened up security, so that what had been working no longer is.
John
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.