Forum Discussion

Javo's avatar
Javo
New Member
3 years ago

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.

 

Excel data load

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    3 years ago

    Hi Javo ,

     

    I'm not abble to replicate the error you are getting, what type of calculations are you doing in excel?

     

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.