DataSource Error when connecting to Dataverse from Excel

[yhao785]

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!

[#2]

Check if you've recently had a Microsoft Office update to Version 2408. We found reverting to Version 2407 (or earlier) resolved the issue.

[#3]

@EmilyM0 

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-a91... but I keep getting this error message:

What steps did you follow to go back to an earlier version? Thank you!

[#4]

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>