Forum Discussion
Data Source Parameters in Direct Lake mode
Hi wojciech ,
The option to directly do it is not available has you say however you can do it using a notebook and semanticlink labs, this is a small script that will rebind the workspace and dataset
Check this video below and the script:
https://www.youtube.com/watch?v=hlY4JhqU1nc
https://github.com/microsoft/semantic-link-labs/tree/main/notebooks
You can then use all sort of options to run this notebook mannually or using a file with those configurations.
Hi wojciech ,
Just to understand a little bit better when you refer to parameters in a connection to Direct lake you are refering to a Report connected to Direct Lake semantic model, or do you want to parameterize the Direct Lake semantic model itself?
Sorry for the late reply.
I meant semantic model connected to Fabric lakehouse in my case.
Ideally, I would like to parametirise workspace id and lakehouse id, but you can't edit Power Query in Direct Lake mode.
Thank you,
WJ
Hi wojciech ,
The option to directly do it is not available has you say however you can do it using a notebook and semanticlink labs, this is a small script that will rebind the workspace and dataset
Check this video below and the script:
https://www.youtube.com/watch?v=hlY4JhqU1nc
https://github.com/microsoft/semantic-link-labs/tree/main/notebooks
You can then use all sort of options to run this notebook mannually or using a file with those configurations.