Excel 2010 Power Query addin - connection only - unable to load

[pgcn01]

Hi all - newbie to PQ here. I searched forum / google but couldn't find anything.

I created a calendar table in a blank query & clicked "close & load" several times but it just continues to show "connection only".

Any advice welcome on how to get this query to load so that I can set relationship.

cheers
Peta

 

[justmeok]

Hi Peta,

In workbook view show query from the data tab. Right mouse click on the query and then from the drop down menu choose "load to" and you'll get a popup window asking where you would like to load to. Choose whichever option you want.

Hope I have understood your post?

 

[RoryA]

Why do you need to change the Load To? You can link connection only queries to other queries.

 

[pgcn01]

Hi Peta,

In workbook view show query from the data tab. Right mouse click on the query and then from the drop down menu choose "load to" and you'll get a popup window asking where you would like to load to. Choose whichever option you want.

Hope I have understood your post?

Hi justmeok

Thanks for the reply & yes you understood me correctly & that has worked. (I thought those options looked like they were greyed out ha ha)

 

[justmeok]

Hi justmeok

Thanks for the reply & yes you understood me correctly & that has worked. (I thought those options looked like they were greyed out ha ha)

Glad I could help