Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |