Excel - Getting PowerB DataSets "An error occurred when trying to fetchlist of datasets" - E

Looks like this issue is the same as mine
 https://community.powerbi.com/t5/Issues/Pivot-Table-connected-to-Power-BI-Datasets/idi-p/2459258

I am getting the same issue. 

Hi asjones ,

The taskbar in excel needs to load some files from the user's computer,

and these files (%localappdata%MicrosoftOffice\SolutionPackages) are not available on the user's machine. According to the discussion these files do not exist on the user's machine.

Please uninstall and reinstall Microsoft excel, then try again.Check if the problem still exists.

Best Regards,
Community Support Team _ Caitlyn

What online discussion?
To ensure things were good on my computer I did the following

sfc /scannow

Dism /Online /Cleanup-Image /CheckHealth

Dism /Online /Cleanup-Image /ScanHealth

Dism /Online /Cleanup-Image /RestoreHealth

Then I did an MS Office 365 Online repair (full rapair). That shoujld have taken the place of reinstalling office.

Also see this other discussion as it has starrted happenign to several perople
https://community.powerbi.com/t5/Issues/Pivot-Table-connected-to-Power-BI-Datasets/idc-p/2461071

asjones did your steps mentioned above fix the issue?

CAS-TomSorry I didn ot make that clear. I tired all that and nothing fixed the issue.

asjones Got it, thanks for your prompt reply.

It seems to me that the issue pertains to Fetching a list of datasets only.

If you have an existing file that's already linked to a dataset, you should be OK.

This problem is similar to going to a restaurant with no menu. If you are a regular customer and know what you want to order, you can still place the order. However, you won't be able to know what the restaurant's offerings are.

CAS-Tom.... in my case I first found the issue when I tried to refresh and existing datat set and relized nothing had changed. I didn ot get the error, but my data set did not update.

I just tested this with my account in Citrix hosted VM and also get there error there.