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 ,
If you are using Fabric I would suggest that you use a deployment pipelines to make the deploy to the final workspace, that will allow you to define the correct workspace and lakhouseid without the need to do it at the report level.
https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/get-started-with-deployment-pipelines?tabs=from-fabric%2Cnew-ui
You need to define the rules for the semantic model in order to get the correct values
https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/create-rules?tabs=new-ui
Thanks Miguel,
That could work, but we don't really use deployment pipelines for various reasons.
Are we saying that parmetarisiation of direct lake models is currently not supported then?
Thank you,
WJ
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.