Initialization of the data source failed RRS feed

  • Question

  • Hello.

    I have a problem with refreshing appended table in Excel 2016.

    I used power query to create a appended table with tables within the workbook in Office 365 excel and everything worked fine. However, when I switched to Excel 2016 and tried to refresh the appended table, I got an error saying

    Initialization of the data source failed.

    Check the database server or contact your database administrator. Make sure the external database is available, and try the operation again. If you see this message again, create a new data source to connect to the database.

    I tried to open a new workbook, create new tables and append them together. The data appended correctly in the preview window, but when I load it, the error box appears and the data are not loaded totally onto the worksheet.

    I also tried to uninstall power query but I couldn't figure out how.

    Can someone help me with this? Thank you so much

    Friday, August 3, 2018 3:52 PM


All replies