Changing source for reports SQL Server to Databricks

[GavC]

Hi,

I have a report that is pulling from a SQL Server data source.
In Azure Databricks, I have shaped the tables to be exactly the same as those from SQL Server.

I now want to switch the data source for the reports from SQL Server to Azure Databricks, and then with little or no additional work, for the report to seamlessly work. The only thing that has altered is the source of the data, so I see no reason for this not to work.
It would be the same as just changing an excel sheet for example.

However, I have tried and failed...
It seems like I have to rewrite the report rather than just swap over the source, I was hoping that someone has atried this also and has found a solution that I am missing.

Many thanks

[Cookistador]

How did you try to achieve this ?

I never used databrick to build a report with Power BI, but it should work

My suggestion would be to export databricks, making the same transformation that you did in your SQL Server and then compare the difference betwween the both in Power Query with advanced editor