Forum Discussion

Dnair's avatar
Dnair
Frequent Visitor
5 years ago

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 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

Need Help

8 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    5 years ago

    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's avatar
      Dnair
      Frequent Visitor
      5 years ago

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

  • Dnair's avatar
    Dnair
    Frequent Visitor
    5 years ago

    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's avatar
      v-xiaotang
      Icon for Community Support rankCommunity Support
      5 years ago

      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.

  • Dnair's avatar
    Dnair
    Frequent Visitor
    5 years ago

    Is there any solution to this horrible problem

  • Dnair's avatar
    Dnair
    Frequent Visitor
    5 years ago

    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's avatar
    Dnair
    Frequent Visitor
    5 years ago

    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.