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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

hi Fromit87 ,
Thanks for your reply. I'm aware of the parameter EnableQueryResultDownload="0".
Microsoft & Databricks suggested to set this parameter in order to get it running. However when you set this parameter you disable Cloud Fetch and you get very slow performance importing data. 

 

I noticed that the issue doesn't occur when I go through the public internet (withouth any gateway in place and connecting directly from PBI service to databricks).

 

Let's hope that Microsoft updates the driver in the next release.

skygold16's avatar
skygold16
Helper II
3 years ago

I am having the same issue and adding that parameter works fine desktop however just for ~25k records it takes about 2 mins to refresh the power bi service which is not at all acceptable performance. 

 

I have been following up with MS team and Databricks team on this and have been getting the same answer to add the parameter. Due to security reasons, I cannot connect it without the gateway. 

 

Are you able to confim how slow the performance was in your case?