Forum Discussion

jaryszek's avatar
jaryszek
Super User
10 months ago
Solved

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

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...
Need Help
  • jaryszek's avatar
    jaryszek
    10 months ago

    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

AmiraBedh's avatar
AmiraBedh
Super User
10 months ago

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's avatar
jaryszek
Super User
10 months ago

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