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...
Some more information:
- From GitHub (pavaolm) suggests it's a removed template variable causing the problem and suggests downloading a new template. This seems to be the same template as describe when Clear Permissions. This didn't work for me.
- Uninstall (completely) install latest version from Microsoft Store. This didn't work for me.
- Uninstall (completely) install version v2.82.5858.1161 64-bit (June 2020) or is it 2.82.5858.301? This didn't work for me. Version: 2.92.943.0 64-bit (April 2021) is offered irrespective of what you ask. It appears that you cannot download previous versions. Microsoft does state "You can also download previous versions of Power BI Desktop if your organization requires it." Previous versions are not serviced, but what do you do if the current version doesn't work? They seem to only offer the March 2021 versions as "previous versions"
- Important links every PowerBI enthusiast should bookmark.
- Version: 2.91.884.0 64-bit (March 2021) - Requested value '()1' was not found.
- Tried installing the older version via Chocolatery.org via PowerShell> choco install powerbi --version=2.82.5858.1161. Ran into error "is not recognized as the name of a cmdlet".
- Some more information on similar problems that other people reported with reference to "Can't Open Power BI after June 2020 Update"; I am running 2.92.1067.0 64-bit (April 2021) which is a much later (the latest) version of the Desktop.
- The same error message, i.e., Requested value '()1' was not found is discussed on a 2019 thread on this site that does not provide a resolution other than a potential SSAS problem.