Forum Discussion

vaibhavgupta02's avatar
vaibhavgupta02
Frequent Visitor
9 years ago

Exchange Server as a Data Source to Schedule Refresh

Hi All,   I have a requirement like Power BI cloud data should be refreshed as soon as the undlying Azure SQL data is updated. In the cuurent scenario , I have to wait for the schedule refresh to u...
Gateways
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

vaibhavgupta02

 

You can get data from Azure SQL Database with Direct Query in Power BI Desktop, and then publish to Power BI Service. Using DirectQuery, no data is imported or copied into Power BI Desktop. The selected tables and columns appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, which means you’re always viewing current data.

 

After publish to Power BI Service, you can set the refresh frequency to 15 minutes as below. In that case, dashboard tiles can be refreshed automatically every 15 miniutes.

 

 

Best Regards,
Herbert