Showing results for 
Search instead for 
Did you mean: 
sjungels Frequent Visitor
Frequent Visitor

PBI Embedded Using PostgreSQL Running on Linux: Daily Refresh Needed



my PostgreSQL runs in a Linux environment. I'd like to use PBI Embedded (app owns data) to connect to the DB. Now, I understand - in general - there are 2 options how to update / refresh the data so that users can enjoy the latest numbers in the reports / dashboards / etc:


1. The PBIX file needs to be updated to have the latest data. This can be done by using a data gateway (which is not available on Linux)

2. Using a live connection or direct query which PostgreSQL doesn't support. This would be done using a PBI Template (PBIT file), correct?


Is this correct?


Now, what are my options? Install PostgreSQL on a Windows machine and use the data gateway?