Include REFRESH statement in Power Query

[Mimi_Ibrahim]

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 for few months now to run on daily basis. Lately the refreshed failed nearly everyday. I was advised by the technical team to run a REFRESH <table> statement in Cloudera sytem few mins before the schedule run and it seems to work.

The problem now is, how can I incorporate the REFRESH statement in Power Query so I don't have to run the command separately in Cloudera system?  By any chance the statement can be incorporated in as part of the power query M formula? Appreciate if you can advise, thank you!

[v-xuding-msft · Accepted solution]

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.