cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Power query, how to create table from connections only

Hi, I am new to the power query, and my question is there a way to create a table on a sheet for connection only queries?

 

Thanks

Z

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper III
Helper III

Re: Power query, how to create table from connections only

Hi Ashish,

 

Thanks for your help, after some dingning i found that you can load to from current connection only by right clicking on the connection only query that has been created and select load to 🙂

Capture.JPG

 

Thanks

Z

 

View solution in original post

5 REPLIES 5
Highlighted
Microsoft
Microsoft

Re: Power query, how to create table from connections only

Hi @zibster,

 

Can you explain more details, please? 

What is "a table on a sheet"?

What will "connection only queries" do?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper III
Helper III

Re: Power query, how to create table from connections only

Hi Dale,

I have 2 Connection only query that connect to SQL databases and retrieves the data I would then I use the power query to merge the data. I would do it in SQL but these are 2 separate databases. I would like to see the merged data on a spreadsheet as but when I click close & load dropdown all the close and load to is grayed out.

 

Close And Load2.JPG

 

 

Thanks

Z

 

Highlighted
Microsoft
Microsoft

Re: Power query, how to create table from connections only

Hi @zibster,

 

I'm not familiar with Power Query in Excel. How about just clicking "Close and load"? It will load the data to a default sheet.

It seems we can only load once. We can't load to other places after the first loading. Please refer to the snapshot below.

The workaround is duplicating the query. Then you can load it to other places again.

Power_query_how_to_create_table_from_connections_only

 

Best Regards,

Dale

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User IV
Super User IV

Re: Power query, how to create table from connections only

Hi,

 

I don't think that is possible.  You can either Create a Connection or Load data to the worksheet.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted
Helper III
Helper III

Re: Power query, how to create table from connections only

Hi Ashish,

 

Thanks for your help, after some dingning i found that you can load to from current connection only by right clicking on the connection only query that has been created and select load to 🙂

Capture.JPG

 

Thanks

Z

 

View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors