Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Refresh only one file from folder

Hi everybody!

 

Let's see if you can help me :smileyvery-happy:

I have a data model that gets information from a folder. That folder has lots of different and big files in it (at least 20 or so). The thing is, i only want to refresh one of them (the one referring to the current month, highlighted):

 

 

 

Is there a way to do that?

 

Thanks in advance!

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Anonymous,

     

    >>The thing is, i only want to refresh one of them (the one referring to the current month, highlighted):

    Current, power bi not suppot this.

     

    In my opinion, I'd like to suggest you create a reference query and navigate it to the specified file, then disable refresh of original query.  After these steps, you can refresh the specify file.

     

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Xiaoxin! Thanks for the reply. 

       

      I do not know how to create a reference query, nor disabling refresh.  BTW, I only use Power BI Desktop. Can you show me any image or step by step? That would be really handy.

       

      Thanks again

       

      Santt

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Anonymous,

         

        Sorry for slow response, below are operation steps and screenshots:

         

        1. Right click on the query which you want to reference.

         

        2. Choose the "Reference" option to create a new reference query.

         

        3. Navigate to the referenced query and choose the file which you want to keep.

         

         

        4. Uncheck the "include the report refresh" option of original query.

         

        Regards,

        Xiaoxin Sheng

    • Siepe90's avatar
      Siepe90
      New Member
      9 years ago

      Dear Xiaoxin Sheng / Anonymous,

       

      I have the same questions as Anonymous, would be great if you could show us / me a step by step on how to implement the solution you suggested.

       

      Eagerly awaiting your response!

       

      Thanks in advance and kind regards,

       

      Stefan