Hi,
While using Power Query on a table in excel to unpivot columns, i get this error when Close & Load to option is clicked on. error.JPG
"Initialization of Data Source Failed" As i am using a table in the same workbook but it wants to establish a link to external DB.
Please help me how to resolve/overcome this issue. Thanks !
any example excel file?
Attach the file here, please. Some members are unable or unwilling to access file-sharing sites.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Re: Power Query Issue
I tried to replicate "yours" error but no success
here is:
ALIGW, I Tried, but the attachment tool is not working, its not showing the upload options/menu.
To attach an Excel file to your post,
- click Go Advanced,
- scroll down until you see Manage Attachments,
- click that and select Browse,
- select your file and click Open,
- click Upload and you will see your attachment below Upload Files from a website
- click Close this window,
- click Submit reply
After that you should see attachment in your post
see post#5
Sandy, thanks for the solution, actually i dont want the solution. i need to understand whats the error in my excel/DB and how to to fix/resolve it.Originally Posted by sandy666
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Done. Here is the exemplary file. This is the error i get for any Power Query task. Need to understand and resolve this error for good.
error.JPG
Not seeing the error here in Excel 2016. What exactly are you doing when the error message appears?
I know but I cant recreate problem
I deleted query table, deleted query and did again from table, unpivot, load to - it works (on your file)
Sometimes MS is weird
Could you create the same from the same source table but delete query table and query first and let me know what will happen?
or try reinstall PQ for Ex2010 (maybe it will help)
EDIT:
If you open my file you see the same error or everything is ok?
or
create the same on brand new excel file - if it will show error like from post#1 - my advice - reinstall PQ
Last edited by sandy666; 12-27-2017 at 03:22 AM.
I am using Excel 2016 as well. I get this error at the end of the activity i.e. create data, convert it into a table, go to data tab > new Query > from table, now Unpivot the 12 MOnths columns, as in the end when i press teh Close & Load to option it gives this error.
I have used this table on other systems and this process works fine. I am unable to overcome this issue, kindly help in resolving, thanks !
this file works fine and delivers a quality DB after PQ operation on others' systems. I get this error on my machine only.I know but I cant recreate problem
I deleted query table, deleted query and did again from table, unpivot, load to - it works (on your file)
Sometimes MS is weird
Could you create the same from the same source table but delete query table and query first and let me know what will happen?
or try reinstall PQ for Ex2010 (maybe it will help)
EDIT:
If you open my file you see the same error or everything is ok?
All Ok with your file, because its the end result/final product.
or
create the same on brand new excel file - if it will show error like from post#1 - my advice - reinstall PQ
I am on Office 2016, it doesnt allow modification and reinstallation of any sorts
Last edited by TheDtox; 12-27-2017 at 03:48 AM.
so...
1st. update your profile about excel version
2nd. as you can see this is not a problem of PQ but Office installation [32/64 bit? maybe win is 32 but office 64 or vice versa? too many questions) (suggested reinstallation or Repair via CP - Program and features)
doo you have any other conections eg. like this?
connections.jpg
Last edited by sandy666; 12-27-2017 at 04:08 AM.
NO external connection as i am creating a query and loading it in the same workbook's different sheets.
Look at the screen in this vid as well for the activity.
http://www.mediafire.com/file/q1xrf7...227_121802.mp4
Last edited by TheDtox; 12-27-2017 at 04:22 AM.
and you've the same message all the time? even on brand new workbook? Weird
I give up but suggest to use Repair Office installation
Yes i am getting the same error for all PQ activities on different files on my same system which run perfectly fine on other systems. Thinking of reinstalling the OS and MS packages altogether if there comes up no solution.
maybe someone wiser will give you a solution but in this case - not me, sorry
have a nice day
edit ()
did you try from table then load to (as connection) then from Workbook Queries right click and again Load to..., Table, etc. ... but doing nothing else - only clean, the same, table?
Last edited by sandy666; 12-27-2017 at 04:39 AM.
Yes, tried it as well, didnt work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks