Forum Discussion

steveorme69's avatar
steveorme69
Helper I
8 years ago
Solved

Refresh not working

Hi

 

Everytime I try to refresh my data I get the message "file in use" which then stops all the other queries refreshing.

 

The tabes are mainly from Access and I know for sure that the tables are not open, when I close the refresh and try it again it can change the reference to which table is already in use.

 

https://1drv.ms/u/s!An_LprApKikkfosRziRTKNGBXEM

 

Thanks

Steve

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    steveorme69,

    Unselect the "Enable parallel loading of tables" option in your PBIX file, then check if you can refresh data successfully.


    Regards,
    Lydia

  • steveorme69's avatar
    steveorme69
    8 years ago

    That's worked

     

    Thank you so much Lydia, you're a star !

     

    Regards

    Steve

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    steveorme69,

    Unselect the "Enable parallel loading of tables" option in your PBIX file, then check if you can refresh data successfully.


    Regards,
    Lydia

    • steveorme69's avatar
      steveorme69
      Helper I
      8 years ago

      That's worked

       

      Thank you so much Lydia, you're a star !

       

      Regards

      Steve