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.
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.
Solved! Go to 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
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
Just as a side note, you willl have a limit to 8 Refreshes a day with that solution.
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.