Migration of Power BI Reports from SQL Server to Databricks
Hariharan Sambath
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
✨Transform Your Data into Insights. Contact me now!✨
Like this project
Posted Feb 24, 2023
Migrate the data source of Power BI reports from MS SQL Server to Azure Databricks.
