Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Planned refresh issue

Hi,

 

I want my dataset to update every 15 minutes, but I'm not able to choose for this option. I can only choose that the 'refresh rate' is daily or weekly. I know that this is because I don't have a direct connection, but I did everything this page said to add my database to the Power BI App.

 

Any thoughts on how to fix this?

Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous ,

     


    Does that make sense? If so, please mark the helpful answer as the solution. More people will benefit from here. If you still have questions, please feel free to ask us.

     

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Anonymous - Do you have Premium capacity? Otherwise I do not believe you can configure refreshes that quickly. 

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        While connecting data in Power BI Desktop, you should choose the direct query mode like below. Then after publishing to Service, you could configure schedule cach refresh.

        If there isn't the mode selection, it means the data source don't support direct query mode. You could reference the document to check it.

        Power BI data sources 

         

        For refresh, please reference:

        Datasets in DirectQuery/LiveConnect mode 

         

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     


    Does that make sense? If so, please mark the helpful answer as the solution. More people will benefit from here. If you still have questions, please feel free to ask us.