Small and medium business | Business Central, N...

Error Loading Metadata when export excel to edit - cloud business central

(0) Share

Report

Posted on by Community Member

I am using could business central, when i choose edit excel from any list page, the following error occurred.

I did install Jet Report and there is no issue for the JET connect to cloud business central.

Kindly help. thank you in advance.

I have the same question (1)

All responses (5)

Answers (0)

Sort by

Suggested answer

MahGah 15,597 on at

Like (1)

Report
Copy link

Link copied!

Hi

A few places to check

1) Make sure you have all of the following permission set in BC

2) Check this blog post and follow the steps https://olisterr.blogspot.com/2022/02/how-to-resolve-edit-in-excel-issues.html

3) Does your company has any security policy that prevent such an action (in server side or office side)?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi MahGah,

Many thanks for your response.

In my user permission sets, I got the Super, Edit in Excel - view and Export Report Excel. I tried as per you suggestion insert the other two which are Edit in excel - Admin & Excel Export Action.

Even though after inserted the two permissions set, the same error occurred.

Also, I do tried connect using Excel OData Connector as per one of the suggestion in olisterr blogspot. It show error unable to connect.

Was this reply helpful? Yes No
Suggested answer

MahGah 15,597 on at

Like (0)

Report
Copy link

Link copied!

Hi

Since you cannot connect ODATA from your Excel it means something blocking your ODATA access which is the same concept as Edit in Excel (Edit in Excel publish the page as ODATA and then consume).

Can you check and see if any other users have the similar issue?

Olister Rumao can you provide any help here?

Thanks

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,689 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, this looks like an authentication issue. Please try logging in again in the Add-in and try again.

Note: It must be same account.

In addition, if your organization account and BC account are different, you can try it directly with Excel Online in InPriavte/Incognite in the browser.

Hope this info helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Olister Rumao 4,009 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please confirm the following

1. Authentication for ODATA - You might need OAuth authentication to connect to BC ODATA.

2. Confirm that ODATA service you a looking for is enabled. Generally on BC Cloud the ODATA Service is enabled. But feel free to restart BC Environment from Admin Center.

3. Confirm the permission sets for the Webservice object you are trying to access.

Thanks.

Was this reply helpful? Yes No