Forum Discussion
Unable to use Get Data in Power BI Desktop
No matter what source I choose (Excel, Access or SQL Server), I am able to see the data in the Navigator window when I choose the source and select the sheet/table, but every time I click the Load button I get the following error:
Failed to save modifications to the server. Error returned: 'An external component returned an error (HRESULT = ). '.
I have uninstalled/reinstalled the 64-bit version of Power BI Desktop and am using the 64-bit version of Office 365 in a Windows 10 environment.
Power BI Desktop version 2.79.5768.663 64-bit (March 2020)
Windows 10 Pro Version 1903 OS build 18362.719
Anonymous Hopefully this helps you: I was using the MS Store version of Power BI Desktop. I uninstalled it and re-installed the one you can download here and it's working: https://www.microsoft.com/en-us/download/details.aspx?id=58494
11 Replies
No matter what source I choose (Excel, Access or SQL Server), I am able to see the data in the Navigator window when I choose the source and select the sheet/table, but every time I click the Load button I get the following error:
Failed to save modifications to the server. Error returned: 'An external component returned an error (HRESULT = ). '.
I have uninstalled/reinstalled the 64-bit version of Power BI Desktop and am using the 64-bit version of Office 365 in a Windows 10 environment.
I would appreciate any assistance in getting this resolved.
- mwegener
Most Valuable Professional
Hi Anonymous ,
maybe a virus scanner is blocking the writing process?
- Greg_Deckler
Community Champion
Yeah, if this is in the Desktop, that is odd behavior.
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".I'm running into the same issue: "Failed to save modifications to the server. Error returned: 'An external component returned an error (HRESULT = ). '."
I do not see this exact issue listed on the issues page. Unable to do my work because of this at the moment 😥.
Power BI version = 2.79.5768.663 64-bit (March 2020)
Windows 10 Pro 1909, build 18363.720, 64-bit
- edhans
You've done just about all of the troubleshooting you can with the uninstall. I assume you did the uninstall/reboot/reinstall? Sometimes the Reboot is key.
Next step is open a support ticket. See link at bottom of this page.
Anonymous Hopefully this helps you: I was using the MS Store version of Power BI Desktop. I uninstalled it and re-installed the one you can download here and it's working: https://www.microsoft.com/en-us/download/details.aspx?id=58494
