error refreshing data: Unable to read data from the transport connection: An existing connection wa
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!! :)
10 Comments
- sandragocj27Frequent Visitor
sorry , this is the error I get:
- xdoomxFrequent Visitor
I get a similar error when importing data from Zendesk.
- v-qiuyu-msft
Community Support
sandragocj27 Would you please translate the error message to English? I have tested about Dynamics CRM Sales app with merged queries and expanded columns steps, refresh works fine after publish to service. Please try to update the desktop version (2.45.4704.442) to the same version as ours then republish the report to see if refresh works.
xdoomx It should be different scenario. Please create a new thread in Issues forum.
Best Regards,
Qiuyun Yu - Vicky_Song
Impactful Individual
Status changed:NewtoNeeds Info - xdoomxFrequent Visitor
v-qiuyu-msft Have done so, thanks!
- sandragocj27Frequent Visitor
I have downloaded the latest version of power bi desktop and I have the same error:
An error has happened
Try again later or contact with the technic support. Give the following details if you contact them
thanks so much!
- sandragocj27Frequent Visitor
- sandragocj27Frequent Visitor
refreshing in power bi desktop works, what doesn't works is refreshing in app.powerbi.com, after publishing it
thanks!
- xdoomxFrequent Visitor
- sandragocj27Frequent Visitor
I've tried it, but I didn't find anything...
thanks