Forum Discussion

TotunG's avatar
TotunG
Resolver I
3 years ago
Solved

Excel Source Data Column Hiding

Hi all,   I have a BI that is using an Excel file as source data. However, the users that input data to this Excel will hide the week column once it has passed. This means that my query to this dat...
Need Help
Tips and Tricks
Tutorial Requests
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi TotunG ,

     

    If you're referring to someone else's change to the Excel file causing the change of your data in Power BI, please consider about uncheck the Include in report refresh option.

    You can exclude queries from being refreshed when the report is refreshed by un-checking 'Include in report refresh' in the context menu of the query in Desktop or in the Properties screen:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi TotunG ,

 

If you're referring to someone else's change to the Excel file causing the change of your data in Power BI, please consider about uncheck the Include in report refresh option.

You can exclude queries from being refreshed when the report is refreshed by un-checking 'Include in report refresh' in the context menu of the query in Desktop or in the Properties screen:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

TotunG's avatar
TotunG
Resolver I
3 years ago

Thank you for the tip - not quite what I was meaning but I think I've figured it out now. Cheers!