Forum Discussion
Power BI Service Gateway ODBC Connection string and FileMaker
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. Sud...
HI Anonymous ,
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:
Underlying error code-2147467259 Table: Quartile.Underlying error messageODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedDM_ErrorDetailNameCode_UnderlyingHResult-2147467259Microsoft.Data.Mashup.ValueError.DataSourceKindOdbcMicrosoft.Data.Mashup.ValueError.DataSourcePathdsn=BRY-FMSERVER-PupilSubjectIndicMicrosoft.Data.Mashup.ValueError.ReasonDataSource.ErrorThe refresh history simple shows functioing before the weekend fine and no failing.We do use the latest Gateway. I have other PBI datasets that have fallen over becuase of this same issue.So it surely is unlikely that deleteting the datasource and recreating would overcome?John- Hi there
It would appear that it is the source name for the ODBC driver is either missing in the PBIX or on the Gateway server?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
