Forum Discussion
Power Query - Load Data without saving Queries or Connections, and NOT as a Table in Excel
No, as when it creates a table, it is a live refresh.
You can disable the automatic refresh of the table. Go to the Data tab when the table is selected, click the dropdown to REFRESH ALL, click connection properties, then uncheck "refresh this connection on refresh all."
You'll have to right-click on that table to refresh going forward.
I think for further discussion, you should move this to the Excel Power Query forums as there is nothing analagous to how Excel works with flat tables in Power BI. It is all about data models here.
Hi edhans,
Thanks for your thoughtful responses to my questions.
Your response, "you cannot have Power Query paste the data as text." answers the crux of my question. However, is there a setting to not have it save the Query and/or connection, but just download the data one-time, else in my current workflow, I have to manually remove them every time.
Best,
mb
No, as when it creates a table, it is a live refresh.
You can disable the automatic refresh of the table. Go to the Data tab when the table is selected, click the dropdown to REFRESH ALL, click connection properties, then uncheck "refresh this connection on refresh all."
You'll have to right-click on that table to refresh going forward.
I think for further discussion, you should move this to the Excel Power Query forums as there is nothing analagous to how Excel works with flat tables in Power BI. It is all about data models here.
Hi edhans,
I will take your suggestion and move it to the Excel Power Query Forums.
Best,
mb