Disable Refresh for Excel File

[callenbkd]

The vast majority of data in my dataset is from Microsoft Business Central. There is an Excel file, which will not have its contents changed, that is part of the dataset. I do not need the Excel file to be updated. Is there a way to disable the need to refresh the Excel file while refreshing the Business Central data? 

[v-kathullac]

Hi @callenbkd,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.

Thanks

[v-achippa]

Hi @callenbkd,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @pallavi_r for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.

Thanks and regards,
Anjan Kumar Chippa

[v-achippa]

Hi @callenbkd,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.

Thanks and regards,
Anjan Kumar Chippa

[pallavi_r · Accepted solution]

Hi @callenbkd ,

Can you please try is this solves your problem. Right click on the selected datatable and power query editor. And then uncheck Include in report refresh.

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi