Forum Discussion

mbabla's avatar
mbabla
Frequent Visitor
8 years ago
Solved

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

Hi,    Thanks for reading my post, and I appreciate any helpful advice you can offer.   In using Power Query in Excel to get Data from Web - the default mode seems to be to Load the Result as a T...
Need Help
  • edhans's avatar
    edhans
    8 years ago

    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.

edhans's avatar
edhans
Community Champion
8 years ago

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.

mbabla's avatar
mbabla
Frequent Visitor
8 years ago

 Hi edhans,

 

I will take your suggestion and move it to the Excel Power Query Forums.

 

Best,

 

mb