Max size using a large Database

[Macwin]

Im trying to create a report with 54 millions data (updating everyday) with a live query from a postgres sql server. 

I already created a view on my server and im using this view as datasource (with calculation). This should improve my perfomance. My goal is to create report  with livetime filtering for users.

But at the moment im facing this problem 

[RobbeVL]

Hi,

I'm not an expert on this, but I dont think that view will improve your performance.

Is it possible to connect to the tables seperately? Have you tried to run the view from the PowerBI end in stead of the server? 

robbe 

[Macwin]

I followed this article about data import.

https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/

Im using the import function instead of direct query.

thats a way faster. 

So only solution  i see at the moment is

- use import 

- setup refresh feature on bi site. (refresh everyday at night )

- use views instead of tables

are there other hidden secrets for better perfomance?