Forum Discussion
Helper IIChange Source is grayed for Power BI dataflow
Hi Nazdac911 ,
When the option button [Change Source ...] is disabled, which forces us to change manually within the Power Query Advanced Editor.If we start a query creating a variable instead of starting with the connection to the Data Source, the option to change the Data Source in the simple way you saw at the beginning of this article will be automatically disabled.We need to create these variables in a separate query, so we can use these variables in any other Query and at any step of it, but not in the first.
The following article tells similar question ,pls refer it and check if it is helpful:
Best Regards
Lucien
Community SupportHi Nazdac911 ,
When the option button [Change Source ...] is disabled, which forces us to change manually within the Power Query Advanced Editor.If we start a query creating a variable instead of starting with the connection to the Data Source, the option to change the Data Source in the simple way you saw at the beginning of this article will be automatically disabled.We need to create these variables in a separate query, so we can use these variables in any other Query and at any step of it, but not in the first.
The following article tells similar question ,pls refer it and check if it is helpful:
Best Regards
Lucien