Data Source Parameters in Direct Lake mode

[wojciech]

Hi Community,

I’m trying to find out whether it’s possible to parameterize a Direct Lake connection. From what I can see, once connected to a Lakehouse in Direct Lake mode, there’s no option to edit Power Query and add parameters.

Ideally, I’d like to parameterize the Workspace ID and Lakehouse ID in the connection path.

expression 'DirectLake - FlowMonitoring' =
    let
        Source = AzureStorage.DataLake(
            "https://onelake.dfs.fabric.microsoft.com/r0000d91-0000-0000-9745-4rty2fa0e23c/bb2xz8c3-0000-0000-0000-0056c4f0000", 
            [HierarchicalNavigation = true]
        )
    in
        Source

I took the above from the TMDL view. However, I’m not sure what the best way is to repoint my Direct Lake model to a different Lakehouse when promoting the model across workspaces.

Any advice would be much appreciated.

Thanks,
WJ

[MFelix]

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-pipel...

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

[wojciech]

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

[MFelix]

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?