Forum Discussion
Binding an Existing Report to Direct Lake
- 1 year ago
Hi PeterMc
I havent done it myself but assuming that the direct lake semantic model has the same set of columns, data types, column names, measures and relationships as the one built in desktop, you can delete all tables from the desktop and then connect to the the direct lake semantic model. The method is similar to converting an existing report to live connection without downloading a live connection copy from the service.
- 1 year ago
PeterMc
I have done a few import model migrations to Direct Lake to some of my clients. I used the Symanticlink libraries to achieve that. the process is pretty easy as all functions are built into a notebook. Make sure your model is meeting the requirements prior to migration.
Follow this link: https://github.com/microsoft/semantic-link-labs
Hi PeterMc
I havent done it myself but assuming that the direct lake semantic model has the same set of columns, data types, column names, measures and relationships as the one built in desktop, you can delete all tables from the desktop and then connect to the the direct lake semantic model. The method is similar to converting an existing report to live connection without downloading a live connection copy from the service.
- PeterMc1 year agoFrequent Visitor
Hi Danextian
That worked - I saved my existing report under a different name (just with a _DL at the end) cut the table links to the old semantic model and then reconnected to the Direct Lake model. As you mentioned all the column and column names etc need to be the same and I was quickly able to pick out where they didn't match as the visualisation didn't work.
Thanks
Peter Mc