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 ...
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?
I downloaded an Excel from the internet with several formulas and connected to it without clicking Enable Editing. However, I cannot replicate your issue. That aside and from experience, Enable Editing disappears if a file is saved in OneDrive..