cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Import Data imports null values

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

Status: New
Comments
v-chuncz-msft
Community Support

@Dnair 

 

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

 

Dnair
Frequent Visitor

I am using latest version only.