Forum Discussion
DataSource Error when connecting to Dataverse from Excel
Hi,
I'm trying to connect to Dataverse tables from Excel via Get Data > From Power Platform > From Dataverse. I was able to sign in and access my environments. However, as I tried to expand the environment folder to access the tables, I got the following error: "The parameterized query expects '@tds_client_correlation_id', which is not supplied."
In Power BI, I followed the same steps using the same credentials and it worked just fine.
This is particularly odd because it was working well as of a few days ago (I even wrote a VBA script to automate data streaming and processing).
Would appreciate your help!
7 Replies
Same Error! Microsoft® Excel® for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20336) 32-bit
Hello!
Any update here? The Office was just updated in the company's laptop and now I'm facing the same issue with version 2408. It can't be reverted due to security policies.
See if you can update to a newer version. I'm on Version 2411 and this issue has gone away. Good luck!
- Check if you've recently had a Microsoft Office update to Version 2408. We found reverting to Version 2407 (or earlier) resolved the issue.
Hi, I tried to revert to Version 2407 following https://support.microsoft.com/en-us/topic/how-to-revert-to-an-earlier-version-of-office-2bd5c457-a917-d57e-35a1-f709e3dda841 but I keep getting this error message:
What steps did you follow to go back to an earlier version? Thank you!
My config.xml - 17830.20138 is Version 2407 Release notes for Current Channel releases - Office release notes | Microsoft Learn
<Configuration>
<Updates Enabled="TRUE" TargetVersion="16.0.17830.20138" />
</Configuration>
