SQL Azure Database with DirectQuery not automatically refreshing the report

Question

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 Answer

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

Forum Discussion