Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

Query references other queries or steps, so it may not directly access a data source. Please rebuild this data connection

If, when trying to refresh a PowerQuery, you may get the message ‘Query references other queries or steps, so it may not directly access a data source. Please rebuild this data connection’ and it refuses to continue. In this case it often means that a connection in the Query is looking to an external source which is often on an external network (think Dropbox, Onedrive, Hharepoint etc)

Change the Privacy Settings

To get it to work again you can try the following. Note that you may need to do this on all the computers that use the PowerQuery and redo if you reload/ change your computer.

Access the PowerQuery windows. Below one way to do it by right clicking on any one of the queries and clicking on Edit.

may not directly access a data source

Next click on ‘File’, then ‘Options and Settings’ and choose ‘Query Options’ as per below.

may not directly access a data source

Lastly on the Global part (very important unless you want to do it every time), choose ‘Privacy’ and the ‘Always ignore Privacy Level settings’. If you work in a corporate you may need to get permission from IT.

may not directly access a data source

You should then be able to close the query and when you refresh it will access the required files.

PowerQuery Online Course

Power Query close and load to greyed out

Solution to PowerQuery Create Connection Only being Greyed Out