Migration of Power BI Reports from SQL Server to Databricks

The main goal of this project is to change the data source of existing Power BI reports from MS SQL Server to Azure Databricks.

Load the required table data into the delta table from the MS SQL Server database.

Create the views in Azure Databricks that are required for creating the dataset in Power BI.

Create a new dataset using Azure Databricks as the data source.

Connect to Azure Databricks from Power BI and develop new reports from the dataset that is created.

Publish the reports to Power BI Workspace.

Python

SQL

Azure

Databricks

MS SQL Server