Forum Discussion
Suppress refresh in Power Query when not necessary
So I have this situation, please see code snippet below: ODBC query pulling 6M rows into Power Query raw_data table, about 5 mins (once pulled in, I don't need to refresh ODBC data to conduct analy...
Hey there. If you are using Excel for this, you could load the table to a pivot table, then change the measure or columns in the pivot table into formulas using the OLAP options in the Analyze ribbon. Then, you could just type your parameter in any blank cell, and then a formula like = PivotCellName * ParameterCell. Change the parameters as you like, the data model is already loaded!