Forum Discussion
Failure in refreshing : ODBC + Excel + Power BI (streaming dataset)
Hi, everyone!
I've just found this article which explain how to push data into a streaming dataset
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?
2 Replies
- lbendlin
Super User
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?
v-kelly-msftCommunity Support
Hi psarvr99 ,
Check below reference for connecting postgreSQL to power bi :
https://www.cdata.com/kb/tech/postgresql-powerbi-gateway.rst
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
