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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (1,662)