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.
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
Solved! Go to 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.
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.
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.
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!🙂
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.
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.