Forum Discussion

Fromit87's avatar
Fromit87
Advocate I
4 years ago

Error on PBI Service dataset refresh

Hi!   My model includes datasources from Databricks (cloud), Oracle (on-prem) and SharePoint (cloud). For the Oracle data the gateway is set up and runs perfectly (in all my dataflows). All privac...
Need Help
Fromit87's avatar
Fromit87
Advocate I
4 years ago

Hi GilbertQ,

Indeed, it's weird. I setup a completly new PBI file with a new table that combines a Oracle and a Databricks source connection (created a new connection, no copy/pasting).

Refresh works fine on PBI Desktop, but on Service I get the same Error: 

"A retriable error occurred while attempting to download a result file from the cloud store but the retry limit had been exceeded."

  • GilbertQ's avatar
    GilbertQ
    Super User
    4 years ago

    Yeah that is strange it could be a setup on your gateway, do you have the cloud and on-premise data sources configured in the gateway as shown below?

     

     

    • Fromit87's avatar
      Fromit87
      Advocate I
      4 years ago

      Hi GilbertQ ,

       

      I checked with my IT department, and yes the Gateway settings have this option activated. My IT department has raised a ticket with MS. As soon as they find out the rootcause and fix. I'll post it here.

      Thank you for you time and assistance so far! Appreciated!

       

      Fromit87

  • skygold16's avatar
    skygold16
    Helper II
    3 years ago

    Did anyone find any solution for this? 

     

    Both MS and Databricks not helping enough on this and hand bowling it to each other. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    are you using a Power BI gateway in between? If so make sure you have installed the latest version. We had the very same issue and it was fixed with the November release. Hope that helps for you too 🙂

    • Fromit87's avatar
      Fromit87
      Advocate I
      3 years ago

      Thanks Anonymous, lucky you - unfortunately we have the latest Gateway release running, but I still get the error when merging databricks with other non-databricks sources... only works with parameter EnableQueryResultDownload="0"