Power Query - Load Data without saving Queries or Connections, and NOT as a Table in Excel

---

mbabla wrote:

Hi,

 

 Thanks for reading my post, and I appreciate any helpful advice you can offer.

 

 Also, I am doing many Power Query requests per row, and there are hundreds of rows, so I do not want the data pasted as a Table either, but rather as text. This is important as with hundreds of these tables, and with Connections and Queries in the sheet, even my quite Fast PC w/ 64-bit excel and 32GB RAM gets very slow and almost unusable after a few hundred requests that are all saved as Queries, Connections, and are pasted into the sheet as individual tables.

 

Is there a way to do that -

1> Have Power Query paste the result as text in the cells, NOT grouped into a table

2> disable power query from saving the query

3> disable power query from saving the connection

  

---

You'd need to post some sample data of how you are using it. It doesn't seem you are using it correctly by using a unique query for every row of data. But to directly answer some of your questions:

• You cannot have Power Query paste the data as text. it connects via a table, or you can put into the Excel data model for Power Pivot. This is what the Power BI Desktop app does when it loads, for use by the data model for DAX measures and visuals.
• You can have it just do the query but not load. That means Excel/Power BI Desktop can process and show you the query results in the Power QUery editor, but not do anything with it.
• You can technically not save the connection by closing the window and discarding changes, but again, I don't understand how that would be a normal workflow and would need to understand more about what you are doing.