Forum Discussion

Macwin's avatar
Macwin
Helper I
6 years ago
Solved

Perfomance Questions

Hello Guys, Im still working on my Project with a large dataset. Since I cant use import mode because of the size restriction I have to use direct Query. My Datasource is a database in postgresql...
Need Help
Tips and Tricks
jessegorter's avatar
jessegorter
Helper I
6 years ago

I do not know a lot about postgresql, but if it has something like sql profiler you may check what queries PBI sends to it and tune those.

 

Does it have options like clustered columnstore index? Then that may be interesting to try.

Macwin's avatar
Macwin
Helper I
6 years ago

I switched to azure database for postgressql 

Count with a Filter takes 101.000 ms and distinct count with a filter takes 37000 ms (Data for single day)

Should I create the hidden aggregated table in bi querie editor or should I create a aggregated table in my SQL server.

 

 

To your Question -> there is something called timescaledb, but its only for bigger data. We going to setup up this later but at the moment there is no need since Im only testing with data of 1-3 days.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Macwin ,

     

    “Should I create the hidden aggregated table in bi querie editor or should I create a aggregated table in my SQL server.”

    It's better to create the hidden aggregated table in Edit Queries.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.