Forum Discussion
Max size using a large Database
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...
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
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?