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.
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.
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!
@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.
@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.
Hi @Anonymous ,
As of now, Automatic refresh is not available within Power BI Desktop. The only refresh option within BI Desktop is the manual Refresh you find in the top ribbon. Here is an idea: Auto refresh data in Power BI desktop
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunately, 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.