Forum Discussion
change query without load data from the source again
Hi simp,
As per my knowledge, any change in query editors will lead to the modification of Power Query, so, it will run the query and connect to data source again to reload data. It is not available to corrupt the data retrieval process, only to focus on the transformation query.
If you don't want to reload data again and again each time you refresh the data, you can try to select "Directquery" rather than "Import" when connect to data source. However, DirectQuery mode only applies to SQL Server Data Source.
Besides, if possible, I would suggest you first connsider to make changes (for example, change field data type) in view mode rather than in query editor, because this will not cause the Power BI to connect to data source again.
Best regards,
Yuliana Gu
Hi simp,
As per my knowledge, any change in query editors will lead to the modification of Power Query, so, it will run the query and connect to data source again to reload data. It is not available to corrupt the data retrieval process, only to focus on the transformation query.
If you don't want to reload data again and again each time you refresh the data, you can try to select "Directquery" rather than "Import" when connect to data source. However, DirectQuery mode only applies to SQL Server Data Source.
Besides, if possible, I would suggest you first connsider to make changes (for example, change field data type) in view mode rather than in query editor, because this will not cause the Power BI to connect to data source again.
Best regards,
Yuliana Gu
