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

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

jaryszek — Mon, 29 Sep 2025 15:04:46 GMT

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

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

AmiraBedh — Mon, 29 Sep 2025 16:39:05 GMT

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.

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

jaryszek — Tue, 30 Sep 2025 07:00:06 GMT

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

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

Anonymous — Wed, 08 Oct 2025 12:28:44 GMT

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

Thanks.

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

jaryszek — Thu, 09 Oct 2025 09:02:34 GMT

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