PowerBI Desktop live connection (scheduled update) via ODBC

[techvenom]

Is there a way i can make a live connection with a database (or a scheduled data update) via ODBC? To simplify, i need to get data in Power BI updated when i make a change in database file (i doesn't have to be a live connection, it can be a scheduled update every hour or something like that).

P.S. If it matters, i'm using ODBC to connect to firebird database file.

[v-qiuyu-msft · Accepted solution]

Hi @techvenom,

Power BI doesn't support to get data from ODBC data source in a live connection or DirectQuery mode. In your scenario, you can import data from the ODBC in desktop, then publish the report to service. Then configure the ODBC data source under data gateway, configure the dataset use this gateway to access data source. Schedule refresh for the dataset.

Best Regards,
Qiuyun Yu

[hujasper]

Just as a side note, you willl have a limit to 8 Refreshes a day with that solution.