Hi,
My data source is a postgres server and I query around 15 tables in it and then do a lot of transformations inside the query editor. The Total rows I import from the database is less than 1M.
Usually, when I do manual/schedule refresh of the pbi report via an on-premise gateway it takes around 10-15 minutes which is quite a lot but not a major problem as of now.
Recently I made some modifications to the report (Queried some new tables from the database) and added around 100-150K rows more along with some more transformations in power query. But now When I do a schedule/manual refresh in via the gateway, it takes more than 2 hrs and it still won't complete. It just says Refresh in progress.
I am at loss as to what operation is causing such a huge amount of time. How do I debug it to find which database query or power query transformation is taking too much time?
I used DAX Studio to check the memory of the tables and it is 45MB (after making the modification I am guessing it may change up to 60 MB) which I don't think should cause much trouble. I even tried checking the gateway logs but got confused on how to read them as they are many log files.
Is there any way to get the time taken to execute each database query and/or power query transformation (maybe through the logs?) so that I can pinpoint the actual issue and optimise it otherwise I am just shooting arrows in the dark.
Any help is greatly appreciated.
