SQL Azure Database with DirectQuery not automatically refreshing the report

[haric]

I am using a PowerBI desktop to connect to SQL Azure and author my report.

I upload the report to power bi.

But the report refresh doesnt happen automatically. I have to refresh the data set and then the report manually.

Is there any work around? 

I find that if i login to power bi within a browser and use the Get Data then the SQL Azure connectivity is live.

But i did not want to recreate the whole report within the browser just for this purpose.

Seems a bit weird.

Any help appreciated ?

[ankitpatira · Accepted solution]

@haric it depends on how have you connected to Azure sql db via PBI desktop. Have you used Improt or DirectQuery ? 

[haric]

Thanks i changed the option to DirectQuery and it works.