Changing data source from DataBricks Unity Catalog (import) to semantic model

[martan]

Hi,

I have a PowerBI report created which connects to Databricks Unity Catalog as source in import mode.

However, this is was made somehow by mistake cause the proper way of working in the company is to create reports based on prepared PowerBI semantic model, not touching the source data directly.

So now I would like to easily change source of the tables in current model from Databricks to semantic model.

The thing is that in the report these tables also contain some measures, calculated columns so if I simply delete the table and load it from semantic model, I loose this additional structure and I need to rebuild them manually. 

Is there a way to replace source of table in this case without recreating them? We try to avoid doing more manual work.

Maybe through PowerShell script?

[Anonymous]

Hi @martan ,

As of my knowledge, there is no direct feature to switch a data model from Import to DirectQuery/LiveConnection once the dataset has been loaded into Power BI. 

Consider voting for similar ideas:

Import to DirectQuery

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum 

[rajendraongole1]

Hi @martan - can you please check the below resources:

Power BI Cmdlets reference | Microsoft Learn

Tabular Editor - SQLBI

To change the source of tables in a Power BI report from Databricks to a semantic model without losing the existing measures and calculated columns.you can change the source for the table(s) from Databricks to the semantic model. However, if you change the source directly, it may lead to data type mismatches.If there are changes in column names or types, you may need to adjust your measures accordingly.

Tabular Editor allows you to manage and edit your model in a more structured way, enabling you to bulk update measures if necessary.

Hope the above information and reference links helps.