Forum Discussion

callenbkd's avatar
callenbkd
Helper II
1 year ago
Solved

Disable Refresh for Excel File

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? 

Need Help
  • pallavi_r's avatar
    pallavi_r
    1 year ago

    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

4 Replies

  • pallavi_r's avatar
    pallavi_r
    Super User
    1 year ago

    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

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    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's avatar
      v-achippa
      Community Support
      1 year ago

      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

  • v-kathullac's avatar
    v-kathullac
    Community Support
    1 year ago

    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