Hi, I'm trying to publish a report, my connection is with crm online, I'm trying to connect by an oData conection, when I refresh in power BI desktop It works correctly but in app.power bi. com i get the following error: I have 5 tables and the error is in the last line of this code: let Source = OData.Feed("https://XXXXX.api.crm4.dynamics.com/api/data/v8.1/"), invoices_table = Source{[Name="invoices",Signature="table"]}[Data], #"Removed Other Columns" = Table.SelectColumns(invoices_table,{"prioritycode", "mks_totalamount", "mks_discountpercentageamount", "shippingmethodcode", "mks_totaltax_base", "mks_paymentmeans", "mks_invoicedate", "mks_ratetaxeswithheld", "totallineitemamount", "modifiedon", "_accountid_value", "mks_invoicetype", "mks_includeattachment", "_transactioncurrencyid_value", "mks_signfacturae", "mks_paymentonaccount", "mks_invoicenumber", "mks_withholdingamount", "mks_totalamount_base", "mks_dateofpaymentonaccount", "duedate", "mks_collectiondate", "mks_equivalencesurchargerate", "_customerid_value", "_opportunityid_value", "_mks_invoicecontactid_value", "name", "createdon", "discountamount", "discountpercentage", "paymenttermscode", "mks_invoicetotal", "invoicenumber", "mks_totalamountpretax", "statecode", "_ownerid_value", "mks_finalinvoicetotal", "mks_costcenter", "mks_invoicenotes", "description", "mks_customerordernumber", "_pricelevelid_value", "mks_notifypendinginvoices", "_contactid_value", "mks_totaltax", "overriddencreatedon", "mks_totaldiscounts", "totaldiscountamount", "mks_invoiceclass", "mks_withholdingrate", "_mks_paymentconditionid_value", "mks_totaloutstandingamount", "mks_initialperiod", "mks_invoicelanguage", "mks_totaltaxeswithheld", "statuscode", "invoiceid", "mks_endperiod", "datedelivered", "totalamount", "ispricelocked", "_salesorderid_value", "mks_bifinal", "owninguser", "ownerid", "mks_ConfigurationFacturaE"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"mks_totaldiscounts", "TotalDiscounts"}, {"mks_invoicenumber", "Nº Factura"}, {"discountamount", "Invoice Discount"}}), #"Merged Queries" = Table.NestedJoin(#"Renamed Columns",{"invoiceid"},invoicedetails,{"invoiceid.invoiceid"},"NewColumn",JoinKind.LeftOuter), #"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"priceperunit", "extendedamount", "manualdiscountamount", "mks_amountpretax"}, {"NewColumn.priceperunit", "NewColumn.extendedamount", "NewColumn.manualdiscountamount", "NewColumn.mks_amountpretax"}) in #"Expanded NewColumn" If I delete this latest line I can refresh it in app.powerbi.com, but when I include it I can not refresh any idea? thanks so much!! 🙂
... View more