Forum Discussion
Importing data from EXCEL with FORMULAS
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...
v-xiaotang
Community Support
Community SupportHi Dnair
I've tested with excel from sharepoint, Calculation= automatic, but it worked OK, I mean it showed all data.
here are my testing operations. column b & c are calculated column in excel.
result, column b & c are loaded in power BI:
if problem still persists, could you add your operation screenshots? so we can work on it further.
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Yes, I will add screenshot once I am able to mask it in a day or so. Thanks.