Unnable to connect to Firebird through ODBC on Power BI Gateway

[Anonymous]

Hi,

I was not able to set a new data source to get data from Firebird through ODBC on the Power BI Gateway after publishing the pbix File to Power BI Service.

Actually I have successfully got the Firebird's data through ODBC on Power BI desktop, while it show some error when setting the Gateway as below.

Could you please help to find out how to solve it?

Best Regard,

Ada

[v-xulin-mstf · Accepted solution]

Hi @Anonymous

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,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[v-xulin-mstf · Accepted solution]

Hi @Anonymous

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,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-xulin-mstf 

     I have built a User DSN for Firebird, which can successfully linked to the Desktop.

     Maybe I also need to build a System DSN for it to set in the Gateway.

    Many Thanks!🙂

[v-xulin-mstf · Accepted solution]

Hi @Anonymous

Okay, if the issue has been solved, please adopt the solution to help others. 😉

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.