Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
brunozanoelo
Post Patron
Post Patron

Real time data using Gateway + ODBC + Firebird Database

Hello all my dear friends here,

I´m currenly having an issue that In one specific report I need to have real data.

I'm currently using Gateway + ODBC + Firebird Database (https://firebirdsql.org/ - Open source database).

 

How can I make this work? I´ve used for year those technologies to do refresh in specific times, however, I will need real data in this specific report.

Best Regards!

 

 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @brunozanoelo 

 

Unfortunately, not all data sources support real time.

You can reference this to see if it is supported: Power BI data sources - Power BI | Microsoft Learn

What I would suggest doing is to find a way to push the data from your Firebird database to the power of BI service streaming API.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

4 REPLIES 4
brunozanoelo
Post Patron
Post Patron

@GilbertQ  Thank you. I´ve build an service to update the dataset 5 - 5 minutes and worked perfectly. Best Regards,

Hi @brunozanoelo ,  are you able to share the design of your solution (which service did you use to refresh at 5min interval)?

I am trying to solve a similar problem of displaying near-real-time data out of our firebird database (production statistics on the shop floor used for productivity tracking)

Hi Bruno

I´m having problems to connect to an external Firebird database. Can you please share the solution you used to build this 5 minutes update service?

Kind regards

Cleber

GilbertQ
Super User
Super User

Hi @brunozanoelo 

 

Unfortunately, not all data sources support real time.

You can reference this to see if it is supported: Power BI data sources - Power BI | Microsoft Learn

What I would suggest doing is to find a way to push the data from your Firebird database to the power of BI service streaming API.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.