Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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 🙂
Thanks
Z
Hi,
I don't think that is possible. You can either Create a Connection or Load data to the worksheet.
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 🙂
Thanks
Z
Hi @zibster,
Can you explain more details, please?
What is "a table on a sheet"?
What will "connection only queries" do?
Best Regards,
Dale
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.
Thanks
Z
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.
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |