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.

     

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Actually this is something which works in Power BI Desktop but not in Power BI service. Hence, if you unheck Include in report refresh - The functionality works only in Power BI Desktop and it will not have any impact in Power BI Service i.e. if you refresh report in Power BI service, this will still refresh all the queries even through Include in report refresh is unchecked.

It has been reported to Power BI Team through an idea logged here @ https://ideas.powerbi.com/ideas/idea/?ideaid=c464fb1a-25e4-4c93-ba72-288a6ff12127 

I would recommend that you should also vote for it. I just voted there and my vote number was 725.