Firebird and VPN

Analitika - I really do not think that level of automation is really possible with Power BI alone. Perhaps you need to look into RPA technologies.

Analitika , Power BI works with data connection available using the provided connector. These things can not be done with power BI.

Hi Analitika ,

Basically, power bi only provides connector to Firebird, you can use ODBC to connect Firebird in power bi desktop:

It is assumed that you have already installed and configured a DSN for ODBC driver for Firebird.

1. Run Power BI Desktop and click Get Data.
2. Select the Other category in the Get Data dialog box, then select ODBC. Click Connect to confirm the choice.
3. In the From ODBC dialog box, expand the Data Source Name (DSN) drop-down list and select the previously configured DSN for Firebird
4. If you would like to enter a SQL statement to narrow down the returned results, click the Advanced options arrow, which expands the dialog box, and type or paste your SQL statement.
5. Click OK. If your data source is password-protected, Power BI will prompt you for user credentials. Type your Username and Password in the respective fields and click.
6. Now you should see the data structures in your data source. You can preview the contents of the database objects by clicking on them.
7. To load the Firebird data into Power BI for analysis, select the needed table and click Load.

After creating reports for the data source, you can publish it to power bi service to configure scheduled refresh for it.

If you have problems when connecting, you can refer the Firebird FAQ: The Firebird FAQ 

Best Regards,
Yingjie Li

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

Hi Analitika ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li