"An error occurred while creating connection strings for the query" issue RRS feed

  • Question

  • Dear all,

    I had a final table developed by merging 6 queries into one. It worked fined until I want to  adjust one of the query, instead of extracting data from one file, I want to changed it to get data from the whole folder. All the steps were done smoothly, but when I save the query, it showed "An error occurred while creating connection strings for the query 'name of the query'".

    After that, I tried to create new query but it keep showing this error when I save the new query. 

    Please help me to solve this problem.

    Thank you so much,


    Friday, May 29, 2015 2:34 AM


All replies

  • Unfortunately this message usually means that the connections in the workbook have gotten into a bad state. Can you try recreating your queries in a new workbook to see if it resolves the issue?

    Monday, June 1, 2015 9:07 PM
  • Well,

    too bad,

    I had to reconstruct the whole model and dashboard. Something get wrong with the old model and I figured that it will cost less time to rebuild it :D

    Thank you for your help,


    Monday, June 8, 2015 10:28 AM