PBI not loading some Excel columns
Hi all. I have a problem when loadin an Excel file into PBI, where all Excel sheets are correctly loaded except the ones that have formulas refering to other sheets. As you can see in this image, I have some data about some trades done, and some of this columns are formulas refering to other sheets while others have formulas using data from this sheet The problem is, when loading it to PBI, all this columns with data formulas refering to other sheets do not load correctly (as you can see in the image below). This is same error is happening in 2 different sheets. I have tried different possible solutions such as copying the data by value so I do not have formulas, but still the same.
