Forum Discussion

pmaass's avatar
pmaass
New Member
4 years ago
Solved

Include in report refresh

My request for help to the community is because I have 3 Excel files with the sales data for January, March and April. I have appended them in PQ creating the new Months query. For the January, Febru...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi pmaass ,

     

    Unchecking "Include in report refresh" will stop refreshing the query (in Desktop and Service), yet if you reference this query in another query, it disregards the setting and refreshes it again.

     

    The two workarounds are:

     

    1. Use incremental refresh. But its refresh partition is dynamically changing, and it can't be kept as refreshing March data only.

    Incremental refresh for files in a Folder or SharePoint – Power BI 


    2. Use DAX instead of M code to combine these tables, and then hide the tables in the model. And uncheck "Include in report refresh" for the January and February tables. This way when the merged table is refreshed only the March data will be refreshed.

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi pmaass ,

 

Unchecking "Include in report refresh" will stop refreshing the query (in Desktop and Service), yet if you reference this query in another query, it disregards the setting and refreshes it again.

 

The two workarounds are:

 

1. Use incremental refresh. But its refresh partition is dynamically changing, and it can't be kept as refreshing March data only.

Incremental refresh for files in a Folder or SharePoint – Power BI 


2. Use DAX instead of M code to combine these tables, and then hide the tables in the model. And uncheck "Include in report refresh" for the January and February tables. This way when the merged table is refreshed only the March data will be refreshed.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.