Forum Discussion
Helper IIUsing Direct Query vs Import for a dataset of 120 million rows
Currentlt, power bi doesn't support live connection or Direct query with postgre, you may vote for this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31619011-implement-live-directquery-for-postgres.
To aggredate the values and generate new smaller tables, I'm need to import the data source into power bi firstly. If the datasize is very large, I would suggest you to do that in database.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support
Currentlt, power bi doesn't support live connection or Direct query with postgre, you may vote for this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31619011-implement-live-directquery-for-postgres.
To aggredate the values and generate new smaller tables, I'm need to import the data source into power bi firstly. If the datasize is very large, I would suggest you to do that in database.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.