Forum Discussion

WLou's avatar
WLou
Helper I
4 years ago
Solved

Refresh error when other people using the file

Hi all,    Still new with power query, usually I use them for my own purposes, never send it to other people    This time i'm trying to share; it is a very simple query with all the data source n...
Need Help
  • jennratten's avatar
    jennratten
    4 years ago

    I recommend checking the data source settings in the file to make sure all are correct and have the appropriate permissions assigned and also clearing the Power Query cache.  Those are two steps that are good to start with and see if they fix the problem.

     

    Data Source Settings in Excel/Power Query:

    The cache can be cleared from Query Options:

     

     

PC2790's avatar
PC2790
Community Champion
4 years ago

Hello WLou 

 

How are the other people attempting to refresh your file?

Do they have access to the required sources?

 

Thanks

WLou's avatar
WLou
Helper I
4 years ago

Hi PC2790 

 

Thanks for the reply, it is only when other people refresh the file giving them the error. 

As I don't know how to store sources, I managed to have all the source within that file 

Is there any recommondation about data management? I would LOVE to have other people to self serve

(some key words that I can google and do some self study)

 

Regards,

Wendy