DirectQuery report takes a long time to update after a parameter is updated

[xli629b]

I have a report connected to a PostgresSQL database with DirectQuery through a gateway. It has a parameter tableName for the table it queries. If I update the parameter via the REST API, the parameter value immediately gets updated according to the result of Get Parameters with the REST API.

However, the report still shows the data for the previous value of the parameter, and from the DB logs, PBI still queried the DB with the old value of the parameter. This remains the case when if I repeated click the "Refresh" button.

The report gets updated in 8-30 minutes. Why would the parameter take so long to update?

[V-lianl-msft]

Hi @xli629b ,

When the dataset is refreshed, cloud service creates a query, sends the query to a queue for the gateway to process, and then pushes the request to azure service bus.

So it will solve the requests one by one, not at the same time.

You can refer to the document:https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-indepth 

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

[xli629b]

When I press refresh, I see from the database log that a query immediately ran with the new parameter. So it seems that it's not waiting for the gateway to query the database though.

[V-lianl-msft]

Hi @xli629b ,

DirectQuery is a direct connection to data source. Data will not be stored in Power BI model.

As a result, your report performance in these cases depends largely on the performance of the underlying data source.

You could learn more about performance:

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance 

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

[xli629b]

The underlying data source responds immediately as we see when we query it directly and from the logs, so that should not be the cause of the delay.