Migration of Power BI Reports from SQL Server to Databricks
Hariharan Sambath
Data Engineer
Data Visualizer
Database Specialist
Microsoft Power BI
Microsoft SQL Server
Python
Project Description:
The main goal of this project is to change the data source of existing Power BI reports from MS SQL Server to Azure Databricks.
Project Tasks:
- 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.
Project Stack:
- Python
- SQL
- Azure
- Databricks
- MS SQL Server