Excel Import Data imports null values

[Dnair]

Hello All,

I have a very unique problem importing few of the excel sheets from a sharepoint site. The formulas in the excel gives values in Sheet1 of the Workbook which I will use in PowerBI. Now these values appear as null. If I keep the Calculations to Manual they appear. If not, they don't. Please can someone help me to figure a way around this problem.

Thanks,

Deepa

[v-chuncz-msft]

@Dnair 

I tried the latest version to import excel from a sharepoint site and it seems to be working fine. 

[Dnair]

I am using latest version only.