Forum Discussion

bimorten's avatar
bimorten
Frequent Visitor
8 years ago
Solved

Dynamically change data source / relative source paths

Hello   Is it possible to dynamically change the source data reference in queries, when updating a data source? Or even better, use relative paths? We are multiple people working on the same data s...
  • bimorten's avatar
    bimorten
    8 years ago

    Thanks, you put me in the right direction :) 

     

    The solution was pretty straight forward.

     

    Instead of hardcoded values, like this;

     

    = AzureStorage.Blobs("https://exampleblobstorage.blob.core.windows.net/"container")

    You can refer to the parameters using "&Text.From(ParameterName)&"

     

    = AzureStorage.Blobs("https://"&Text.From(StorageAccountName)&".blob.core.windows.net/"&Text.From(ContainerName)&"")
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

In theory, yes, you could use query parameters or something along those lines. But not enough information to really go on.

bimorten's avatar
bimorten
Frequent Visitor
8 years ago

Thanks, you put me in the right direction :) 

 

The solution was pretty straight forward.

 

Instead of hardcoded values, like this;

 

= AzureStorage.Blobs("https://exampleblobstorage.blob.core.windows.net/"container")

You can refer to the parameters using "&Text.From(ParameterName)&"

 

= AzureStorage.Blobs("https://"&Text.From(StorageAccountName)&".blob.core.windows.net/"&Text.From(ContainerName)&"")