Solved: Direct Query for PostgreSQL

Anonymous · ‎08-27-2019

I want my data set to be refresshed every hour and we know that on the free and pro version the limit is 8 times per day. After reading this thread, it seems that Direct Query is what I need.

Right now I get my data on power bi from PostgreSQL(I connect to CrateDB by using ODBC). I've seen from here that Direct Query doesn't support PostgreSQL.

Is there any alternative solution?

If not, would you think it would be a good idea to write a script where Power BI service is opened automatically and the "Refresh" button is manually clicked by the program every hour?

Thank you.

v-frfei-msft · ‎08-27-2019

Hi @Anonymous ,

Based on my research, it is not supported yet currently. There is an idea about that you can vote it up to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19065214-postgresql-direct-query

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

v-frfei-msft · ‎08-27-2019

Hi @Anonymous ,

Based on my research, it is not supported yet currently. There is an idea about that you can vote it up to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19065214-postgresql-direct-query

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.