cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
janwoj
Frequent Visitor

PowerApps connection to Azure Databricks

Hello,

 

​I would like to read Databricks delta table to show the data on the screen using PowerApps gallery and insert new records to the same table also. What is the best method to achieve an efficient connection and perform above?​

Cheers

2 REPLIES 2
bapala
Resolver III
Resolver III

Hi @janwoj,

 

I believe, at this moment there is no standard connector available from Power Platform to connect with Azure Databricks (may be possible with a custom connector but not tried). See below post for more details.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Integrate-Power-Apps-with-Azure-Databricks/t...

Hope this helps.

janwoj
Frequent Visitor

Hello bapala,

 

Thank you for your message. I checked the materials you shared. Cdata offers nice solutions but paid - unfortunately this is a limitation for me.

Custom connector is an interesting idea also. As far as I know such connector should be based on REST API. I am struggling a bit with this right now and I have some worries. My need is to make a connection with many, large Databricks delta tables. Passing such heavy data in json payloads through the http requests calls sounds like a nightmare - in terms of performance and rows of scripts that I'll have to prepare to handle those requests. 

 

That's why I asked about an efficient connection. 🙂 Let's have this discussion opened. Maybe anyone will come up with a better solution.

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,786)