Forum Discussion
Excel Web- Lost Power Query Button
Last week, I had a Power Query button in Excel web. It worked great. I created my Query and such. I connected to the Dataverse. Today, I open Excel Web and the button is missing in the Data tab. Not ...
You may try at the following:
- Use the OData Connector as a Workaround
You can connect to Dataverse using the OData feed:
- Go to Data > Get Data > From OData Feed
- Use the URL: https://<your-environment>.crm.dynamics.com/api/data/v9.1
- Authenticate with your Organizational Account
Note: You may need to manually handle lookup and choice columns.
- Clear Cached Credentials
- Go to Data > Data Source Settings
- Select your Dataverse URL and click Clear Permissions
- Try reconnecting with the correct account
- Roll Back Office Update
- Open Excel > File > Account > Update Options > Disable Updates
- Run Command Prompt as Admin and use:
- cd %programfiles%\Common Files\Microsoft Shared\ClickToRun
- officec2rclient.exe /update user updatetoversion=16.0.xxxxx.xxxxx
(Replace with a known stable version)