Forum Discussion
Columns missing from data file in power query
Thanks what is strange is that if i link direct to the data it misses the column. But if i open the data file and close without making any changes at all and then go into power query (both Excel & BI) it actually works. I assume it has something to do with the query/connection properties (in the source data file) so was wondering if i can change the connection/query properties to pick up the extended range ?
Is it actually possible to change query properties direct ? as you see here it goes to "G744" when in fact i want it to go to H744.
I have replicated the issue in Excel power query and get the same issue as in power BI so its not really an excel issue i think.
cheers
As far as i know it's not possible to input a custom range in the connector to the actual object. I suggest contacting microsoft support, maybe they can see something but sadly i cannot help you out with this. I don't see anything thats going wrong from your end, especially if the problem exists in excel and pbi.