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 only that, but my PQ table crashes every time I try to update it.
I am not sure what is happening, but I need this functionality back.
PS. Excel desktop (macos) is missing the dataverse option too and opening the same file in desktop, tells me that OAuth is not working or something, when I try to update the table.
I am lost...
1 Reply
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)
