I have a workbook with few quaries inside. i changed the scaling factor in the rows to 1000 in one of the quaries.
now when i refresh the workbook nothing changes but if i open the quary in a new workbook it changes. Is there a way to refresh the quary to show the rows new scalling factor?
Open the Workbook, goto the local query definition change the scaling factor and then execute the query in workbook.
When you save the workbook the KF settings at that time will also be saved along with the workbook any changes done to the global query will not be affected to the workbook.