Dataset successfully refreshes in service, no updated data? DirectQuery works fine.

[mchbi]

Dealing with a really bizarre issue and hoping someone here has come across it. We have a database hosted on a physical machine, running the on-prem gateway. Refreshing in Power BI desktop works just fine. DirectQuery in the service works fine as well. But when we refresh/scheduled refresh with Import mode, it finishes almost instantly with no errors and no updated data (there is updated data). Using PostgreSQL connector. Any ideas on what might be happening or how to troubleshoot? Tried a ton, like recreating the dataset, reinstalling gateway, re-adding the data source to the gateway.

[v-yetao1-msft]

Hi @mchbi 

Using Direct Query connection mode to connect to SQL can update the data from the data source in real time, but Import needs to refresh the dataset to update the data, so I'm wondering what caused you to choose Import connection mode instead of using DQ?

Best Regards,
Community Support Team _ Ailsa Tao

[mchbi]

We decided to use Import mode because it has better performance. The database we're using can be a bit slow, so caching data is really helpful for us (in most cases).

@v-yetao1-msft