PowerBI (DirectQuery Limitation)

[N_Ali]

Hi,

I am currently creating a dashboard in PowerBI and all the visuals load perfectly fine besides the table. I am using DirectQuery (with PostSQL) - I ran the performance analyzer and it shows the following below. The data is only about 5000 lines on the table (and we have already applied one filter). I've also removed queries that I did not use in my visuals + I removed columns in the queries I used that I did not need. The table visual only has about 18-19 columns (coming from two different queries within the same connection)

Is there any suggestion on how to fix this duration on the visual loading? I am not sure what more I can do because I've cleaned out all the data that is not being used and I am not using too many measures in my dashboard. 

[N_Ali]

Hi,

I am currently creating a dashboard in PowerBI and all the visuals load perfectly fine besides the table. I am using DirectQuery (with PostSQL) - I ran the performance analyzer and it shows the following below. The data is only about 5000 lines on the table (and we have already applied one filter). I've also removed queries that I did not use in my visuals + I removed columns in the queries I used that I did not need. The table visual only has about 18-19 columns (coming from two different queries within the same connection)

Is there any suggestion on how to fix this duration on the visual loading? I am not sure what more I can do because I've cleaned out all the data that is not being used and I am not using too many measures in my dashboard.