Forum Discussion

WLou's avatar
WLou
Helper I
5 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
    5 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
5 years ago

Hello WLou 

 

How are the other people attempting to refresh your file?

Do they have access to the required sources?

 

Thanks

tijana_djurovic's avatar
tijana_djurovic
New Member
3 years ago

Hello PC2790 

I have the same issue, but refreshing the cache did not help.

Is there something else that I could try? My files (sources) are on Share Point. Everyone has the access to the same Share Point and nobody except me can refresh power query.

Thanks, Tijana