sandragocj27's avatar
sandragocj27
Frequent Visitor
9 years ago
Status:
Needs Info

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

  • xdoomx's avatar
    xdoomx
    Frequent Visitor

    I get a similar error when importing data from Zendesk.

     

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity 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

     

  • sandragocj27's avatar
    sandragocj27
    Frequent 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!

     

     

  • sandragocj27's avatar
    sandragocj27
    Frequent Visitor

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

    thanks!