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.
Hey,
I have one machine where PBI Desktop is installed and is used for development.
This machine has an ODBC configured to connect to a different server that runs Firebird.
PBI Desktop is working well and I am able to connect to the DB.
When I am trying to connect with PBI Service and configure the gateway, I am failing to do so.
I have the gateway installed on the Firebird server as well as the development server.
Error:
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
Activity ID: | c7cd0466-c9cb-4aaf-9145-4476c261b706 |
Request ID: | 62eb7450-8b3a-9128-a98c-d18a3f2fb611 |
Cluster URI: | https://wabi-australia-southeast-redirect.analysis.windows.net |
Status code: | 400 |
Error Code: | DMTS_PublishDatasourceToClusterErrorCode |
Time: | Tue Apr 02 2019 15:38:28 GMT+1100 (Australian Eastern Daylight Time) |
Version: | 13.0.8960.148 |
CDS: | Unable to connect to the data source undefined. |
Underlying error code: | -2147467259 |
Underlying error message: | ODBC: ERROR [08004] [ODBC Firebird Driver]Unable to connect to data source: library '\\server2\c$\Program Files\Firebird\Firebird_2_5\Bin\fbclient.dll' failed to load |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.ValueError.DataSourceKind: | Odbc |
Microsoft.Data.Mashup.ValueError.DataSourcePath: | dsn=firebird_64 |
Microsoft.Data.Mashup.ValueError.Reason: | DataSource.Error |
Thanks a lot!
Solved! Go to Solution.
Hi @Anonymous
According to another sloved thread "schedule refresh using ODBC (Firebird driver) and Data Gateway"
The following should be helpful.
Firstly, please create a System DSN to points to your data source, then add the ODBC data source under gateway.
Secondly, follow the guide in this similar thread to add your ODBC data source within on-premises gateway, then check if you can refresh your dataset.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I had an issue with my ODBC configuration.
It was an issue like a typo or something silly like that.
So, there wasnt any real issue after all.
Thanks
A
Hi @Anonymous
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Best Regards
Maggie
Hi,
I had an issue with my ODBC configuration.
It was an issue like a typo or something silly like that.
So, there wasnt any real issue after all.
Thanks
A
Hi @Anonymous
According to another sloved thread "schedule refresh using ODBC (Firebird driver) and Data Gateway"
The following should be helpful.
Firstly, please create a System DSN to points to your data source, then add the ODBC data source under gateway.
Secondly, follow the guide in this similar thread to add your ODBC data source within on-premises gateway, then check if you can refresh your dataset.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
User | Count |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |