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