Model from databricks into dataverse and grid control

(0) Share

Report

Posted on by CU02111856-0

Hi
is it possible to use the newest connector for databricks in Dataverse?
I need to create a power app for users to edit/add/delete records from multiple tables

the grid control in model driven app looks exactly like what i need (with build in filters, search, add edit, delete) and ability to use PQ for bulk append data into tables

is it possible to use such conection and synchronize Databricks <-> Dataverse <-> powerApp where any CRUD operations in powerapp would update data in the source?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @CU02111856-0

Yes, you can setup Virtual Tables in Dataverse, that point to Databricks and then use Power Apps that connect to Dataverse which then see the virtual tables from Databricks

Depending on how you are exposing Databricks you will either use the SQL Connector or a custom connector as you can use APi's and JDBC.

You then have to setup Entra for App registration etc etc again depenidng on which you are setting it up for,.

Also note, when I say Power Apps, I mean Model Driven / Canvas or Power Automate

Hope that helps.

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

2 people found this reply helpful.

Was this reply helpful? Yes No
CU02111856-0 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot for your reply!
i would like to use the new connector

https://www.databricks.com/blog/introducing-azure-databricks-power-platform-connector-unleashing-governed-real-time-data-power

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @CU02111856-0

So it will work for sure in Power Automate and a Canvas App, I would have to check if you can use it to create a Virtual Table in Dataverse if you want Dataverse to see it. I have not tried that yet, but for sure in PA and CA it will work.

Was this reply helpful? Yes No
CU02111856-0 4 on at

Like (0)

Report
Copy link

Link copied!
Yes 🙂 I’m already trying with a canvas app, but a model-driven app seems like a much better fit for my scenario.

The end users need:

an Excel-like grid with column filtering and sorting,

the ability to add, delete, and edit records,

many dropdown fields connected to dictionaries stored in Databricks,

export to Excel,

and bulk upload from Excel files.

Additionally, I want to have a navigation panel with a list of tables and a single gallery that dynamically updates based on the selected table — since new tables will be added over time.

With model-driven apps and Dataverse, most of these requirements are covered out of the box (rich grid, built-in filtering/sorting, Excel export, Power Query/Dataflow integration, etc.).

In the canvas approach, I’m struggling mainly with dynamic gallery, and bulk upload part. I trigger a Power Automate flow that runs a Databricks notebook, but passing the Excel file as a parameter is problematic — notebook parameters (text/widgets) have practical size limits, so multi-MB files aren’t reliable.

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @CU02111856-0

I answered your original question but continuing to answer without you marking answers or liking them etc just stops the motivation, we do this for free so if you are just asking and asking and never supporting us, its loses our interest.

Was this reply helpful? Yes No