Odoo: DataSource.Error: OData: Cannot convert the literal ‘2023-08-30 12:54:22’ to the expected type ‘Edm.DateTimeOffset’

Vragen
, ,
1

Onderstaande foutmelding in Query Editor

DataSource.Error: OData: Cannot convert the literal ‘2023-08-30 12:54:22’ to the expected type ‘Edm.DateTimeOffset’.
Details:
DataSourceKind=OData
DataSourcePath=https://bridge-online.cloud/acme-odoo/odata4/Odoo.account.invoice_report@odo

Foutmelding onstaat nadat ik een filter heb geplaats (zie hieronder):

 Table.SelectRows(#"Changed Type", each ([account_id_label] = "800100 Omzet NL handelsgoederen 1" or [account_id_label] = "800200 Omzet binnen EU handelsgoederen 1" or [account_id_label] = "800300 Omzet buiten EU handelsgoederen 1"))

Een idee hoe deze op te lossen?

2

Wat is de volledige inhoud van de query waarbij Power BI een foutmelding geeft in de advanced editor in Power Query?

3 
let
Source = OData.Feed("https://bridge-online.cloud/acme-odoo/odata4", null, [Implementation="2.0"]),
#"Filtered Rows4" = Table.SelectRows(Source, each ([Name] = "Odoo.account.invoice_report@odo")),
#"Expanded Data2" = Table.ExpandTableColumn(#"Filtered Rows4", "Data", {"__last_update", "account_id", "account_id_label", "analytic_account_id", "analytic_account_id_label", "commercial_partner_id", "commercial_partner_id_label", "company_currency_id", "company_currency_id_label", "company_id", "company_id_label", "country_id", "country_id_label", "display_name", "fiscal_position_id", "fiscal_position_id_label", "id", "invoice_date", "invoice_date_due", "invoice_user_id", "invoice_user_id_label", "journal_id", "journal_id_label", "move_id", "move_id_label", "move_type", "partner_id", "partner_id_label", "payment_state", "price_average", "price_subtotal", "product_categ_id", "product_categ_id_label", "product_id", "product_id_label", "product_uom_id", "product_uom_id_label", "quantity", "state", "team_id", "team_id_label"}, {"__last_update", "account_id", "account_id_label", "analytic_account_id", "analytic_account_id_label", "commercial_partner_id", "commercial_partner_id_label", "company_currency_id", "company_currency_id_label", "company_id", "company_id_label", "country_id", "country_id_label", "display_name", "fiscal_position_id", "fiscal_position_id_label", "id", "invoice_date", "invoice_date_due", "invoice_user_id", "invoice_user_id_label", "journal_id", "journal_id_label", "move_id", "move_id_label", "move_type", "partner_id", "partner_id_label", "payment_state", "price_average", "price_subtotal", "product_categ_id", "product_categ_id_label", "product_id", "product_id_label", "product_uom_id", "product_uom_id_label", "quantity", "state", "team_id", "team_id_label"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Data2",{{"__last_update", type date}, {"invoice_date", type date}, {"price_average", type number}, {"price_subtotal", type number}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([account_id_label] = "800100 Omzet NL handelsgoederen 1" or [account_id_label] = "800200 Omzet binnen EU handelsgoederen 1" or [account_id_label] = "800300 Omzet buiten EU handelsgoederen 1")),
#"Changed Type2" = Table.TransformColumnTypes(#"Filtered Rows",{{"id", Int64.Type}, {"move_id", Int64.Type}}),
#"Removed Duplicates" = Table.Distinct(#"Changed Type2", {"move_id_label", "id", "invoice_date"}),
#"Removed Other Columns" = Table.SelectColumns(#"Removed Duplicates",{"Name", "account_id", "account_id_label", "commercial_partner_id", "commercial_partner_id_label", "id", "invoice_date", "invoice_user_id_label", "journal_id", "journal_id_label", "move_id_label", "partner_id_label", "price_subtotal", "product_categ_id_label", "state"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Other Columns",{{"id", type text}})
in
#"Changed Type1"
4

Kunt u een voorbeeld van het gedefinieerde rapport toevoegen?

Alternatief is de uitvoer van de onderstaande query in de UniversalSQL-editor:

select *
from   invoice_report@odo
5

Deze vraag is automatisch gesloten na 1 week inactiviteit. Het laatste gegeven antwoord is gemarkeerd als oplossing.

Gelieve een nieuwe vraag te stellen via een apart topic als het probleem opnieuw optreedt. Gelieve in de nieuwe vraag een link naar dit topic op te nemen door de URL er van in de tekst te plakken.

6

Dit topic is 7 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.