Forum Discussion

Mimi_Ibrahim's avatar
Mimi_Ibrahim
Helper I
5 years ago
Solved

Include REFRESH statement in Power Query

My fellow experts, I need some advise on how to solve the current issue that I'm having. I have a PBI report that is connected to Cloudera Impala as the main data source and it has been refreshed fo...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    5 years ago

    Hi Mimi_Ibrahim ,

     

    If you connected with import mode, we only can refresh reports manully. If it is Direct query mode, you could use automatic page refresh in report view to query for new data. For now, unfortunatly,  there isn't statements that can refresh PBI.

     

    If you will publish pbix to Service, you could configure shcedule refresh to get new data on time. 

     

v-xuding-msft's avatar
v-xuding-msft
Community Support
5 years ago

Hi Mimi_Ibrahim ,

 

If you connected with import mode, we only can refresh reports manully. If it is Direct query mode, you could use automatic page refresh in report view to query for new data. For now, unfortunatly,  there isn't statements that can refresh PBI.

 

If you will publish pbix to Service, you could configure shcedule refresh to get new data on time.