Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
Solved! Go to Solution.
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
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 80 | |
| 49 | |
| 35 | |
| 31 | |
| 30 |