Hello Community,

We are currently working designing Power BI reports, the data source is databricks. We have all our reporting data in bronze/silver layer of databricks. we want to create summarized/aggregated tables in Gold layer and we want to connect to gold layer tables from Power BI.

Currently we are looking for solution design help in moving data from bronze/silver layer to gold layer as efficient as possible. This is going to near real time solution. we have schedule the pipelines as well for incremental loading.

please share your suggestions and let us know incase of questions.

Thanks in advance.

Thanks

Venkat