Forum Discussion

Macwin's avatar
Macwin
Helper I
6 years ago

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 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 

Need Help
Tips and Tricks

2 Replies

  • RobbeVL's avatar
    RobbeVL
    Impactful Individual
    6 years ago

    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's avatar
      Macwin
      Helper I
      6 years ago

      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?