How to change source for table in DirectLake over OneLake using XMLA?

[jaryszek]

Hello,

I am using  Tabular Editor 3 and want to change table source from Onelake3 into OneLake1. 

How to make this? 
They are in the same workspace. 

p.s. what if they would be in different workspaces?

Best,
Jacek

[AmiraBedh]

Hello !

Thank you for posting on Microsoft Fabric community.

In Direct Lake, each table has one entity partition and its expression source is just the name of a OneLake data source in the model. So you either create a new OneLake data source that points to the other lakehouse, then point the table partition at it or edit the existing data source to point to the other lakehouse.

[jaryszek]

hello,

"So you either create a new OneLake data source that points to the other lakehouse then point the table partition at it"
thanks, how can i do this in tabular editor 3? 

"or edit the existing data source to point to the other lakehouse."
How can i do this in TE3 step by step? 

Best,
Jacek

[v-priyankata]

Hi @jaryszek 
This is related to Tabular editor, please contact them for the issue Contact Tabular Editor ApS

Thanks.

[jaryszek · Accepted solution]

For all users:

just change the names in proper fields, refresh and do this without opened power bi direct lake semantic model (to not overlapped changes, I had error connected). 

Best,
Jacek