error refreshing data: Unable to read data from the transport connection: An existing connection wa

[sandragocj27]

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!! 🙂

[sandragocj27]

sorry , this is the error I get:

[xdoomx]

I get a similar error when importing data from Zendesk.

[v-qiuyu-msft]

@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

[xdoomx]

@v-qiuyu-msft Have done so, thanks!

[sandragocj27]

 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!

[sandragocj27]

[sandragocj27]

refreshing in power bi desktop works, what doesn't works is refreshing in app.powerbi.com, after publishing it

thanks!

[xdoomx]

@sandragocj27 Try doing a Fiddler Trace then:

https://www.youtube.com/watch?v=8Fs3CVAw9lk

[sandragocj27]

I've tried it, but I didn't find anything...

thanks