My company suddenly switched to Power BI as a corporate visualization tool but I have a large PostgreSQL database/infrastructure in place.
I was able to download PostgreSQL drivers and connect to my data, but I am not seeing a way to schedule refreshes/publishing. If I go to the Power BI 'cloud' portal I see that the cloud can connect to Azure SQL Database, Azure SQL Data Warehouse, SQL Server Analysis Services, and Spark.
Can I configure the Power BI cloud to refresh data from my local PostgreSQL database? Or, if I create a Linux VM on Azure and install PostgreSQL, will I be able to schedule refreshes there? I just want to add the dashboards which update every 30 minutes so an end user just needs to refresh their browser. Or do I need to pipe data from PostgreSQL to a Microsoft DB?
I would much rather be able to use PostgreSQL if possible, and I would like to have Linux as well as the server OS because I am using Python Airflow to schedule tasks (don't think it works with Windows).