It does not matter what data connector, when [Apply] is clicked it results in Requested value '()1' was not found. The Power Query (in the editor) connected to the data source, e.g. Google Analyt...
After deliberation with Microsoft support, the investigation could not proffer the cause of the Requested value '()1' was not found. However, the problem is environmentally constrained to the laptop. What exactly is still a mystery.
An installation of PowerBI on another PC functioned as expected.