Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

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.⚡

 

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.