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