DataSource Error when connecting to Dataverse from Excel

Question

Hi,
&nbsp;
I'm trying to connect to Dataverse tables from Excel via Get Data &gt; From Power Platform &gt; 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."
&nbsp;
In Power BI, I followed the same steps using the same credentials and it worked just fine.&nbsp;
&nbsp;
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).
&nbsp;
Would appreciate your help!

&nbsp;

emilym0 · Answer

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

yhao785 · Answer

EmilyM0&nbsp;
&nbsp;
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!

yhao785 · Answer

My config.xml - 17830.20138 is Version 2407 https://learn.microsoft.com/en-us/officeupdates/current-channel?redirectSourcePath=%252farticle%252f95c8d81d-08ba-42c1-914f-bca4603e1426#version-2407-august-01

<Configuration>
<Updates Enabled="TRUE" TargetVersion="16.0.17830.20138" />
</Configuration>

leandrorosendo · Answer

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.&nbsp;

yhao785 · Answer

See if you can update to a newer version. I'm on Version 2411 and this issue has gone away. Good luck!

Forum Discussion

DataSource Error when connecting to Dataverse from Excel

7 Replies

Resources