Forum Discussion
Loading Excel With =Value into PowerBI
Hello, I have a script that is saving down a grouping of excels. Unfortunately, the cells have =Value (meaning one cell might have "=324" and another may have "=4237") and because of this when I ...
Thanks for the response, unfortunately that did not work and the values just appear as 0. Any other thoughts?
Its generally pretty simple below, not sure how to upload an excel but this should give the idea
Hi PowerBIHelp1234 ,
You screenshot doesn't show how your data is described. There is no "=4237" or something like that. You can post a link Google, OneDrive or Dropbox. You can post your M code as well.
So it appears it is more related to the fact that the files are in Protected View when saved down from the source. If I click enable edit and then save again it pulls through al the data correctly in power query. Any thoughts on how to surpass that in power query?