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

Web Services

(1) Share

Report

Posted on by LiamSc

Hello

We have just updated to 24.0 and one of our PowerBI reports have stopped working with the error below.

Data source errorExpression.Error: The key didn't match any rows in the table.. Key = [Name = /Vendor_Card_26/, Signature = /table/]. Table = #table({/Name/, /Data/, /Signature/}, {}). ;The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface. Table: Vendor_Card_26.

The page is still live on the web services but even when you try to connect a new PowerBI report it doesn't show in the list as selectable data.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

I am not sure if this change may be changing. Please check it.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/deprecated-features-platform?wt.mc_id=MVP_354389#schemaversion

https://www.kauffmann.nl/2020/12/10/business-central-api-v2-0/

BR

GR

Was this reply helpful? Yes No
Netjacker2097 286 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Your using a page for your OData, might be worth removing and republishing the same table under the same name. Worth a try.

alternatively, write a query for the same field you need from the page. You can publish on the web services then to achieve the same result for your report.

regards,

M

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report
Copy link

Link copied!

It does seem to be related to Schema version. Erik discussed this yesterday and hopes to give you some tips.

https://www.youtube.com/watch?v=600q1uTMIuk

Thanks.

ZHU

Was this reply helpful? Yes No
Aaron Bauldree 19 on at

Like (1)

Report
Copy link

Link copied!

Yun Zhu is correct. The quick summary of Eric's email is to append your API calls with the following:

$schemaversion=1.0

Eric's video will explain what is happening and why

Was this reply helpful? Yes No
LiamSc 21 on at

Like (0)

Report
Copy link

Link copied!

We have never written a query before. Is there a guide to how to do this easily?

I retried adding the page to webservices but none of the 4 that i screenshot show up. The VC26 line was created after updating to 24.0

Was this reply helpful? Yes No
frivadulla 4 on at

Like (0)

Report
Copy link

Link copied!

Anyone was able to call APIs on powerbi with schemaversion=1.0?

Was this reply helpful? Yes No