Forum Discussion
Automatic Power BI refresh in import mode
Hello Power BI community,
Hope everyone is doing well. I am trying to solve the automatic refresh in the POwer BI desktop since my data is in Import Mode. There is a very simple procedure for the Scheduled refresh in Direct Query but i was wondering if there is any facility to Automatically refresh the Import at any perticular time of the day.
Help will be much appreciated.
Thanks,
Vatsal
9 Replies
- DMiradakis
Advocate II
Great question here. The answer is a little complicated.
In summary: no, you cannot use Automatic Page Refresh with Import Mode. Import Mode is not supported in that feature, period, regardless of licensing types or capacities.
However, this is still possible through other solutions - just not through Automatic Page Refresh.
For example, if you use Power BI Premium Per User (PPU), Premium Per Capacity, or an Azure embedded capacity, then technically you can get an unlimited number of refreshes for an Import Mode dataset; you just have to setup some sort of pipeline to automate the refreshes above 48 times per day, such as by using Power Automate, Powershell, or HTTP calls to the Power BI REST API.
If you were to do that, then you could use the Power BI JavaScript SDK to check for refreshed Import Mode data up to every 15 seconds - and if Import Mode data is found, then the Power BI JavaScript SDK can actually force the visuals on the report canvas to update.
This is exactly what I've done to build a custom Power BI app to help people build advanced slideshows and display them on TVs and other unattended devices (disclaimer, I'm the founder: https://www.displagent.io).
Hope that helps!
- parry2k
Super User
Anonymous In Power BI Desktop you cannot auto-refresh using import, but for the direct query, you can use automatic page refresh.
Although in Power BI service, you can set a schedule refresh for Import.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Tahreem24Unfortunately, you can not auto-refresh data with import mode in desktop.
Good that you are aware of direct query mode.
With the help of the Data Gateway you can auto-refresh the data with import mode.
Tahreem24My data is on Cloud so i can not set up the data gateway at this point for the Auto Scheduling. I know there is a way to add the Python scripting to the Windows task manager to Automate the refreshing but i was looking for something more robust. Thanks for the help.
parry2k My data is on Cloud so i can not set up the data gateway at this point for the Auto Scheduling. I know there is a way to add the Python scripting to the Windows task manager to Automate the refreshing but i was looking for something more robust. Thanks for the help.
- parry2k
Anonymous one thing I'm not sure, why regular schedule with import without gateway is not working, what we are missing here?
what I've learned is that when my data is in import mode, the page refresh doesn't show, but when I add direct query data, it does show.
See image for reference. On the first image I have a direct query data as you can see page refresh is showing, on the second image once i remove the direct query data the page refresh option is not showing
