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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      Anonymous one thing I'm not sure, why regular schedule with import without gateway is not working, what we are missing here?

    • V-lianl-msft's avatar
      V-lianl-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      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

       

      Best Regards,
      Liang
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I am trying to setup a schedule refresh, but I am not able to access the refresh options