Failure in refreshing : ODBC + Excel + Power BI (streaming dataset)

[psarvr99]

Hi, everyone!

I've just found this article which explain how to push data into a streaming dataset

https://blog.crossjoin.co.uk/2016/11/08/pushing-data-from-excel-to-power-bi-using-streaming-datasets...

For me, it works perfectly. The problem is that I'm trying to apply this in a table that will be also refreshing every minute, this table is created by an ODBC conected to postgreSQL, I followed every step but I just get "Failure".

Does anyone know how to solve this or has any idea about getting data in real time through the driver?

[v-kelly-msft]

Hi  @psarvr99 ,

Check below reference for connecting postgreSQL to power bi :

https://www.cdata.com/kb/tech/postgresql-powerbi-gateway.rst

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[lbendlin]

Have you considered using a direct query connection to your PostGreSQL table?

Have you considered using a scheduling tool to push new rows from PostGreSQL into the streaming dataset?