Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
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.
Can some one reply please
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?
Is there any solution to this horrible problem
Hi,
I can not get the screenshot but the problem happens when it is connected and processed by Adobe connector report builder in excel.
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.
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.
Yes, I will add screenshot once I am able to mask it in a day or so. Thanks.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
105 | |
105 | |
88 | |
61 |
User | Count |
---|---|
165 | |
133 | |
132 | |
95 | |
86 |