Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 structure, but with different data sources. When we update our PowerBI .pbix file and send it out to everyone that uses it, and they change the data source they work against, everything brakes, and they manually have to edit the sources using the advanced editor.
Example query
Query;
let Source = AzureStorage.Blobs("https://example.blob.core.windows.net/development"), #"https://example blob core windows net/development_data1/data1 json" = Source{[#"Folder Path"="https://example.blob.core.windows.net/development",Name="data1/data1.json"]}[Content], #"Imported JSON" = Json.Document(#"https://example blob core windows net/development_data1/data1 json",1252), #"Converted to Table" = Table.FromList(#"Imported JSON", Splitter.SplitByNothing(), null, null, ExtraValues.Error), in #"Converted to Table"
We do have the standard source query, so maybe it's possible to dynamically refer to that one? If yes, how do we do it?
Any answers would be much appreciated 🙂
Solved! Go to Solution.
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)&"")
In theory, yes, you could use query parameters or something along those lines. But not enough information to really go on.
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)&"")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |