Dataset Refresh when using Direct Query

[varunsingh]

Hi,

I have created a dashboard where in i select the Direct Query mode in conection settings. I see the data and charts correctly when i open the ..pbix file in my powerbi desktop. Once i publish this report, the next time it does not refresh even though i have entered the SQL Credentials in the dataset.

I have a setup where in SQL DB is populated on daily basis. After publishing the powerbi report when using direct query, the report dosent get refreshed next day. I try to manually refresh also but nothing happens. I have to open the report in powerbi desktop, do a refresh there and then publish again.

How to make the data set getting refreshed when using the Direct Query mode. 

Thanks in advance.

Varun