Importing data from EXCEL with FORMULAS

[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

@members

[Dnair]

DataSource.NotFound: Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.

[Dnair]

Can some one reply please

[Dnair]

The above solution did not help. I want to know if I have a 32 bit Power BI desktop, will I have problem publishing it in 64 bit Office 365 which hosted the Power BI service?

[Dnair]

Is there any solution to this horrible problem

[Dnair]

Hi,

I can not get the screenshot but the problem happens when it is connected and processed by Adobe connector report builder in excel.

[v-xiaotang]

Hi @Dnair 

thank you for your reply. 

I would like to help you, but I have no idea how to test it without your operation captures after removing sensitive information. and I also searched on the Internet, but didn't find any similar problems. 

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.

[v-xiaotang]

Hi @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.

[Dnair]

Yes, I will add screenshot once I am able to mask it in a day or so. Thanks.