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). ...
Need Help
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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Anonymous, thanks again for your response

         

        I followed the steps, but i cannot navigate through the referenced query; if you see the applied steps, it only shows the final outcome of the original query instead of the files i want to evaluate:

         

        Sorry if my english is not really sharp :smileymad: 

        Any thoughts on this?

         

        Thanks!

         

         

  • 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