Forum Discussion

haric's avatar
haric
New Member
10 years ago
Solved

SQL Azure Database with DirectQuery not automatically refreshing the report

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 th...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

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

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

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

  • haric's avatar
    haric
    New Member
    10 years ago

    Thanks i changed the option to DirectQuery and it works.